Stimulsoft Business Intelligence System | Forum

Hi Andrew,

I have created the variable for drop down list manually. Such as Detailed price and Overall price.

And I have created another variable (read only) for authenticated_user_id.


If authenticated_user_id is empty then show the Overall price else empty on the drop down variable. How to achieve this ?. Please help me.

Here attached the screen shot for your reference.

Hello,

How do you use, set the authenticated_user_id variable value?

Thank you.

Hi Lech Kulikowski,

There are two pages on the report. One is Detailed price and another one is Overall price.
That report is accessed by two URL. One is the desktop and another one is online order.
I get the authenticated_user_id from the online order URL.

I want to show the two pages on desktop version but i want to show only one page (Detailed price page) for online order. How to hide the Overall price page and drop down list value on the report. Please help me.

Hello,

Unfortunately, it is not possible.

Thank you.

Hi Lech Kulikowski,

Thank you for your response.

Another one is, How to add the variable name as a column in the datasource1. and How to put if and else condition for variable in the datasource1 query.

Hello,

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

Thank you.

Hi Lech Kulikowski,

I created the variable authenticated_user_id

How can i use that variable as a column in the query

example

Select name, authenticated_user_id
from
table1

Hello,

check the box allow using as SQL parameter, and then in a query use it with @Variable1 Thank you.