Most of my experience with VReports comes from experimentation and/or rollover knowledge from Crystal Reports and I have designed some very extensive and complex financial reports for clients, but I think I am not being very efficient when it comes tabulating totals, end results, and percentages, etc...
I do this with a bunch of sub reports - but I am wondering if there is a better, more efficient method:
In my report I pull in all fields from VDB, and then just use the data as I need in the report. I have to use many sub reports to do different counts and sums on data based on different criteria.
fldA is amount and fldB is a categoryType (like cost, cost basis, account fee, etc)
Right now I band out the report with these fields for all the records in the range of the query, such as 2015 or 2016...
I have to use sub reports to do counts of the different categories and sums of fldA per category. Which winds up being near 19 different subs in my report.
I know I can do a sum, count for the whole report in the group footer, but I can't break them out by category (or, put it this way - I have no idea how to do this by category if it is possible).
My question concerns expressions in a footer - can I use an expression in this manner:
SUM ( fldA = 'Category') or COUNT ( year(fldA) = 2016)
or some other SQL expression like SUM(SELECT fldA FROM tblA WHERE category = 'Whatever')
How can I write expressions to do this? Is it possible?