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)
Crosstab styles hide issue
rajkishore
<p>Hi,</p>
<p> </p>
<p>I have created a crosstab and written a conditional script(onCreate) to hide cells.</p>
<p>when i run the report without applying the themes/styles the report is working properly and hiding the cells.</p>
<p>When i run the report after applying themes the crosstab cells not hiding.</p>
<p> </p>
<p>i am not sure what causing the issue, is that styles issue or crosstab issue.</p>
<p> </p>
<p>Please find the attached sample report to reproduce this issue. I am unable to attach library to this post.</p>
<p> </p>
<p>Attached are two sample screenshots,
Find more posts tagged with
Comments
JFreeman
<p>It looks to me like something about the style/themes you are applying is overriding the display none style setting you are using to hide the cells in beforeOpen.</p>
<p> </p>
<p>Without being able to inspect the theme/styles it is going to be hard for me to say more.</p>
<p>Can you create a library with a style/theme that reproduces the issue that you can attach?</p>
rajkishore
<p>Please find attached library.</p>
sureshpulapalli
<p>Kishore,</p>
<p> </p>
<p>I tested the code in ver 4.4 and it is working fine.</p>
<p> </p>
<p> </p>
<p>Regards,</p>
<p>Suresh</p>
JFreeman
<p>This issue is related to the themes/styling you have set you the crosstab.</p>
<p> </p>
<p>In your library you have set the "height" property to 43px in both crosstab-cell and crosstab-detail. Both of these settings force the cell and row to display with a fixed height of 43px. So even though the display is none, you get 43px of white space due to the hard 43px height settings.</p>
<p> </p>
<p>If you remove both of these height setting, the row hides properly without the additional white space and the formatting is not impacted.</p>
rajkishore
<p>Thanks, I found the same. There are some other reports which uses this library, this will impact if i remove the height in library. </p>
<p> </p>
<p>1.Can we able to set cell height on conditional data(means on create of cell if "USA" then set height "0").</p>
<p> </p>
<p>or</p>
<p> </p>
<p>2. we can override the cell properties and set zero height after applying the themes.but here the elements are not showing the designer.SInce we are setting height to zero. </p>
<p> </p>
<p> </p>
<p> </p>
<p>Regards</p>
<p>Kishore G</p>
JFreeman
<p>1. I looked briefly and didn't see a height setting available for the cell in the onCellCreate method. I will look further to see if this a way to set this in your scripting.</p>
<p> </p>
<p>2. instead of setting height to 0, if you just remove the height properly setting all together from the theme, it should allow the height to be auto determined.</p>