July 15, 2016 at 8:55 am
I have a report that the stored procedure shows 40 records but in SSRS when previewing the report, only the first record appears. Why?
The report was created from a blank report and contains multiple text boxes.
July 15, 2016 at 9:10 am
When you say contains multiple text boxes did you add them as individual text boxes or as a table/matrix. If you added individual text boxes then that is your issue.
Also remember when using Preview in visual studio it can cache the data - you need to refresh to see the latest data.
July 15, 2016 at 9:19 am
I added the fields onto the blank report because I needed a "free form" type of report. There are other text boxes with just plan text, kind of like labels. Is it still possible to get a page for each record with this format?
July 15, 2016 at 9:27 am
If you want free form then you need to use the list control. Add the list control to your report and point it at the data set. You can then layout the text boxes within this control.
July 15, 2016 at 9:34 am
Thanx.
July 15, 2016 at 9:59 am
How do I get a new page for each record? Where can I place informational text boxes that will print on each new page?
July 15, 2016 at 10:11 am
Right click on the control in the white space and select rectangle properties. Then click page break after.
Place the informational text boxes into that control as well.
July 15, 2016 at 10:21 am
Thanx.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply