Member Avatar for chancellor

I need to be able to preview a report in Landscape format. I've set all the margins etc to be landscape format. However, it still previews as portrait now that I've removed some of the fields. I've not yet tried to print the report.
When I leave the other fields in, I get a message that the paper is too small for the report. Can someone help please?

  • 2 Contributors
  • 2 Replies
  • 270 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by chancellor

Dani AI

Generated

A short diagnosis and practical checklist based on the details in this thread (thanks to for the symptoms and for the "check settings" nudge).

Most likely cause

  • The report’s actual content width (fields + gaps + section borders) doesn’t fit the printable area for the chosen paper and printer, so the preview/engine either scales or falls back to a different layout and shows the "paper is too small" symptom. This is a common CR/print-engine behavior when design size and printer page size/orientation disagree. (studyres.com)

Concrete checklist (quick, do these in order)

  1. In the report designer confirm Page Setup: paper Size and Orientation are set to Landscape and the same paper (Letter/A4) the printer uses.

  2. Measure the report width: ensure (sum of field widths) + left/right margins <= page width for the selected paper. Reduce field widths or margins if needed. (Watch CanGrow/subreports — they can expand width at runtime.) (studyres.com)

  3. Confirm the preview control is using the printer you expect (preview often uses the OS default printer). If printing from code, explicitly assign the printer and page settings before rendering. For Crystal Reports set PrintOptions.PaperOrientation and PaperSize; for VB.NET PrintDocument set DefaultPageSettings.Landscape = True; for VB6 set Printer.Orientation to landscape. Example snippets:

    ' VB.NET (PrintDocument)
PrintDocument1.DefaultPageSettings.Landscape = True
    ' Crystal Reports (VB.NET)
rpt.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Landscape
rpt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperLetter
    ' VB6
Printer.Orientation = vbPRORLandscape

    (learn.microsoft.com)

  4. If printing from an app and the printer's available paper differs from the report design, use the engine options to dissociate or explicitly pick the printer PageSettings (CR exposes DissociatePageSizeAndPrinterPaperSize and PrintToPrinter helpers). If preview looks wrong, try printing to PDF to confirm final layout. (userapps.support.sap.com)

If the steps above are followed the mismatch/preview rotation is usually resolved: either shrink the designed width or force the exact paper/orientation in the code so preview and print use the same settings.

Recommended Answers

All 2 Replies

Member Avatar for Sinha's

hey,
Plz try to check your settings from first. There might something to recheck. Settings related to page setup and print. You may able to find it out.

If your problem is solv then my DIL GARDEN-GARDEN HO JAYEGA.:)

Member Avatar for chancellor

Please note that I already checked all my settings. Page preview etc are all in landscape format.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.