Results 1 to 13 of 13

Thread: Data Report LandScape Orientation

  1. #1

    Thread Starter
    New Member
    Join Date
    Nov 2011
    Posts
    6

    Data Report LandScape Orientation

    Hi to Community,

    I have some problem with the data report, i couldn't make my reports into other paper orientation specially in landscape, is anyone could help me to make my datareport into landscape view,


    Thanks a lot,

    cheers,

  2. #2
    PowerPoster
    Join Date
    Feb 2006
    Posts
    24,482

    Re: Data Report LandScape Orientation

    I think in code you have to set:

    Printer.Orientation = vbPRORLandscape
    DataReport.Orientation = rptOrientLandscape

  3. #3

    Thread Starter
    New Member
    Join Date
    Nov 2011
    Posts
    6

    Re: Data Report LandScape Orientation

    hi dilettante,

    I've been already set this code you given, but in my datareport there's no property attach or dot orientation applied(unable to set datareport.orientation),

    Thanks,

  4. #4
    Lively Member Stupidiot's Avatar
    Join Date
    Apr 2011
    Location
    India
    Posts
    95

    Re: Data Report LandScape Orientation


  5. #5
    Hyperactive Member
    Join Date
    Nov 2010
    Location
    Pakistan
    Posts
    289

    Re: Data Report LandScape Orientation

    You can download file pageset.dll from net and copy it to your project folder and insert it into your project and then you can code it as dilletante told.............
    _____________________________________________________________
    If i solved your answer plz rate my post

  6. #6
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Data Report LandScape Orientation

    Moved To The Reporting Section

    Thanks for the report mcsmba1!

  7. #7
    PowerPoster
    Join Date
    Sep 2005
    Location
    Modesto, Ca.
    Posts
    5,195

    Re: Data Report LandScape Orientation

    There's no need for "pageset.dll". you should download and install SP6 as StupIdot posted. This should be installed anyway.
    Last edited by wes4dbt; Nov 15th, 2011 at 12:15 PM.

  8. #8
    Hyperactive Member
    Join Date
    Nov 2010
    Location
    Pakistan
    Posts
    289

    Re: Data Report LandScape Orientation

    Yes, if he has sp6 then its ok, if no then he definitely will install pageset.dll

  9. #9
    New Member
    Join Date
    Jul 2018
    Posts
    2

    Question Re: Data Report LandScape Orientation

    Quote Originally Posted by mcsmba1 View Post
    Yes, if he has sp6 then its ok, if no then he definitely will install pageset.dll
    I have also set below lines before opening the data report (Installed SP6)

    Printer.Orientation = vbPRORLandscape
    DataReport.Orientation = rptOrientLandscape

    but its ignore this settings and take settings from windows default printer and shown message paper width is larger than page
    So how i will resolve this issue.

  10. #10
    PowerPoster
    Join Date
    Sep 2005
    Location
    Modesto, Ca.
    Posts
    5,195

    Re: Data Report LandScape Orientation

    You should post your actual code.

  11. #11
    New Member
    Join Date
    Jul 2018
    Posts
    2

    Re: Data Report LandScape Orientation

    please check below code for same

    DataEnvironment1.Connection1.Open
    DataEnvironment1.RepFarmerDetails_Grouping
    RepFarmerDetails.Sections(1).Controls.Item("LblCompany").Caption = ResCompany!company_name
    RepFarmerDetails.Sections(1).Controls.Item("LblReportTitle").Caption = "Farmer Crop Details Report"
    RepFarmerDetails.Sections(1).Controls.Item("LblFromDate").Caption = "From Date:" & " " & DTFromDate.Value
    RepFarmerDetails.Sections(1).Controls.Item("LblToDate").Caption = "To Date:" & " " & DTToDate.Value

    RepFarmerDetails.Orientation = rptOrientLandscape
    Printer.Orientation = vbPRORLandscape

    RepFarmerDetails.Show
    RepFarmerDetails.Refresh

  12. #12
    PowerPoster
    Join Date
    Sep 2005
    Location
    Modesto, Ca.
    Posts
    5,195

    Re: Data Report LandScape Orientation

    That looks Ok. How wide is the report? You might try re-installing SP6

  13. #13
    gibra
    Guest

    Re: Data Report LandScape Orientation

    Not
    Quote Originally Posted by pravinj View Post
    Code:
    RepFarmerDetails.Orientation = rptOrientLandscape
    Printer.Orientation = vbPRORLandscape
    but, as Dilettante wrote:
    Code:
    Printer.Orientation = vbPRORLandscape
    RepFarmerDetails.Orientation = rptOrientLandscape
    it could make the difference.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width