variable number of copies

Question

can ssrs be used to generate n copies of a single page report where the only difference from copy to copy is the text "Page x of y" in the footer?

Answer 1

Hi,

No, there is no such function as copy reports.

But you could cope and past the report body part and paste them N times to have n copies. Add page break to the first item of the report content, then you could have n copies of a single page report also the page number in the footer will act correctly.

If you have any question, please feel free to let me know.

If your problem has been solved, please click "Mark as Answer" on my reply, thank you for your understanding.

Regards,

Joy

---

""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
For more information, please refer to the sticky post.

Answer 2

cant copy and paste as the number of copies can only be determined at run time.   

does anybody else have any ideas? 

i'm wondering how someone might introduce one data source whose only purpose in life is to run n times and generate just a page number.  

is there a way to tie page breaks to one ds?

right now i have the ssrs header being populated by a couple handful of datasets indirectly thru params.  two tablix's in the body.  and a handful of fields being populated by datsets thru params in the foter.

i would have thought at least the subreport route would have been suggested.

Answer 3

Based to you original post, no, it is not possible for ssrs to run n times and so automatically.

As your second post goes,

>>is there a way to tie page breaks to one ds?

No. Page break is designed within reports level. Not to specific datasource or dataset.

It is not quite clear what your request is , since you only give "N copies" as clue, other structure or design is hard to understand for now.

---

""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
For more information, please refer to the sticky post.

Answer 4

i got this to work with subreports.  the master report calls the sub n times and passes n to be used by the sub as the y in page x of y.

Answer 5

So basically the sub would be call N times in the report as N times copy. I'm glad it works for you requirement.

---

""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
For more information, please refer to the sticky post.