How to fill parameters in Query Documents with Basic

[mobi-doc]

There is a Report Document (Sun Report Builder) based on a parametrized Query Document. Every time I lunch the report a dialog pops up to fill the parameters of the Query.

Is there a way to open the report and fill the parameters with BASIC code, in order to suppress the dialog?

Thanks in advance.

[DrewJensen]

Yes, but it is a little bit of a work around.

There is a known problem with actually supplying data to a parameterized query via Basic at runtime. It don't work - in simple terms.

However you can do this.

Create a query with a parameter(s) and save it.
Base your report design on this query.

Create a macro that

Grabs a the query definition.
Use the QueryAnalyzer service to get the part of the query with the parameter
Replace the parameter with your data
Save the query definition
Launch the report

Now, if that helps great - if you need some more detail on specific steps in that simply ask
_________________
Blog - http://baseanswers.spaces.live.com/

[mobi-doc]

Finally I think I'll need an example of how to do the procedure you described.

Thank you.