emmhu0620

I have review my previous question and it seems so complicated, so I come up with a new idea so I won't need those dummy data anymore. Do anyone have hints, if I want to create crosstab columns from array, then inser the correction information into the crosstab? For example, I have a table like below in my DB: customer | activity_date | activity ---------------------------------------------------------------- customer1 | 01-01-2016 | A customer1 | 01-03-2016 | B customer2 | 01-01-2016 | A When users request report from JAN 16 to MAR 16, the report should be shown like below: | 01-2016 | 02-2016 | 03-2016 | ------------------------------------------------------------------------------------------ customer1 | 1 | 0 | 1 customer2 | 1 | 0 | 0 ------------------------------------------------------------------------------------------ total | 2 | 0 | 1 The current problem is that, as there is no data within Feb 2016, the column 02-2016 is missing in the report. Is there any way (like scriptlet) to create an array as column, then tell the JasperReport the insert correct data when activity_date == column_date? Thanks in advance

I have records with schema like below: is_dummy,update_date,company_code, customer_name, activity_type I am going to generate report to show the customer's activity in a certain period in a company, i.e., From Jan 2016 to Feb 2016 in Company ABC. The report is divided to two section, records row (locate in detail band )and table(built with crosstab, locate in group footer). The pages are grouped by company_code. is_dummy is a boolean to indicate if the record is a dummy data used to expand the table, make sure all the month are printed even there are no activity records. This dummy record only have data in is_dummy, update_date and company_code. There are two problems when I am building the report: 1. The detail band may have no records as the dummy data is filtered in this band, therefore the page has no detail but only the header and footer, how can I (or tell the report to) remove the whole page if all records are filtered under the same company_code? 2. How can I filtered the dummy row in the crosstab, with the update_date remain in the column? I know that in ad-hoc report designer I can filter row with filter in column, but I can't find similar function in jaspersoft studio I am using Jaspersoft Studio and I am new to JasperReport. Thanks in advance.