is possible use main dataset in Table Report??

[mm972]

hello,

in Jasper Studio i want to create a Table Report.
when i create a Report, in the wizard I build the main Dataset with my DataAdapter/query.
But when I create the TABLE element is not possible to use the MAIN DATASET, and i'm forced to use another Dataset.

if I use the EMPTY DATASET-EMPTY RECORD as MAIN DATASET or insert a Query with no Rows the report will be blank,
im my report now I insert the fake query (select * from dual)

why I'm force to use 2 Dataset..???  
thanks to all

Max

 

[butlerc]

that's how the product is.  It's actually better this way, means you can use different queries for different pieces of your report.

Your report will only be empty if your other dataset isn't being triggered, remember to hook up the dataset to the table element and also pass parameters (if any) from the main report into your table element, using the properties tab.

 

[mm972]

hi butlerc,

thanks for the answer...
i don't understand, what do you mean with "dataset triggered" and "Hook up the dataset"

in my report I have 2 Dataset (Main_dataset , Table_dataset)
the Main_dataset query is (select * from dual) , create in the wizard report
the Table_dataset query is (ex. select id_prod, product_name from products) create for  my table
what should I do in your opinion..???
Thanks Max

[butlerc]

ok, dont use EMPTY DATASET-EMPTY RECORD  as your MAIN DATASET, choose an actual database connection as you need the query to run, i tend to use select 1 from dual, but select * from dual works too. 

Your table element isn't firing because the main report's dataset is empty.

[butlerc]

ok, dont use EMPTY DATASET-EMPTY RECORD  as your MAIN DATASET, choose an actual database connection as you need the query to run, i tend to use select 1 from dual, but select * from dual works too. 

Your table element isn't firing because the main report's dataset is empty.