|Hiding table based on inner dataset number of rows [message #872441]
||Wed, 16 May 2012 02:03
| Prashant Jha
Registered: September 2011
I have a dataset(ds_chartdata) with a chart_number, created_date and value. chart_number and created_date combination are unique on this dataset. I need to create one chart per chart_number. |
How I went ahead
- I created another dataset(ds_uniqueChartNumber) which gives me unique chart_number.
- Created a outer table binded to ds_uniqueChartNumber with a group on chart_number.
- Added a chart to the details row. Binded the chart to ds_chartdata.
- Added a filter to chart wherein row["chart_number"]=row._outer["chart_number"]
This serves my requirement to create one chart per chart_number. But for some chart_number there is no data. The chart by default is not displayed. But the table is still displayed. I want the table itself to be rendered invisible if the rows for a particular chart_number in ds_chartdata has no rows. help please.
Powered by FUDForum
. Page generated in 0.01771 seconds