dcsimg
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
    19,249

    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
    Super Moderator Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,335

    Re: Data Report LandScape Orientation

    Moved To The Reporting Section

    Thanks for the report mcsmba1!
    Please use [Code]your code goes in here[/Code] tags when posting code.
    When you have received an answer to your question, please mark it as resolved using the Thread Tools menu.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    I dont answer coding questions via PM or EMail. Please post a thread in the appropriate forum section.

    Creating A Wizard In VB.NET
    Paging A Recordset
    What is wrong with using On Error Resume Next
    Good Article: Language Enhancements In Visual Basic 2010
    Upgrading VB6 Code To VB.NET
    Microsoft MVP 2005/2006/2007/2008/2009/2010/2011/2012/Defrocked

  7. #7
    PowerPoster
    Join Date
    Sep 2005
    Location
    Modesto, Ca.
    Posts
    3,825

    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
    3,825

    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
    3,825

    Re: Data Report LandScape Orientation

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

  13. #13
    Frenzied Member gibra's Avatar
    Join Date
    Oct 2009
    Location
    ITALY
    Posts
    1,582

    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
  •  



Featured


Click Here to Expand Forum to Full Width