Say I use the report builder with the customer table. I want to insert a grouping for the regions-field of the customers. The report that will be created by the wizard will group all customers but all customers with region [empty] will not be shown as [empty] is no member of the regions-table.
How can I make it to easily also include the empty-value-entries in my grouping?
Date
Votes
4 comments
-
Jet Reports Historic Posts When using the region field from the region table for grouping, [empty] will not show up.
If you are using the region field from the customer table instead, [empty] will show up.
But…..
The first option gives you the ability to show regions with no customers.
The second option does not do that.
rmw -
Jet Reports Historic Posts Yes, but as far as I see it, the Report Builder automatically configures the formulars that way that empty values do not appear. At least I found no way to make e.g. a list of customers grouped by regions including customers with regions-Code [empty]. Or am I just overworket that I can't find a way to do that?? ;-)
My question to the community is if anybody sees some way to do this out of the Report Builder. Maybe the Jetreports Team also can think about a way to solve this problem as many of my clients fight with this task and there are many cases where you need also [empty]-code-values to be grouped. -
Jet Reports Historic Posts Hi Michael,
Currently I don't think there is any way to do this from the Report Builder. Each grouping created by the Report Builder is based on the records from a particular table. In this case the Region table only contains actual regions, not "blanks" so when grouping customers by the Region table, you would not be able to see customers with a blank region. You could probably modify the report created by the Report Builder to do this although I understand you might be reluctant to do this.
Another way you could accomplish this task is with the Report Wizard. You could create a report with the Report Wizard which groups customers by the region code on the Customer table and thus includes the blank region codes. I realize there are other limitations to using the Report Wizard, but it would accomplish this part of creating the report you are looking for.
Regards,
Hughes -
Jet Reports Historic Posts Just thinking out loud….
- 1. Would it be possible to add to the report, before of after the grouped by region list, only the customers with an empty region? Not sure if the report builder can do this.
2. Or can you use something like NP("Join") to create an array with the regions from the region table and add a blank to it. And then use the result for the grouping statement.
rmw
Please sign in to leave a comment.