How to make a 2 page wide report

[kramers]

I have a report that is very wide (about 2 pages in landscape for an 8x11 sheet). Is there any way I can make this report work in CR XI without having two different files?

 

[Turkbear]

Hi,
If only for viewing, install a large format printer driver on both your workstation and your BOE server..Set it to FILE as the port ( since it will only be used to configure the viewing capabilities)..The display of a report is based on its printer's abilities..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[kramers]

This is for actual printing.

 

[Turkbear]

Hi,
Then you need to have a printer that is wide enough and specify that in the report..Crystal should then format the report correctly.




To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[kramers]

So there's no way to make a report that's wider than a sheet of paper and have it just print to a second sheet?

That's absolutely stupid.

 

[Turkbear]

Hi,
How would you expect it to handle when to start a new line?
It is unlikely that it could be 'taught' to only print 1/2 a line width and save the other half for later printing on a new set of pages..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[kramers]

The same well Excel does it.

 

[lbass]

There is probably a way to do this, but you would have to provide much more detail about your report structure, groups, etc.

-LB

 

[kramers]

No groups just 21 columns with names in each in the details area and that's it.

 

[synapsevampire]

What LB might be alluding to is placing 1/2 of the fields in one detail section, then set the new page after in that section, and then place the remaining fields in the next detail section.

-k

 

[lbass]

Place the first set of fields (that fit on a page) in the detail section. Then create a formula {@cnt}:

whilereadingrecords;
numbervar cnt;

if cnt in 1 to 45 then
1 else
if cnt in 46 to 90 then
2 else
if cnt in 91 to 135 then
3 else
if cnt in 136 to 170 then
4 else //etc.
5

Insert a group on this and suppress the group header. Then go to the section expert and highlight the details->new page after and enter:

remainder({@cnt},45) = 0

Then highlight the group footer->new page after->x+2 and enter:

not onlastrecord

Then insert a subreport that contains the remaining fields in the detail section. Create the same formula {@cnt} in the subreport and suppress all sections within the subreport except the details section. Then place the subreport in the group footer of the main report and link the subreport to the main report by linking the two {@cnt} formulas to each other.

You can adjust the number of lines that you want per page and change the {@cnt} formula and new page after formula accordingly.

-LB

 

[CouchSurfer]

There is a hacky work-around....

- Create report with Portrait setting
- Create X-Tab that spans virtual pages
- Create bmp (small white blanke 1 pixel by 1 pixel image works nicely)
- On Preview tab (won’t work on Design tab) – place bmp (it will only let you drop the object in the ‘real page area’) in the details area
- On Preview tab (won’t work on Design tab) – “inchworm” this bmp over to edge of second virtual page. You have to use the handles to stretch and shrink the object (inchworming it across the screen), you cannot drop it onto virtual pages.
- Inchworm fields you want onto the second virtual page. You cannot drop them directly onto the virtual canvas.
- Delete the X-Tab (was only being used to hold the virtual pages ‘open’ for you to design on)
Print – it will print all pages (and you have a virtual indicator of where the cutline is) properly

It's not pretty, but...