Microsoft SQL Reporting Services

  mackaycc 16:44 12 Oct 05
Locked

I am currently trying to run a report several times over but with different parameters in each report. Throughout all the reports two of the parameters will remain the same but one will change for each report. I then want this exported to Excel on different sheets. I have worked out how to export to the different sheets on Excel but would like some pointers on how I would get the report to run automatically with different parameters.

Thanks

  Access genu 17:45 12 Oct 05

have you looked at using a stored procedure and passing the parameters into that

  mackaycc 17:48 12 Oct 05

The report actually runs from four separate stored procedures. What I need really is the likes of a subreport which can be called with one of the parameters being changed each time.

  Access genu 17:53 12 Oct 05

could you create a fith procedure that executes the other 4

This thread is now locked and can not be replied to.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced