Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Hide rows in cross tab
princeabd
Hi,
I have one report which is generated using cross tab,
Its like,
ProjectName1 || A || Jan
|| B || Feb
|| C || Feb
ProjectName2 || A || Jan
|| B || Feb
ProjectName3 || A || Jan
|| B || Feb
Now i want to hide the rows of ProjectName2.
Plz tell me the script or birt function.
Regards,
Jeyinul.
Find more posts tagged with
Comments
mwilliams
Hide them based on a parameter? Or what? You should be able to use a filter to do this and just filter out the rows.
princeabd
Thanks Williams,
Its working, But Empty columns are also hide.
Based on the input parameter it displays the outputs.
The output is like,
Project Name || Jan
SIT Project || 5
I want all the month names. If i didn't add any filter it comes like,
Project Name || Jan || Feb || Mar ||......................
SIT Project || 5 || - || - ||......................
Why other months which is not having values are hidden.
Plz help me on this.
Regards,
Jeyinul.
princeabd
<blockquote class='ipsBlockquote' data-author="'princeabd'" data-cid="81213" data-time="1312622915" data-date="06 August 2011 - 02:28 AM"><p>
Thanks Williams,<br />
<br />
From the output i have to hide the rows.<br />
<br />
<br />
Its working, But Empty columns are also hide.<br />
<br />
Based on the input parameter it displays the outputs. <br />
The output is like,<br />
<br />
Project Name || Jan <br />
SIT Project || 5 <br />
<br />
I want all the month names. If i didn't add any filter it comes like,<br />
<br />
Project Name || Jan || Feb || Mar ||...................... <br />
SIT Project || 5 || - || - ||......................<br />
<br />
Why other months which is not having values are hidden.<br />
<br />
Plz help me on this.<br />
<br />
Regards,<br />
Jeyinul.<br /></p></blockquote>
mwilliams
This is because the other months do not have any data for them. You can create a flatfile or scripted dataSet that has all the months or at least all the months you're wanting in your report and join the dataSets together with a full outer join, then use computed columns to merge your data how you need it.
