Stimulsoft Business Intelligence System | Forum

Hello team,

Passing the value of a parameter from one dashboard to another dashboard does not work in the js/php viewer. It only works in the designer.

Enclosed you find a test.
Please notice the use of parameters in dashboard1.

When you click on the shopname 'shop1' it should pass the shopid to the query from which the results are shown in dashboard2.
But it only shows results in the designer and not in the viewer.

Please help.

Best regards, Andre

Hello,

We need some additional time to investigate the issue, we will let you know about the result.

Thank you.

how to set color on graph series at dashboard? it is possible?

Hello,

You can use the SeriesColors or Conditions properties to set colors for series.

Thank you.

Hi Lech,

Any news on the original question of this post?

Best regards, Andre

Hello.

We don't see that you are using the Parameter to filter the data of the second dashboard.
Please, look at the attached dashboard. The filtering is made there based on the parameter.

Thank you.

Hi HighAley, thank you for your response.

I don't use filtering indeed. But I use queries which use the values of parameters (variables).
My application is about data from hundreds of students. When I would use filtering it would mean that I would retrieve all data and then filter the data I need. But then my datasets would be very large (and slow).
Therefore I only retrieve the data I need, by means of using parameters in my mysql select statements.
The problem is that the value of the parameter is not passed in the viewer. It works perfect offline in the designer.
You can see this in the example I sent.

I have the same problem in the reports. Within the designer parameters (variables) are passed fine between relations. But after publishing (to PHP) parameters are not passed in the viewer. Perhaps this is related to the version V2019.4.2. It worked in some previous versions.
You can see this in the example I sent in the topic: viewtopic.php?f=18&t=58171
Perhaps the issues are related.

Best regards, Andre

Hello,

Parameters are not supported in the JS version. You can use variables instead of parameters in the query:
select * from table where column = {variable}

Thank you.

hi, in dashboard i need parse multiple parameter in url hyperlink and able to achieve using variable, it's that possible parameter is parse using dashboard filter component?

Hello,

Sorry, maybe we did not exactly understand your question. Could you explain your issue in more detail?

Thank you.