I am currently accessing cached CR instances via an opendocument call (from XC dashboard) that filters the records on display using &sf in the opendocument call to display only the records that match the criteria selected by a user. These instances are refreshed weekly and accessed hundreds of times throughout each week.
I have new requirements where the users want the records in the CR instance to be sorted differently depending upon what they have selected. I have been trying to do this with a formula based on the recordselection() and while this works fine if I am refreshing the report, it does not when I am filtering a cached instance because the recordselection() is not being evaluated at the proper time (I suspect). If I evaluate the recordselection() whileprintingrecords then I can get access to the selection filter value but I cannot group on the dependant formula - I get the error "Group specified on a non-recurring field".
Does anyone have any ideas on how I can accomplish this goal without forcing a refresh on the report (which is not an option based on volume / performance needs)? I am happy to provide more detail if needed.
Thanks in advance...