Scaling down a report

[JCruz063]

Guys,
My company currently prints a report for its clients using Microsoft Excel. The information in the report is too much and to make it fit in one single page, they scale it down by going to Page Setup and setting the scale to 75%.

Now, they want to make the exact same report available online and I'm having trouble getting Crystal Reports to shrink the report to 75% of its size. I need to be able to set this scale at design mode, if possible, so that I can fit in all the text objects because they don't fit using the normal size. When the report prints, it must be scaled down to exactly 75%, no more, and no less, because it must look exactly the same as the one printed in Excel.

I tried going to Designer -> Printer Setup, and setting the scale there, but it doesn't work. So the question is, how can I tell Crystal Reports to scale down the report to 75% both at design time and at run time?

By the way, I'm using the version of Crystal Reports that shipped with the original release of the .Net framework.

Thanks

JC

We don't see things as they are; we see them as we are. - Anais Nin

 

[synapsevampire]

Exporting is never an exact science, so the requirement of it looking exactly like the Excel version probably needs to be relaxed (read: they need more important things to squander time and resources on).

Often times I will be forced to create 2 versions of a report, one which is for export (different layout/fonts/etc.), and one for viewing.

The export version might be in the form of a subreport and a parameter conditionally suppresses.

-k

 

[lbass]

You have the option of scalability in printer setup? I haven't seen that. I would think you might have to adjust your font size to scale the report. You can select multiple fields and then click on the A- icon to reduce font sizes (you can reduce to as low as 1 pt). However, multiple selection could change the other kinds of formatting you have applied to these fields to reflect the formatting of the finally selected field, so you might start by selecting similarly formatted fields and then reducing the font.

-LB

 

[JCruz063]

synapse,
Maybe the report doesn't have to look exactly the same as the Excel one but, at least, I need to be able to scale it down so that I could fit its contents in one page. You see, the report has many TextObject elements which are placed horizontally and simply don't fit on page with the scale being 100%. Also, it looks that I can't reduce the font more than 8 points so what comes to my mind is that I need to scale it down.

lbass,
The option of scalability isn't really in Printer Setup. What I did was, once in Printer Setup, I clicked on the "Properties" button next to the selected printer and changed the scale there. But, as you know, this refers to the printer and therefore has no effect on the report.

Now, it doesn't seem like I have an "A" icon which allows me to change the font of objects. The version of Crystal Reports that I have is the one that came with the original release of the .NET framework (Crystal Reports 8.0). I didn't purchase Crystal Reports separately so I guess they figured I shouldn't get that A-icon. Or perhaps it's just that I don't know where that icon is. I change the font of my objects by right-clicking on them and clicking on "format". Now there, I can't reduce the font any lower than 8 points.

Any other ideas?

Thanks!

JC


We don't see things as they are; we see them as we are. - Anais Nin

 

[BobSuruncle]

You can just type the value for the font in the Font Size box.



Bob Suruncle