Recent content by mike99

Diana this is the format I use for resetting my Shared variables and it seems to have worked up to now. WhilePrintingRecords; Shared numberVar Var1:= 0 I reset my shared variables in the main report and in the header of the same group where I run the sub report Hope this helps Mike

I'm new to this and most of what has gone before here is way over my head but would it be correct for me to interpret it as follows: I have 40 consecutive subreports that have to run under Ver7.0 and each one has to start on a new page. Are you telling me that it is not possible to suppress the...

Thanks I have switched to the earlier post on the subject "Suppressing a subreport". I'm not sure what the correct procedure is here. Thanks Mike

I have subreports that I want to suppress when they are blank. I have ticked the "suppress Blank section" box both in the main report and in the sub report but the blank pages still appear. New page after is also ticked in the main report. Thanks for your help Mike

Thanks, The client wants a planning calender in advance where the orders due for delivery each day are printed. I have to design something that will print the order numbers and customer name in a "box" and put the date on top, It sounded so simple! Let me know what else I can tell...

I have data that I need to print in columns by date but the date must be variable. I thought of making a subreport for each date and I could then pass that date to the subreport with a Shared Date variable. I can get the variable date into the subreport but I cannot access it to use for...

Thanks I appreciate the help Mike

Ken Thanks, here are the other formula's Formula 1 is @Sum of Group3 Airpoints Formula 2 Name: @AirMilesCustTotDisp WhilePrintingRecords; Global numberVar CustTot ; CustTot := CustTot ; CustTot Formula 3 Name:@AirMilesCustTotcombDisp WhilePrintingRecords; Global numberVar CustTotcomb ...

Ken In the group 2 and 3 footers I calculate values that are dependant on the amount of the order and the type of product purchased to award aeromile points to customers. The formula in the Group 1 footer adds up the points calculated in the formula's in the Group 2 and 3 footers. I'm not sure...

Ian Thanks, I did try that but it seemed to make no difference Mike

I have a report with 3 groups; Group 1 = Customer Group 2 = Order Group 3 = Invoice I want to format the Group 1 header (to suppress it) based on results determined by a formula in the Group 1 footer. There is a formula in the Group 1 footer that adds results from formula's in the Group 2 and 3...

Sorry I have just checked again, in Ver 8.5 the results of the formula in the Grp 1 footer does not display in the Grp 1 header either. Any way of correcting this? Thanks Mike

I have a report with 3 groups; Group 1 = Customer Group 2 = Order Group 3 = Invoice I want to format the Group 1 header (to suppress it) based on results determined by a formula in the Group 1 footer. If I run it at the office on Ver 8.5 with test data it displays the result of the formula in...

Thanks Glad that it can be done, I'll give it a try and let you know Mike

I have a situation where I am printing Invoices. If the product sold meets certain criteria a new report has to be created after the invoice is complete on a new page and before the next invoice is printed. Any suggestions? Thanks Mike