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

Hide Crosstab column based on computed column aggregate in dataset

sisko7979

Hi there, 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. Please find attached a simple example based on the Classic Models database that only contains one crosstab to illustrate the problem. 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. 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. I'm using Eclipse 3.5.1. Thanks a lot,Sisko

Find more posts tagged with

Comments

sisko7979

Hi, I tried various things myself. Unfortunately it does not work, because the command for "hiding" the cross tab column<pre class="_prettyXprint">reportContext.getDesignHandle().getElementByID(47).setStringProperty("width","0px"); //CrossTab Column City</pre>needs to be in the onPrepate statement. At that stage the dataset data is not yet available to be read and used in a script. I think a different way might be possible - Using a scripted dataset as the dynamic source of a report parameter. I assume that a dataset for a parameter will be executed early enough. I have three sticking points though: 1. How to read an existing "normal" dataset (or parts of it) in a global persistant variable. In the example attached let's say totalPrice and CheckNumber.2. Sum up the check numbers. I assume some kind of loop is needed.3. Write the sum to a scripted dataset with one column: Checksum Code snippets for the three steps would be very helpful and much appreciated. Then I would create a parameter based on Checksum and change the script in the OnPrepare section to refer in the if statement to that parameter. Maybe that works. Thanks a lot,Sisko

kclark

I haven't tested it yet, but I think you should be able to set the style to "none" from the onCreate(). First check the value of the column header, if it meets your logic then set the style to none, then you could create a PGV and check that PGV later in your cross tab to set the rest of them to none also.