| Author |
Topic |
|
raaj
Posting Yak Master
129 Posts |
 Posted - 2009-09-29 : 20:27:44
|
| Hi Guys,I am creating a matrix report. And inside that report there are 3 different tables (in the layout tab). I am also doing document label for those 3 different tables so that user can click whtever result they want from the report manager.I am applying filters for each table....(for 1st table will show category1 values, 2nd table will show category2 values, 3rd table will show category3values)Now my problem is when exported to excel, the page break is not happenening (when the second table has no records). The first table has some rows, second table has no rows and the third table also has some rows.Now when I am exported to excel, in the sheet1 I can view the first table.....but in the sheet2, I am able to see both the second (which displays "no current records") and third table (its respective rows)....I want in sheet2 to show that message ("no current records") and in sheet3 the table 3 rows seperately......... Can anyone suggest me the possible solution please.......Raaj...... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-09-30 : 00:13:32
|
| have you checked option insert page break after each table? |
 |
|
|
raaj
Posting Yak Master
129 Posts |
Posted - 2009-09-30 : 00:30:39
|
| Yes Visakh,I have that option checked after each table.....in the preview tab, its working fine with page breaks..I donno why its not doing page breaking when Exported to excel........ |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-09-30 : 00:33:49
|
| when there's no rows for second table are you showing table at all or is it a message textbox that you show? |
|
|
|
raaj
Posting Yak Master
129 Posts |
Posted - 2009-09-30 : 01:31:45
|
| Actually when there are no rows for a table, I want to display it as "No Current Records"...So for this to happen, I clicked on table (selected the entire table) and went to Data-->NoRows and in that I have written that sentence "No Current Records" |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-01 : 14:35:02
|
| raaj, unfortunately, when there are no records, the table itself is not output so any page breaks defined in the table are not seen. Is it always table 2 that may be empty? If yes, try Page Break AFTER on Table 1 and Page Break BEFORE on Table 3.John |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-01 : 15:13:16
|
| or put the tables inside rectangles and place page break in rectangle property |
|
|
|
raaj
Posting Yak Master
129 Posts |
Posted - 2009-10-02 : 02:32:42
|
| Thanks visakh....That worked perfectly.........Thanks,Raaj |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-02 : 07:54:26
|
| visakh16, Great idea. Need to remember that one.John |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-02 : 07:55:44
|
welcome  I had once encountered this problem and had solved it similarly |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-02 : 13:25:55
|
| Only time I erally use rectangle up till now is to display optional parameters on a report. Rectangle only displays if any parameters are selected and each parameter is in its own text box. The rectangle grows to fit the size needed as more parms are selected. But now that you mentioned the pagination trick I can definitely see where they can help in the future. Thanks again!John |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-02 : 13:32:24
|
| no probs |
|
|
|
huffcm
Starting Member
1 Post |
Posted - 2010-05-25 : 15:56:21
|
| When placing a rectangle do you set the size to enclose only the fields you want on the page?i.e. I have a Body that is 8.5in X 14in. I put a rectangle on and inside that placed a text box (Return Address) and a table with one column and 5 rows of data (Customer Name and address).When I preview in print format there is a blank page between each page with data and the text box only shows up on the first page.Thank you in advance :)Chuck |
|
|
|
|
page break problem when exported to excel