Dynamic sort on CR instance accessed via opendocument/&s

building reports crystal reports
1

I am currently accessing pre-cached CR instances via an opendoceument call 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…

steve :us: (BOB member since 2009-01-16)

2

You might want to make another copy of the report that also runs weekly and is sorted different. The sort they select is really which report they want.

tbrady (BOB member since 2007-09-25)

3

Unfortuneately, creating a new version of the report for each sort is not an option because there are several sort orders and there are over 15k instances of this report created weekly.

steve :us: (BOB member since 2009-01-16)

4

Nothing from anyone? “This is not possible - stop wasting your time” would be valid too :slight_smile: I unfortunately believe this may be the case… but validation would be great!

steve :us: (BOB member since 2009-01-16)