Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Report Parameter Expand / Collapse
Author
Message
Posted Tuesday, July 29, 2008 4:19 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 21, 2009 3:29 AM
Points: 13, Visits: 79
I have a report that shows sales figures for all our employees which we run at the beginning of each month. I need to set the report to run as a subscription automatically. The report has 3 parameter sstartdate, enddate and userid.

Is there a way that you can set userid parameter to loop for all the userid and create a report for each one? or do I need to create a separate subscription for each user??

I've sorted the startdate and enddate by using these as the default parameters. =DateSerial(Year(today), month(today)+1, 1),=DateSerial(year(today), month(today), 1),

Thanks in advance
Dave


Post #542488
Posted Tuesday, July 29, 2008 5:00 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,732, Visits: 23,078
If you are using Enterprise Edition reporting services, a data-driven subscription will do this. You just have to specify a query that returns the list of userid's, dates, and email addresses.

If you are not using Enterprise Edition, you will either have to create individual subscriptions or create a custom solution yourself.
Post #542511
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse