Why I am not able to view data in generate report

[amit.nanote]

Hi, 

I have created a Report on the basis of CSV file on machine. 

I am using Eclipse plugin for Jaspersoft Studio. 

On Data Preview I am able to see the data. 

But when I check the design preview I am not able to see the data in generated report. 

Select type in Detail of report is Table. 

 

 

 

 

Blank report generated. 

Please help me to resolve this issue. 

 

Regards

Amit

 

 

 

[abc.hegde]

Are you using table component? If so, please verify whether you have given the proper dataset for the table.

Since you have placed the table component (i see that as a table), you need a query for the main report retruns at least a dummy record. Otherwise your detail section will not be printed.

The better approach is, use the table component in the summary band and have a dataset for table where you have written the required query.

[amit.nanote]

Thanks for the reply. 

Yes I have associated a valid dataset for the table. I have a CummTot.csv file which I have assiociated with Jasperstudio using CSV adapter. Also I have checked that my query is returning the rows agains the submitted query. 

Following is the output - 

 

I have deleted the table from detailed field and added it to summary section. After that I have checked the above query and clicked on preview button but again no output got displayed. 

 

Thanks again. 

Amit 

[hozawa]

Instead of the Table component, try placing text components for the fields to check if the data is actually able to be displayed.

If the data displays, it means there some problem with your Table component settings.

[amit.nanote]

Hi, 

Again no data displayed using text field. I have confirmed query used for the dataset which is running fine. Also, when I drag and drop the fields on detail or Summary band of report get following error message - 

You drop an object from a subdataset into the report, this is not possible.

Regards

Amit

 

[amit.nanote]

Thanks Hedge, 

 

I was earlier thought that I was selecting from main, but it was subtype from where I was selecting the fields in detailed area. When tried with main fields it worked and now I am able to see the data. 

 

Regards

Amit 

[hozawa]

Great! The give away was "You drop an object from a subdataset into the report, this is not possible." :-)

[amit.nanote]

Hey Hozawa, 

 

Thanks to you as well. :) .. 

Regards

Amit