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; } } }

CrossTab group by month year

Ruby

Hello everyone,

i am new to BIRT and i am stuck with a report design. i am attaching a print screen of my report alongside. From what i have understood about BIRT till now, one cannot display data from two separate data cubes in a cross-tab (correct me if i'm wrong pls)

i wanted to know how i can display all months of a year in my report, even when no data exists for a particular month.

for example, i have data upto the month of July only but i want to display the rest of the months too.

I would really be grateful if anyone could help me with that.

Thank you in anticipation...

Find more posts tagged with

Comments

mwilliams

If you have all the months represented in a scripted dataSet or in a flat file, you can do a joint dataSet to force all the months to be in your resultset. Then, you can use this joint dataSet to show these values in your crosstab.

Hope this helps.

Ruby

thanx 4 z reply williams...actually i did try the joint data set (i did it on the month) but the months still get skipped.

do you think its because i did a filter on the cross tab to display the summary of only 4 column data?

If i dont filter all the months are displayed but then the columns are too cluttered

For the joint data set, i still need to do the grouping by year month on my data cube rite?

mwilliams

If you do actual dates, you'll have to do month and year. If you extract the month and year into their own columns in the dataSet, you can use these columns, but it'll work out the same. Maybe I'm not sure what you're asking. If you recreate this with the sample database how you're doing it, I can see exactly what you mean.

Ruby

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="82911" data-time="1316204646" data-date="16 September 2011 - 01:24 PM">
If you do actual dates, you'll have to do month and year. If you extract the month and year into their own columns in the dataSet, you can use these columns, but it'll work out the same. Maybe I'm not sure what you're asking. If you recreate this with the sample database how you're doing it, I can see exactly what you mean. </blockquote>
 
 
Actually i have to group contacts by Year/Month and Origine. That is all Contacts with a particular OrigineId 
and with creationDate in a particular Month for year 2011 
 
i have attached a new printscreen of my crosstab. 
 
 
The columns in blue are Origines. 
 
Nb Adresses refers to total Number of contacts with creation date in a particular Month and Yr and which have the Origines. 
 
 
 
 
 
 
i want all the months of the year to be displayed on my cross tab even if i do not have any data for all the months. 
 
Initially, i was grouping by the creation date of the Contact in my data cube but afterwards i created a static data set with all the months. 
 
Can you please help me with how can i display all the months even when there is no data for them. Currently, some of the months are getting skipped from my cross tab.

Ruby

Finally i managed to solve the problem <a class='bbc_url' href='http://www.birt-exchange.org/org/forum/public/style_emoticons/'>http://www.birt-exchange.org/org/forum/public/style_emoticons/</a><#EMO_DIR#>/cool.gif 
 
I only needed to go back to square one and redo a few things. 
 
 
First in my data cube I did the grouping on the creation date of the contact itself instead of creating a data set with all months and then doing a grouping and linking on them. 
 
Then in my data cube itself, for Month (edit data level), i kept the format none. 
 
In my report, i checked Show Empty rows and then i just wrote an expression to display the months in the format i needed

mwilliams

Perfect. Glad you got it working. Let us know whenever you have questions!