I need to create total and grand totals for a report. The problem is that i want these totals to print out in Header section rather than footer. Is it possible and how can i do this ?[B)] Thanks in advance
You can do it if you count them before DataItem. So you can make another DataItem with same properties without any section. Define needed total fields and totals will be ready.
If execution time isn’t a problem you could run the report twice by having an Integer DataItem with the DataItemTableView property set to “SORTING(Number) WHERE(Number=FILTER(1…2))”. This is the same idea as the CopyCount on invoices and the like. You’d need to use ShowOutput(Integer.Number=2) to hide the output on the first loop,then by the time the second loop starts you know exactly what the totals will be and can print them in the header. regards, Dan.