nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Does BIRT Support Sub-Total Columns?

andycz

I asked the question on <a class='bbc_url' href='http://stackoverflow.com/questions/6783894/does-birt-support-sub-total-columns'>Stack Overflow</a>, then I found this group. Looks like I found the experts! 
 
 
We're trying using BIRT to design a specific cross-tab report and are not having much luck. The data, a time series of values with some attributes has the following shape: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
Data

AttributeA,AttributeB,AttributeC,Date,Value
A1,B1,C1,Jan-1-2010,25
A1,B1,C2,Jan-1-2010,25
...
</pre>
 
I've gone ahead and created a cube for the data source and grouped by all the attributes which works great, but I'm not sure if/how I can summarize by the date. Here's an example of what I'm trying to produce: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
Report

Jan Feb Mar Q1 Apr
A1, B1, C1 25 25 25 75 33
C2 25 25 25 75 33
C3 25 25 25 75 33
Subtotal: 75 75 75 225 99

B2, C1 50 25 25 75 33
C2 50 25 25 75 33
Subtotal: 100 50 50 150 66

A2, B1, C1 25 25 25 75 33
C2 25 25 25 75 33
</pre>
 
As you can see, I want my values summed by month in the first three months, then I want a Q1 sum, and so on. Is this kind of thing possible with BIRT, short of writing a bunchof Javascript? If so, can someone point me in the right direction?

Find more posts tagged with

Comments

mwilliams

What is your version? There is sub-totaling in crosstabs. I'm not sure if this has been for all versions of crosstabs, but I think it should do close to what you're asking. If not, I think we could achieve this with a crosstab embedded into a grouped table. The way you set up totals and subtotals is by clicking on the icon next to the dimension field in the crosstab and choosing to add a total. In the totals editor, there are options for grand totals and subtotals. Let me know if this works for you. If not, I'll help you recreate what you want with as little script as possible.

andycz

We're not version constrained as we prototype this out, so I just grabbed Indigo. I see that there are sums and such, but I'm having trouble with getting the dates across the top. You mention "...could achieve this with a crosstab embedded into a grouped table". Can you elaborate?

thuston

If you switch to XML Source what is the version number on the 3rd line? 
<property name="createdBy">Eclipse BIRT Designer Version 2.6.2.v20110326-0603 Build <2.6.2.v20110326-0603></property> 
 
In the attached screen you can see that when you add a Date to the Cube Group, it should automatically ask you what levels you want to group the date on. 
If it's not doing this, your Date may actually be a String. Go back to the DataSet and create a computed column to read the String and output an actual DateTime. 
<pre class='_prettyXprint _lang-auto _linenums:0'>new Date(year:number, month:number, day:number, hours:number, minutes:number, seconds:number, ms:number)</pre>
It uses 0 based months so new Date(2010,1,1,0,0,0,0) == Feb 1, 2010 12:00AM

mwilliams

If the issue you're have getting the date across the top has to do with dates, months, etc missing because of a lack of data for all date values, you can add a scripted dataSet that fills all the dates in your range and then join it with your data to force all dates to show. If we can get this done without embedding crosstabs into tables/grids, it'll be a lot less messy!