I have a subreport that passes a variable to the main report. I use this shared variable in my main report in a separate formula. I would like to sort based on the result of that formula, but since it uses a variable I cannot choose it in the sort expert. Does anyone have a work around for this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sorting on a shared variable
- Thread starter Moongirl
- Start date
You need to get the value of that variable via your SQL rather than via the subreport. The subreport gets processes during a formatting stage (report pass) when it's too late to sort. Hence, the shared variable can't be used as a basis for sorting.
If you explain the situation in more detail, it may be possible to suggest an appropriate SQL approach.
Cheers,
- Ido
p.s. If this is a one-time report, you could also export the data from the report, and use this processed data as the basis for a second report where the data can easily be sorted based on any of the resulting columns.
Awkward, but doable...
ixm7@psu.edu
If you explain the situation in more detail, it may be possible to suggest an appropriate SQL approach.
Cheers,
- Ido
p.s. If this is a one-time report, you could also export the data from the report, and use this processed data as the basis for a second report where the data can easily be sorted based on any of the resulting columns.
Awkward, but doable...
ixm7@psu.edu
- Status
Similar threads
- Locked
- Question
- Locked
- Question