I am planning to generate 8 to 15 reports in sql server report server 2008. I want to create 8 to 15 separate sql server reports and tie them together with a table of contents in a c#.net 2008 or visual basic.net 2008. I then want to export these reports into an electronic format to email to users.
Can I setup separate sql server report service files (rdls) and have the C#.NET application tie these files together? I am hoping I can export the reports to Word.
Can you give me suggestions on how to accomplish this task?