Hi,
I have a situation in which I am using a Closed - Multi Box Filter to view my reports for different filter options. It has 3 filter Parameters Namely:- Region, City and Product ID. There is a situation in which I want to see the records only on the basis of Product Id. So when I select a particular product ID (leaving other filters blank) the report displays all the records for that product, but when I give print command it breaks the page on the basis of City. Also in the header I have used a text box to show select Values of the filter. though this column remains blank when not selecting Region, city while printing its printing the city values also , since the page break is defined on the Basis of City while printing. So if I have a record something like this:-
| Region | City | Pid |
|---|
| 1 | x | 111 |
| 1 | x | 112 |
| 1 | y | 113 |
| 2 | z | 114 |
| 3 | a | 115 |
| 3 | a | 116 |
and the printing capacity per page is 3 columns then for printing on the basis of only Pid the report should print in 2 pages.
But the report is getting printed in 4 pages one each for city x, y ,z & a. And also in the header text box its mentioning the city name.
Any workaround for this situation ??
