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

Changing the background image of a chart dynamically

D_Petrov

Greetings to all,

I'm newbie here and in BIRT designing.
I have BIRT report with two charts and few datasets from SQL server DB.
The problem is , that I want to change the background image of one of the charts, depending from a string value from one of the datasets. Images are added as embedded in the project.
So if the value is green-> the chart background should be green, otherwise will be red.
it should be done with some custom scripting, I guess because I do not see any option for dynamic image in the Chart background. Can you help me?
 
Best,
D_Petrov

Find more posts tagged with

Comments

pricher

Hi,
 
If you are new to BIRT, I would highly recommend to avoid chart scripting because it can be a bit overwhelming. Reading your post, I think you can simply use the Visibility attribute to select which of the red or green chart will be displayed at run time.
 
I am sending you a sample report that shows first the No Scripting approach. The 2 charts at the top are embedded in a 2-row grid. The Visibility attribute is set on the row and the condition is based on a report parameter (in your case, you could based the condition on a data set value).
 
The chart at the bottom uses scripting, if you ever need an example. Please note that chart scripting is applied at render time, hence you do not have access to the data set anymore. For that reason, any value that you need from the data set must be passed as a global variable and recovered from the report context.
 
Hope this helps,
 
P.

D_Petrov

Hi pricher,
 
Many thanks for the propositions! I`ll try it and tell you the result.
 
Best regards,
D_Petrov

D_Petrov

I have two more questions about the chart script: 
1 How to target the embedded image in the script?
2 How to get a value from a column in a dataset in the script?
 
Best,
D_Petrov

pricher

Hi,
 
Off hand, I don't know how to embed an image through script.
As for getting the value of a column in the script, I mentioned in my previous post that chart scripting is executed at render time; therefore, you will not have access to the data set anymore. If you need access to a data set value while in the chart script, you need to store that value in a persistent global variable, and retrieve that value from the report context in the chart scripting. I have used a similar method in my previous example. Look at the report initialize method to see how I store the value of the report parameter into a persistent global variable. Then, in the chart scripting, I retrieve the value in the first statement of the beforeGeneration method.
 
Again, I strongly recommend that you look at other methods than chart scripting to solve your problem. Based on what you explain initially, using the Visibility attribute should work well.
 
Regards,
 
P.

D_Petrov

Thank you! I managed to fix it

Regards,
D_Petrov