How to use parameters as variables? 1

[jjmew]

I am building a report inside one report the inner report SQL depends on what the outter report SQL is returning. I read that the only way to use variables in the SQL is declaring the variables as parameters. The problem with it is that I need to modify those paramenters in the report. How I can do that? or How i can link the Inner SQL with the outer SQL? Confucius once said, "I hear and I forget. I see and I remember. I do and I understand."

 

[keithcorbin]

First of all not true, you can define variables in many ways, including in an included basic file. In the fetch of the first query set the return that you are interested in to a variable. Use this variable in the second.

good luck.
K

 

[nosmas]

Hi I am in the same boat as jjmew with out the need to modify the parameters.
My question is: 1. how do i use a parameter I created in my sql.
or
How do i reffrence in my sql the parameter I created?

An example would be useful, actuate does not provide much help in its manual.
Thanks

 

[MichaelHuber]

In a few situations, we had to create multiple parameters that contained the same value. Maybe you can extrapolate a solution for your own situation.

We made a parameter called :First in SqlQuerySource1, and one called :Second in SqlQuerySource2. These two parameters need to be hidden, because they will get their value from the same central source.

We also created a variable in the top-level component called MainVar, which we made a parameter.

In the Start method of the top-level component, we added:
SqlQuerySource1::First = MainVar
SqlQuerySource2::Second = MainVar
before the call to Super::Start()

I hope this points you down the right path.
-Michael

 

[wales68]

Sorry if I may not be able to the question either, but my situation seems very similar except I want to use a parameter in my SQL statement to be presented as a prompt to the user. The users are using the Business Web client and they cannot access the SQL to change the parameter.

Therefore how do I prompt the user for parameter information if the report has been build using the standard SQL?

Thanks