ReportViewer Experts: How to show multiple records one at a time? [modified]
-
I'm having a fit over here--most likely because I'm new to ReportViewer. I'm sure this must be pretty simple, but I've been banging my head against it for a couple hours and I'm hoping you can help. Available futzing time is EXTREMELY short on this one. I have a single-record-display report, with no Table/Matrix controls--just TextBoxes, lines, etc. I need to send multiple records to the report and be able to navigate through them using the report's ToolBar buttons--First, previous, next, last. Each button click should move to a different record and update that record's information in the TextBoxes. When the report is printed, a single page for each record should be produced. Currently the ToolBar shows only one record, even though the report's underlying DataTable contains many. Surely this must be possible? Thanks! -- modified at 0:55 Sunday 29th July, 2007
-
I'm having a fit over here--most likely because I'm new to ReportViewer. I'm sure this must be pretty simple, but I've been banging my head against it for a couple hours and I'm hoping you can help. Available futzing time is EXTREMELY short on this one. I have a single-record-display report, with no Table/Matrix controls--just TextBoxes, lines, etc. I need to send multiple records to the report and be able to navigate through them using the report's ToolBar buttons--First, previous, next, last. Each button click should move to a different record and update that record's information in the TextBoxes. When the report is printed, a single page for each record should be produced. Currently the ToolBar shows only one record, even though the report's underlying DataTable contains many. Surely this must be possible? Thanks! -- modified at 0:55 Sunday 29th July, 2007
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
-
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
> 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 :-)
-
> 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 :-)
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
-
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
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?
-
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?
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
-
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?
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
-
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
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 ;-)
-
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 ;-)
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
-
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
:cool:
-
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
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?)
-
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
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] }
-
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] }
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
-
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
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] }