To run the 8 reports at once and export it all to one Excel file, create a main report with Subreports.

Here are some sites that show how to create subreports:

We have a function that is used to create a temp table. It takes a parameter that is passed in with commas and puts each value into the table. It...

Have you tried taking the tablix out of the rectangle? What is the purpose of having the rectangle on the output?

What does it mean to "pick up the report in Report Builder"?

Does that mean open the .rdl file in Report Builder?

Thanks for the clarification,

Sarah

robert.gerald.taylor (9/6/2013)

---

Nick, here's a link explaining parameter sniffing and how to work around it:

http://www.databasejournal.com/features/mssql/article.php/3841271/T-SQL-Best-Practices-150-Parameter-Sniffing.htm

It is probably worth trying to...

TomGuide (9/2/2013)

---

Hi Folks,

Could you please let me know how to get the Report URL(i,e the URL gets generated after the report is created) from SSRS designer.

If I want to deploy...