crystalpro
Technical User
I have a report that groups by SHOWROOM and by PRODUCT LINE. Is there a way to have the transactions for a blank (empty/no showroom)SHOWROOM print at the end of the report instead of the beginning?
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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Send "Blank" Field to end of report
- Thread starter crystalpro
- Start date
- Status
You could group on a formula instead of the field, as in:
if isnull({table.showroom}) or
trim({table.showroom}) = "" then
"ZZZZZ" else
{table.showroom}
Then remove the group name from the group header and replace it with the field itself.
-LB
if isnull({table.showroom}) or
trim({table.showroom}) = "" then
"ZZZZZ" else
{table.showroom}
Then remove the group name from the group header and replace it with the field itself.
-LB
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question