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

ExecuteTable using Chart Interactivity

Freddie_M

Hello everyone
My Report contains a table and a chart. The table is hidden, only used to get the data from the chart, using bookmarks.
This is my issue :
I don't want the table to be executed at run time, only the chart (regarding performance issues). The execution of the table should be triggered trough an action on the chart. Is there any way to do that using Events ? 
Thanks a lot for the Hints !
Fred.

Find more posts tagged with

Comments

micajblock

How can the chart be executed without the data in the table? Can you provide more details and what you are trying to accomplish?

Freddie_M

Thanks for your reply
The chart is generated based on the DataSet, regardless of the table. (X Series = Date / Y Series = Count Aggregation on Doc IDs)
The table is also based on the DataSet and contains two columns :
Column 1 = Date
Column 2 = Doc IDs 
 
I want to filter the table based on the Date choosed from the chart by the User . i got that working using an alert in the chart interactivity options.
I am now facing performance problems since the chart gets only displayed after the whole table has been loaded. 
So i would like to drop the table at run time and get it launched using for instance a chart event handler ? Would anything like this be possible ? 
thanks for your time !
Fred

micajblock

It is very easy with commercial BIRT as there are interactive viewing features such as filtering to make this happen. I do not know what is possible with OS BIRT, I will let others chine in.

Freddie_M

i have the OS Version :-) , all recommendations are welcome....

JFreeman

Do you have a sample you can provide with the alert in the chart interactivity options you added?

Freddie_M

Hi Jesse
Sure , here you have. The filter itself is not set in the report definition but in my application based on the "Date" provided by the alert. (The table would be hidden using a style property)
Thanks for your time
F.

JFreeman

Thank you for the sample.
 
Could you also please send me a sample of the code you are using within your application to performing the filtering/visibility changes?

Freddie_M

Hi
Just using the Report result in an SWT app. to filter the column "Date" of the table using the Date value from the alert. 
Problem 1 : This is no Birt feature (i would definitely prefer to set the filter in the report definition)
Problem 2 : Do you have any recommandation regarding the performance problem ? I dont want the table to be executed with the chart, this slows down the display of the chart dramatically up to 1000 rows... 
Is there for instance a way to drop the table in a beforefactory event and call it back after the chart render ?
Thanks for your help

JFreeman

In order for the table to be rendered it is going to have to be rendered through the factory stages. Therefore, dropping and re-adding the chart may not save you any cycles as it will still need to be rendered if it is going to be displayed.
 
What may be a better option is to have the custom code initiate a re-render of the chart/table with a parameter/filter at the data set level with both the chart and table based off of the data set. This way the chart is not dependent on the table and the filtering is pushed down to the database.

Freddie_M

Hi Jesse, thanks for the hint,
--> Is there a "standard" way to re-render a report item using a script ? could you maybe provide a small sample ? 
Tanks a lot !

JFreeman

How are you currently calling the report to run?
 
The simplest way is going to be through calling the report to run again and passing it values for the report parameters based on the values obtained from the on click interactivity.

Freddie_M

ah Ok, i see thanks , i will have a look at that.
Alternatively , an "Hyperlink" interactivity event with a drill trough to the table might be working as well ?

JFreeman

It may take a bit more configuration but I believe that should work as well.