Microsoft SQL Reporting Services

  mackaycc 16:44 12 Oct 2005
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 2005

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

  mackaycc 17:48 12 Oct 2005

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 2005

could you create a fith procedure that executes the other 4

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

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Microsoft Paint set to die after 32 years

Mac power user tips and hidden tricks

Comment désactiver la saisie intuitive et paramétrer votre clavier ?