• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 301
  • Last Modified:

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.
0
rxresults
Asked:
rxresults
  • 2
1 Solution
 
Kent DyerIT Security Analyst SeniorCommented:
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
0
 
rxresultsAuthor Commented:
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.
0
 
ValentinoVBI ConsultantCommented:
To create a graph per client in one report, you can nest it inside a table. Drag a table onto the design and remove any columns that you don't need (you'll probably just want one cell).  Then group the table on the field in your dataset the identifies a client, such as ClientID.  Now put a graph inside the table, it should repeat for each client automatically.

Nested Data Regions (Report Builder and SSRS)
0
 
rxresultsAuthor Commented:
That worked perfectly thank you.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now