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. General Programming
  3. Visual Basic
  4. ReportViewer Experts: How to show multiple records one at a time? [modified]

ReportViewer Experts: How to show multiple records one at a time? [modified]

Scheduled Pinned Locked Moved Visual Basic
helptutorialquestionannouncement
14 Posts 3 Posters 0 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.
  • P Paul Conrad

    Why are you not using Table or Matrix controls? I've had this problem in the past and using a Table makes it go away :-> OT: I took the "U" word out of the subject line since it can upset people around here. I'd recommend modifying your subject line :)

    "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

    J Offline
    J Offline
    Jeff Bowman
    wrote on last edited by
    #3

    > I took the "U" word out of the subject line since it can upset people around here Oops, I didn't realize that! OK, I fixed it, thanks. > Why are you not using Table or Matrix controls? Er, maybe I'm missing something? If I use a Table/Matrix control, the data will display in tabular format on a single page of the report. Maybe I didn't describe it too well. I'll try again. I have 5 customers in a table. Each customer has a name, company and an account balance. I need a 5-page report with each page exactly the same except for the name, company and balance fields. Like a mail merge. In fact, EXACTLY like a mail merge. Thanks :-)

    P 1 Reply Last reply
    0
    • J Jeff Bowman

      > I took the "U" word out of the subject line since it can upset people around here Oops, I didn't realize that! OK, I fixed it, thanks. > Why are you not using Table or Matrix controls? Er, maybe I'm missing something? If I use a Table/Matrix control, the data will display in tabular format on a single page of the report. Maybe I didn't describe it too well. I'll try again. I have 5 customers in a table. Each customer has a name, company and an account balance. I need a 5-page report with each page exactly the same except for the name, company and balance fields. Like a mail merge. In fact, EXACTLY like a mail merge. Thanks :-)

      P Offline
      P Offline
      Paul Conrad
      wrote on last edited by
      #4

      You could stretch out the height of the cells to force one customer per page.

      "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

      J 1 Reply Last reply
      0
      • P Paul Conrad

        You could stretch out the height of the cells to force one customer per page.

        "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

        J Offline
        J Offline
        Jeff Bowman
        wrote on last edited by
        #5

        The 'customer' example I gave is a pretty simplified example. In reality, the report layout is pretty complex--a lot of data fields mixed in with plain text snippets, lines and so on. There wouldn't be room for the stretch you describe, I don't think. There's no way to do it in the report configuration?

        P 2 Replies Last reply
        0
        • J Jeff Bowman

          The 'customer' example I gave is a pretty simplified example. In reality, the report layout is pretty complex--a lot of data fields mixed in with plain text snippets, lines and so on. There wouldn't be room for the stretch you describe, I don't think. There's no way to do it in the report configuration?

          P Offline
          P Offline
          Paul Conrad
          wrote on last edited by
          #6

          Jeff Bowman wrote:

          way to do it in the report configuration?

          I'm not 100% about that. as far as stretching at the bottom, just have a filler row in the table at the bottom before the footer. Sure would be nice if it had a page break thing in the toolbox like MS Access Reports has :rolleyes:

          "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

          J 1 Reply Last reply
          0
          • J Jeff Bowman

            The 'customer' example I gave is a pretty simplified example. In reality, the report layout is pretty complex--a lot of data fields mixed in with plain text snippets, lines and so on. There wouldn't be room for the stretch you describe, I don't think. There's no way to do it in the report configuration?

            P Offline
            P Offline
            Paul Conrad
            wrote on last edited by
            #7

            Jeff, This might help...http://msdn2.microsoft.com/en-us/library/ms251733(VS.80).aspx[^] about setting page breaks.

            "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

            J 1 Reply Last reply
            0
            • P Paul Conrad

              Jeff Bowman wrote:

              way to do it in the report configuration?

              I'm not 100% about that. as far as stretching at the bottom, just have a filler row in the table at the bottom before the footer. Sure would be nice if it had a page break thing in the toolbox like MS Access Reports has :rolleyes:

              "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

              J Offline
              J Offline
              Jeff Bowman
              wrote on last edited by
              #8

              OK, got it! A grouped list with a page break afterward does the trick: http://msdn2.microsoft.com/en-us/library/ms251742(VS.80).aspx If all else fails, read the instructions ;-)

              P 1 Reply Last reply
              0
              • J Jeff Bowman

                OK, got it! A grouped list with a page break afterward does the trick: http://msdn2.microsoft.com/en-us/library/ms251742(VS.80).aspx If all else fails, read the instructions ;-)

                P Offline
                P Offline
                Paul Conrad
                wrote on last edited by
                #9

                I love learning something new when trying to help :laugh: I must link that MSDN link into my blog for future reference :rolleyes:

                "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

                J 1 Reply Last reply
                0
                • P Paul Conrad

                  I love learning something new when trying to help :laugh: I must link that MSDN link into my blog for future reference :rolleyes:

                  "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

                  J Offline
                  J Offline
                  Jeff Bowman
                  wrote on last edited by
                  #10

                  :cool:

                  1 Reply Last reply
                  0
                  • P Paul Conrad

                    Jeff, This might help...http://msdn2.microsoft.com/en-us/library/ms251733(VS.80).aspx[^] about setting page breaks.

                    "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

                    J Offline
                    J Offline
                    Jeff Bowman
                    wrote on last edited by
                    #11

                    I couldn't get that one to work like the list grouping. It must be the grouping that does the trick. In this case I used the table's primary key. I'll have to fiddle with this one later on when I've got some more time. (Time? You mean someday I may actually have TIME?)

                    1 Reply Last reply
                    0
                    • P Paul Conrad

                      Why are you not using Table or Matrix controls? I've had this problem in the past and using a Table makes it go away :-> OT: I took the "U" word out of the subject line since it can upset people around here. I'd recommend modifying your subject line :)

                      "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

                      L Offline
                      L Offline
                      Luc Pattyn
                      wrote on last edited by
                      #12

                      Paul Conrad wrote:

                      I'd recommend modifying your subject line

                      What is next: suggesting the OP to ask another question ?

                      Luc Pattyn


                      try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] } catch { [Google] }


                      P 1 Reply Last reply
                      0
                      • L Luc Pattyn

                        Paul Conrad wrote:

                        I'd recommend modifying your subject line

                        What is next: suggesting the OP to ask another question ?

                        Luc Pattyn


                        try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] } catch { [Google] }


                        P Offline
                        P Offline
                        Paul Conrad
                        wrote on last edited by
                        #13

                        Originally he had a certain word in his subject line that would have gotten him flamed, and he took it out :)

                        "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

                        L 1 Reply Last reply
                        0
                        • P Paul Conrad

                          Originally he had a certain word in his subject line that would have gotten him flamed, and he took it out :)

                          "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

                          L Offline
                          L Offline
                          Luc Pattyn
                          wrote on last edited by
                          #14

                          Paul Conrad wrote:

                          Originally he had a certain word in his subject line that would have gotten him flamed, and he took it out

                          I figured that, so I chose :) not :confused:

                          Luc Pattyn


                          try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] } catch { [Google] }


                          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