VimMang

However I did not get any answer yet. but the workaround is have two queries needs to be written although in first query use TOP 1 records instead of all records.

It would be nice to put filter condition on table level instead of creating new dataset. Where do I put condition like $P{Id}>20 on table 2?

Thanks for response. Let's say as an example – DB table contains hundred records with Id and description. In first table have to display first 20 records (Id <=20) and in other table have to display next ( Id between 21 and 40) . How can I achieve this? Where do I need to use conditional filter to show selected data in table?

Thanks It worked. I see query executed multiple times.. Having said that I created a report with one dataset and with 3 tables. These tables are referred dataset query. When I checked database logs, It showed me dataset query executed three times before of it referred via three tables. One more question, How can I add filter condition on table level? Lets say I have to define query on dataset level and requirement would be as below 1. Create two tables- first table should show all the rows from sql query. 2. In second table - It should show based on some condition. lets say date <= today Thanks in Advance.

I do currently upload report to jaspersoft server manually. I would like to know how to automate this process?

In Jaspersoft studio, Create new data adapter->Use jdbc driver as org.postgresql.Driver and put Redshift cluster url with credential.

Requirement: Text message should be display in Table like "No Data found" if data is not returned. How can I achieve this? Thanks in Advance.

Thanks it works really nice. How can I display "No Record found" if dataset returns nothing?

My requirement is to build report with two tables - one table contains all detail data and other table contain summary data. To achieve this what needs to be done? Does it needs to create two dataset? Can I consume single query in the both tables? Generally in SSRS , This can be done in single query to consume in one or more tables. Thanks in Advance.

I have designed sample report in which I have placed table in summary band. everything works as expected. How can I display "No Record Found" if SQL returns nothing? Thanks in advance.

How can I get record count of the dataset? Based on the record count have to display text like "No Record found" in summary band. Is there any other trick to display "No Record found" if nothing is returns by dataset. Thanks in advance.

Use these <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="true"/> <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns" value="true"/> <property name="net.sf.jasperreports.print.keep.full.text" value="true"/>