Thursday, August 14, 2014

Enable No Data Band


No data band use to display content/warning/error while main query not return a single row.





Follow the below step to use the"No Data" band of jasper report.

Step 1 : Right click on "No Data" band and select "Add Band" If it is not visible, More detail follow the section 1 of above image.

Step 2: select report (as mention in section 1 of above image) and right click as well select property option. Set "When No Data" as "No Data Section" property (detail display in section 2 of above image) 

Step 3 : Now run the report with no data query i.e. select 'Yes' where 1=2 so this query not return a single row so the result will display as mention in no Data section.


Tags: 
No Data Section.
When no data found display alert message.

Tuesday, August 5, 2014

Dynamic Columns Cross Tab Report.


Multi Columns Cross Tab Report.

You can generate the multiline cross tab report as par below output by providing raw data (There is 8 rows are the input and below table is the output of the cross tab report.)
Tags: 

Jasper Report
Multi Columns Report
Dynamic Columns

Cross Tab Report