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.
  • 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

                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
                #10

                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

                  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
                  #11

                  :cool:

                  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