Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. SQL Server Reporting - Designer

SQL Server Reporting - Designer

Scheduled Pinned Locked Moved The Lounge
databasesql-serversysadminquestion
14 Posts 9 Posters 2 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    moon_stick
    wrote on last edited by
    #1

    Grrrr - can MS not put together a designer that actually does WYSIWYG reports?! The amount of time I've wasted having to resize reports that are perfectly within the confines of an A4 page but magically get wider once they're exported to PDF, is verging on obscene!!

    It definitely isn't definatley

    P M D 3 Replies Last reply
    0
    • M moon_stick

      Grrrr - can MS not put together a designer that actually does WYSIWYG reports?! The amount of time I've wasted having to resize reports that are perfectly within the confines of an A4 page but magically get wider once they're exported to PDF, is verging on obscene!!

      It definitely isn't definatley

      P Offline
      P Offline
      Pete OHanlon
      wrote on last edited by
      #2

      That's more an issue with PDF and A4 not actually being the same. You can't really blame MS for that.

      Deja View - the feeling that you've seen this post before.

      My blog | My articles

      M 1 Reply Last reply
      0
      • M moon_stick

        Grrrr - can MS not put together a designer that actually does WYSIWYG reports?! The amount of time I've wasted having to resize reports that are perfectly within the confines of an A4 page but magically get wider once they're exported to PDF, is verging on obscene!!

        It definitely isn't definatley

        M Offline
        M Offline
        mejax
        wrote on last edited by
        #3

        switch 2 smthing else

        M 1 Reply Last reply
        0
        • P Pete OHanlon

          That's more an issue with PDF and A4 not actually being the same. You can't really blame MS for that.

          Deja View - the feeling that you've seen this post before.

          My blog | My articles

          M Offline
          M Offline
          moon_stick
          wrote on last edited by
          #4

          The document properties in Acrobat list the page as being A4 (8.27" * 11.69") - are you sure this is the case? Do you know what the actual dimensions are (which would be massively helpful! :-)?

          It definitely isn't definatley

          L 1 Reply Last reply
          0
          • M mejax

            switch 2 smthing else

            M Offline
            M Offline
            moon_stick
            wrote on last edited by
            #5

            mejax wrote:

            switch 2 smthing else

            Client choice of software so not a possibility.

            It definitely isn't definatley

            V 1 Reply Last reply
            0
            • M moon_stick

              The document properties in Acrobat list the page as being A4 (8.27" * 11.69") - are you sure this is the case? Do you know what the actual dimensions are (which would be massively helpful! :-)?

              It definitely isn't definatley

              L Offline
              L Offline
              leppie
              wrote on last edited by
              #6

              A4 is 210mm x 297mm, dont know inches.

              xacc.ide - now with TabsToSpaces support
              IronScheme - 1.0 alpha 3 out now

              D 1 Reply Last reply
              0
              • L leppie

                A4 is 210mm x 297mm, dont know inches.

                xacc.ide - now with TabsToSpaces support
                IronScheme - 1.0 alpha 3 out now

                D Offline
                D Offline
                Dan Neely
                wrote on last edited by
                #7

                http://www.google.com/search?q=210+mm+in+inches[^] http://www.google.com/search?q=297+mm+in+inches[^] :laugh:

                You know, every time I tried to win a bar-bet about being able to count to 1000 using my fingers I always get punched out when I reach 4.... -- El Corazon

                1 Reply Last reply
                0
                • M moon_stick

                  mejax wrote:

                  switch 2 smthing else

                  Client choice of software so not a possibility.

                  It definitely isn't definatley

                  V Offline
                  V Offline
                  Vasudevan Deepak Kumar
                  wrote on last edited by
                  #8

                  moon_stick wrote:

                  Client choice of software

                  This is very unfortunate. Sometimes, these folks, who sign our paychecks, run amuck and crazy demanding rocket launching algorithm with high precision coupled with easy maintanability accompanied by object oriented concepts in VB.

                  Vasudevan Deepak Kumar Personal Homepage
                  Tech Gossips
                  A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

                  M 1 Reply Last reply
                  0
                  • V Vasudevan Deepak Kumar

                    moon_stick wrote:

                    Client choice of software

                    This is very unfortunate. Sometimes, these folks, who sign our paychecks, run amuck and crazy demanding rocket launching algorithm with high precision coupled with easy maintanability accompanied by object oriented concepts in VB.

                    Vasudevan Deepak Kumar Personal Homepage
                    Tech Gossips
                    A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

                    M Offline
                    M Offline
                    moon_stick
                    wrote on last edited by
                    #9

                    Vasudevan Deepak K wrote:

                    This is very unfortunate. Sometimes, these folks, who sign our paychecks, run amuck and crazy demanding rocket launching algorithm with high precision coupled with easy maintanability accompanied by object oriented concepts in VB.

                    And yet it still beats Crystal Reports... :-)

                    It definitely isn't definatley

                    O 1 Reply Last reply
                    0
                    • M moon_stick

                      Vasudevan Deepak K wrote:

                      This is very unfortunate. Sometimes, these folks, who sign our paychecks, run amuck and crazy demanding rocket launching algorithm with high precision coupled with easy maintanability accompanied by object oriented concepts in VB.

                      And yet it still beats Crystal Reports... :-)

                      It definitely isn't definatley

                      O Offline
                      O Offline
                      originSH
                      wrote on last edited by
                      #10

                      I could take a crap on a piece of paper and it would be easier to work with than crystal reports :P

                      1 Reply Last reply
                      0
                      • M moon_stick

                        Grrrr - can MS not put together a designer that actually does WYSIWYG reports?! The amount of time I've wasted having to resize reports that are perfectly within the confines of an A4 page but magically get wider once they're exported to PDF, is verging on obscene!!

                        It definitely isn't definatley

                        D Offline
                        D Offline
                        DaveX86
                        wrote on last edited by
                        #11

                        Maybe try changing the Dots Per Inch (DPI) setting of your PDF printer driver?...the scaling might be happening because you're sending higher or lower resolution than the driver is set at?

                        M 1 Reply Last reply
                        0
                        • D DaveX86

                          Maybe try changing the Dots Per Inch (DPI) setting of your PDF printer driver?...the scaling might be happening because you're sending higher or lower resolution than the driver is set at?

                          M Offline
                          M Offline
                          moon_stick
                          wrote on last edited by
                          #12

                          I've managed to get it sorted though more through a 'brute force' approach of going in and reducing all the margins and spacings to as small as possible (not 0 though, since that stopped some of the reports from rendering somehow!).

                          It definitely isn't definatley

                          D D 2 Replies Last reply
                          0
                          • M moon_stick

                            I've managed to get it sorted though more through a 'brute force' approach of going in and reducing all the margins and spacings to as small as possible (not 0 though, since that stopped some of the reports from rendering somehow!).

                            It definitely isn't definatley

                            D Offline
                            D Offline
                            DaveX86
                            wrote on last edited by
                            #13

                            When all else fails, there's nothing like a blunt instrument ;)

                            1 Reply Last reply
                            0
                            • M moon_stick

                              I've managed to get it sorted though more through a 'brute force' approach of going in and reducing all the margins and spacings to as small as possible (not 0 though, since that stopped some of the reports from rendering somehow!).

                              It definitely isn't definatley

                              D Offline
                              D Offline
                              declassified
                              wrote on last edited by
                              #14

                              Depending on how you are converting the report you can specify different size margins for the PDF than the report. Calling the Render method to convert report http://msdn2.microsoft.com/en-us/library/aa258532(SQL.80).aspx[^] Some PDF specific Device Information http://msdn2.microsoft.com/en-us/library/ms154682.aspx[^] Passing Device information via XML or URL http://msdn2.microsoft.com/en-us/library/aa179622(SQL.80).aspx[^] Hope this helps ease the pain...

                              1 Reply Last reply
                              0
                              Reply
                              • Reply as topic
                              Log in to reply
                              • Oldest to Newest
                              • Newest to Oldest
                              • Most Votes


                              • Login

                              • Don't have an account? Register

                              • Login or register to search.
                              • First post
                                Last post
                              0
                              • Categories
                              • Recent
                              • Tags
                              • Popular
                              • World
                              • Users
                              • Groups