December 16, 2011 at 10:38 am
I'm going to try to explain this the best I can.
I have a chart that show's registrations in a week out format (for example week 17 or 17 shows 25 people registered, week 16 of 17 shows 25 registered....) My current chart will show weeks out across the bottom and numbers on the vertical axis and both weeks are showing 25. What the business wants is the have the cumulative number of people registered at each week point. So what that would mean is week 17 would show 25 for example and week 16 would show 50 and so on all the way up to wk 0 (day of the event). the chart would show only positive up flow like a growth chart.
The data and the query work out fine. The data set is pulling back the individual person the date they registered and the WeeksOut. Maybe I need to do some grouping on the query?
How can I produce that in BIDS, If there is a tutorial or article out there that might help please pass that along as well.
Thank you in advance.
December 18, 2011 at 4:42 am
Hi
You said the data and query are fine, so do you have the query that groups the data to week? If so just use that as a dataset in BIDS report. Just drag and drop the weeks into Category Groups and the registrations to Values section of the graph.
That will give you the graph you are after. You may want to choose column or Line Graph (preferred).
As long as you have the data and query structured properly you can easily create a graph in SSRS.
I have uploaded a new video couple of days ago to my blog site, on how to create a graph/chart, watch that if you are not sure how to create a graph in SSRS. http://www.bitipsntricks.com/?p=320
Feel free to contact if you have any further questions,
regards
Natraj
December 19, 2011 at 6:17 am
Got it figured out it was not a data problem I had to do some other things with the grouping (well more like a different formula that was running total instead of just count. All is good now. Thanks for those that sent suggestions
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply