First off, I am new to Discoverer Plus reporting…. Your suggestions are appreciated.
I have a cross tab report that I would like subtotaled by one group based on user selected
parameter, the other group (all other records in report) subtotaled. And grand
total of both groups.
I’d like to user to select values (parameter from list) and
then subtotal the selected and non selected values with a grand total below.
I have added a parameter to select values from list. When
the parameter values are selected, it appears to be on the worksheet level and
I am unable to retrieve the rows that do not correspond to the selected values
for the other grouping.
Is there a way to subtotal records in two groups;
Group 1 records for user selected parameter values Subtotal
Group 2 all other records in report Subtotal
GRAND TOTAL
My parameter selection is on the worksheet and limits the records on the report and does not allow the second group.
Can this be accomplished with Sub query? Sub report? Parameter values called in a calculation field?