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
set variable to count of dataset
Migrateduser
<p>I would like to show a table depending on the amount of results a dataset returns. I have created an aggregate column that counts the rows in the dataset but how do I then set the variable to that count? I am doing this inside the BIRT designer so onFecth() wouldn't work here. Is there something in the edit datatset that would allow me to do this?</p><p> </p><p>Mike Williams posted this in another thread and this is what I'm basing it off of but I'm stuck setting the variable.</p><blockquote class="ipsBlockquote"><p> </p><p>To hide a report element if there is no data in your result set, you could create a variable with a value of 0 in your initialize method of your report, increment the variable in the onFetch method of your dataSet, and then use this value to hide your chart/table if the value of the variable is 0 (this would mean that the onFetch was never called because there was not data to be retrieved).</p></blockquote><p> </p>
Find more posts tagged with
Comments
There are no comments yet