Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Few Questions on MS SQL Report Service

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-12-06 : 08:34:00
Alex writes "I have a few questions regarding reports that I haven't found answers after a little searching. Thanks for any help!

1. I need to create a few reports with some repeating pages. For example, in one of them I need to have a cover page, then couple content pages, then a summary page. I need to double print the content pages. There must be a better way to achive this than manually copy-and-paste to duplicate those pages in the report design, is there?

2. Is there a way to embed a PDF file into the report somehow? Say, at the end of each report, I need to include a few pages of static information. Can I somehow have the report server to pull out a PDF file instead of putting those text into the report design?

3. Can I include other reports in a report?

4. Is there a way to control printing of the reports after I exported them into PDF for printing? Say, I want page 3 and 4 print on both side of the paper. I don't think this is possible, but asking to make sure.

5. Can I control the size of the parameter input area of the report at the top portion of the report server? I need to disply 8 input boxes. Users need to scroll down in the parameter area to see the last 2.

Thanks!"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2004-12-06 : 08:37:07
1. Subreports
2. Subreports
3. Subreports
4. Subre---ummm, no, not really. There's no way I can think of without writing your own custom print routine.
5. You can, but you'd have to write a custom web page to accept the input and pass the URL to the Reporting Server. It's not that hard, the RS docs should have an example or description of how to do this.
Go to Top of Page
   

- Advertisement -