Report in either Portrait or Landscape

rbuser

I have a report that has a filter form with detail or totals only. If
the user selects detail, I would like the report to print in landscape.
However, if they select totals only, I want it to print in portrait.
I tried switching the property on the calc tab but could not get this to
work. I can switch to two separate reports if I have to. Is there a
way to do this that you know of?

nicocizik

Hi Jeff,

Which version of ReportBuilder are you using? If you are using RB 9.0x you
may be able to use the BeforeOpenDataPipelines event to perform this action.
I don't believe any other events in RAP will fire early enough to
successfully change the paper orientation. You can also try the BeforePrint
event.

Another option would be to place two section style subreports in your detail
band, one portrait, and one landscape. Then toggle the visibility of each
subreport based on which type of report you would like to see.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

The version I am using is version 7.02. I will try the other things you
suggested unless you have any other suggestions.

nicocizik

Hi Jeff,

If the Report.BeforePrint event does not work, the second option would
probably be your best bet.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com