Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Hide Crosstab column based on computed column aggregate in dataset
Migrateduser
<p>Hi there,</p><p> </p><p>I am trying to hide a column in a crosstab based on the aggregate of a computed column in the dataset that is also used for the crosstab in one of my reports.</p><p> </p><p>Please find attached a simple example based on the Classic Models database that only contains one crosstab to illustrate the problem.</p><p> </p><p>I managed to hide the column "City" by inserting a script in the onPrepare section of the crosstab, but due to my lack of scripting knowledge I could not get the rest working.</p><p> </p><p>In the underlying dataset "ds_orders_per_customer" the last column "CheckNumber" is computed. I would like to hide the column "City" of the crosstab, if the aggregated sum of the column "CheckNumber" equals 0.</p><p> </p><p>I'm using Eclipse 3.5.1.</p><p> </p><p>Thanks a lot,</p><p>Sisko</p>
Find more posts tagged with
Comments
There are no comments yet