How to remove the whole page if records in detail are filtered

[emmhu0620]

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.