Monday, March 19, 2012

Dynamic Graphs

I'm tryin to create a graph, the info comes from a stored proc which takes
in the day (eg Monday) as a parameter.
The graph is then plotted based on that day.
I now want to create graphs for 7 days of the week using this same stored
proc. Can anybody give me any ideas as to how I can change the parameters
for each graph so that I can then display all 7 graphs together using 1
stored proc.Create seven data sets in your report. For each one, change the query
parameters to explicitly hand in the day (and delete the autogenerated Day
report parameter, since you won't need it). Then create seven charts,
binding each to one of the data sets.
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Kershni Chetty" <support@.sqrsoftware.com> wrote in message
news:O4bsCgKdEHA.1356@.TK2MSFTNGP09.phx.gbl...
> I'm tryin to create a graph, the info comes from a stored proc which takes
> in the day (eg Monday) as a parameter.
> The graph is then plotted based on that day.
> I now want to create graphs for 7 days of the week using this same stored
> proc. Can anybody give me any ideas as to how I can change the parameters
> for each graph so that I can then display all 7 graphs together using 1
> stored proc.
>

No comments:

Post a Comment