I'm sure this has been asked and answered many times - did a search but no joy. Have a group footer with a number of shared variables being displayed. One is a margin %. I would like to sort the groups descending by this margin %. I can't seem to insert a summary based on it so can't use the group sort expert. Any suggestions?
Abhilash - The formula uses shared number vars (3): (A - B - C) / A. The "B" value is from a subreport. I could use running totals for "A" and "C" as it turns out. Looks like I might need the "busy" workaround you mentioned.
Hi Brian,
Unfortunately, summaries can't be inserted off of shared variables.
Could you post the formula here and we can see if that can be converted to use global variables (with no print time functions). Of course, all this if you're not using shared variables to return data form the subreport.
If you're using shared variables to return data from a subreport, then you have a very 'busy' workaround to implement!
-Abhilash
Add a comment