Hello i have a list report with totals for certain columns but i need to show one of these totals in another part of the report in a table below the list or in another query\tab, is this possible as i have tried all sorts of ways and i keep getting a 0 value although there is a value in the total column.
Many Thanks
Chris
Did you try a singleton?
Hi Yes i did this but in the end i found the solution in the below data item.
total([Dataitem] for report)
it was as simple as that so now i can total in a table below the page. Not sure how you would get this into another page tab though, i will have to work on this.
Thanks
Chris