I tried the "WhilePrintingRecords" in the subreport, but the way I have it setup it wouldn't work. I tried passing the formula back to the main report and then setup the "WhilePrintingRecords" formulas and it almost works. For some reason my top record is 0.00 and it leaves off my last record...
I have a quantity field in my main report that I passed off to my subreport. In the subreport I took the quantity field and placed it in a formula ({@Valuation Material Costs}*{@Qty from Main Report}). This is placed in the Group Header. Now I want to setup a grand total of this formula but I...
I set up a number field as one of my parameters and appended all database values. However, I can not figure out how to change the format. The current format is 4,611 and I want it to display as 4611 in the parameter list. How do I make this change? Any help will be greatly appreciated.
I have more than one record in my database, but I may only need 5 labels for 5 motors that need to be shipped. All 5 motors will be assigned a serial number, so I need to print 5 labels. I open up my report, choose the part number, and enter the serial numbers I need to show on the label. Here...
That is my main issue with this; I don't have anything that determines the number of records in my report. As it stands it will only print one record. I was hoping that when I setup the serial number as a range parameter that it would print that range with the appropriate numbers. I'm at a loss...
I have copied my label to additional detail areas and used the code above to number. Not the greateast option, but it is working. How can I setup an ending number?
We don't have a serial number in the database. This number is manually created and hand written on a log. The label we're making has to have the number in order to be valid.
I am selecting records based on a part id. Here are the parameter prompts when I run the report.
Part Id - drop down menu tied to the part table
Serial Number(s) - manually entered (i.e.123-125)
Cust Part Id - manually entered
We set the starting number at 123. The label showed 124.
We need to see each number, pluged in to the range by the enduser, on each label. We want the user to pick the range at report open, say 500-510. When the report runs we want it to return 10 labels numbered 500, 501, 502, etc..
The user will need to enter the range of numbers when they fire off the report. The numbers will change depending on what part number they need a tag for. So one part may start with 512 and end with 515, the next start at 801 and end with 1001, etc..... Our users do not have access to the report...
I created a label and setup a parameter where I just type in a number I want on the label. This works great, but there will be times when I want to print a range of numbers, one for each label. For example, my start range is 123 and my end range is 124. When I changed the parameter to a range it...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.