Home
Analytics
Birt Grouping Question
Mitchell Dawkins
<p>In my BIRT Report I am having issues with Groups been broken up into smaller groups. Im not sure what setting I would look at to make sure the grouping specified with in the dataset is the other grouping that is taking place and nothing beyond that. </p>
Find more posts tagged with
Comments
jfranken
<p>Hi Mitchell,</p>
<p> </p>
<p>Let me try to clarify your question with an example. Say your query is "select company_name, country from customer". You place a table on the report and group by "country" in the table. The issue you are encountering is that you are seeing multiple groups for the same country on the report? Instead of:</p>
<p> </p>
<p>Canada</p>
<p> Company A</p>
<p> Company B</p>
<p> Company C</p>
<p> </p>
<p>You're seeing:</p>
<p> </p>
<p>Canada</p>
<p> Company A</p>
<p> Company B</p>
<p>Canada</p>
<p> Company C</p>
<p> </p>
<p>If that is what's happening, it could be an issue with the data. Maybe there's a non-visual character that is causing the two "Canada" entries to be recognized as different values and thus being created as separate groups. If you run the query in a query tool and add a "group by" clause, do you see the same groupings? That would confirm the data issue.</p>
<p> </p>
<p>In terms of grouping defined for the table in the report, select the table in the layout and click the "Groups" tab. Is there only one group defined? What is the expression for "Group On" in the Group editor?</p>
<p> </p>
<p>Regards,</p>
<p>Jeff</p>
Mitchell Dawkins
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"><span>This would be what i'm dealing with and there inside of the grouping tab there is some further grouping example following the company example given: </span></p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">Within Company C : </p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">Dept 1 </p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"><span>Dept 1 </span></p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">Dept 2</p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">Dept 3</p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">Where Dept 1 should all be within the same grouping. </p>
jfranken
<p>I can't follow your first sentence. In the example, both rows containing Dept 1 are in the same "Company C" group. if you want Dept 1 to display as a single row inside the group then you need to create a second group. Make the top level group based on Company and the second level group based on Department.</p>
<p> </p>
<p>Regards,</p>
<p>Jeff</p>
Mitchell Dawkins
<p>My apologies i should use better punctuation. With the Dept 1 example Both Dept 1 should all display as one Dept 1 but they are displaying as 2 different departments, despite the fact the they meet all the same criteria to be grouped together. Earlier you said it could be a data issues meaning an issue in which the separation is due to a small difference in data. </p>
jfranken
<p>For the situation you're describing, I believe you just need to create a second group to group by Department. If you still see multiple entries for Dept 1 after creating the second group, then there might be an issue with the data.</p>
<p> </p>
<p>Regards,</p>
<p>Jeff</p>
