I've got a report that's centered around line items. They want it grouped by each category of line items, but the categories are in the same table as the details.
There is a field called "PARENT_YN" to differentiate the detail lines and the category lines... so if "PARENT_YN" = "Y" then that's a category.
I can't bring the table in twice and join it with the criteria set to "PARENT_YN" = "Y" (no data).
Any suggestions?
There is a field called "PARENT_YN" to differentiate the detail lines and the category lines... so if "PARENT_YN" = "Y" then that's a category.
I can't bring the table in twice and join it with the criteria set to "PARENT_YN" = "Y" (no data).
Any suggestions?