asked on 1/4/2013

Run a SQL2008 R2 report repeatedly

I have a report that simply prints out a bar graph per client. I need the graph to repeat for every client that we have without me having to select it. I would like for it to run like a subscription if possible. Please help.

SSRS Microsoft SQL Server 2008 Microsoft SQL Server

Last Comment

rxresults

1/7/2013

Kent Dyer

1/4/2013

Do you have SSRS setup on your subscription server (basically a variation of SharePoint)? If so, setup the subscription to use a parameter to loop through all of your clients.

But.. Here is another way to think of this.. Unless you are sharing the bar graph with each client, why not have your report do a bar graph for each client in one single report?

HTH,

Kent

rxresults

1/4/2013

ASKER

I am trying the bar graph by client but I am having an issue with getting it to move to the new graph after each client. This is an activity by day report per client report if that helps.

ASKER CERTIFIED SOLUTION

ValentinoV

1/5/2013

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

rxresults

1/7/2013

ASKER

That worked perfectly thank you.