Repeat on horizontal pages 8.5 version 1

[eldevitto]

Does the repeat on horizontal pages exist in crystal 8.5? I can't find it anywhere and would really love to use it. If not, does anyone know how to get objects to display across horizontal pages in version 8.5?

Thanks in advance!

 

[Madawc]

Please make it clearer what you are wanting to do. No one here seems to understand your question.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[eldevitto]

when you create a crosstab report in version 8.5, it will sometimes create virtual pages if there are a lot of columns. These pages are displayed in a horizontal view. When you add a page number the page number only displays on the first page of the horizontal view.

From what I was reading, in later versions of crystal if you go into the format editor you can choose "repeat on horizontal pages" from the common tab. This option does not exist in crystal 8.5, so I was wondering if there is any way to make this work.

 

[lbass]

Yes, there is no repeat on horizontal pages in 8.5. Depending upon the location of your crosstab, you could potentially add a second crosstab in a section above or below the location of your current crosstab, e.g. RFa or RFb. In the crosstab, add a formula as your column field:

whilereadingrecords;
numbervar k := int(270/9);
numbervar cnt;
if cnt <= k then
cnt := cnt + 1;
cnt

Replace '270' with a number greater than or equal to the total number of column values across horizontal pages. Replace '9' with the number of columns per page. Be sure to go into the customize style page->check "repeat row labels on each page so that the number of columns is the same on each page.

Add any field as your summary field, and then insert the crosstab into the report. Stretch the column field so that it extends to the end of the master crosstab on each page. Then suppress the row label ("Total") and the summary, and then remove the grid by going into the customize style tab->format grid lines->uncheck "show grid lines".

This will return the pagenumber of the horizontal pages --1,2,3, etc. However, it does not also return the current vertical page number if the crosstab is more than one vertical page.

-LB

 

[eldevitto]

LB,

Thank you for this, this works perfectly with the report I am designing. Since the number of rows should not exceed the page length, I am not concerned about the page numbering on the vertical pages.

Thanks again!