table and datasets

[sofiano]

Hi,

I have a problem with table and datasets. When I try to create my table and I write the dataset containing a parameter. It doesn't work on execution. I haven't a dialog box to choose my parameter.

Thanks everyone for his answer..

[dgangstaz]

How do you configure your dataset based on a parameter?

[sofiano]

I used the dialog box "Edit Query" on the "Data set" then I added the parameter into it. When I execute my report, I have the result based on the dafault value of the parameter. It doesn't show me a dialog box to choose it.

[thegg]

Hi,

Don't know if you have find the way but there it is :

In the couple "dataset" & "table" you don't have dialog box who prompt.

You must indicate to the table how to pass the parameters :

1- select the table you want to use on your report.

2- menu-mouse with button of the right

3- select "Edit table datasource"

4-go to the "Parameters" windows

5-select add

By this way you can select the variable you defined "In the dataset" wich is called "parameters" and a contain which is called "Expression". This last can be an expression of your main report : $F{name_variable}

Add all parameters you must use in the "dataset in parameters".

Expressions in your "dataset in parameters" serves to test/view the good function of your data request and "unfortunately" can be used in default expression by the main project to show you something.

c u

 

Post Edited by thegg at 04/22/2011 07:11