SSRS Dynamic Graphs
<p>Does anyone know if it is possible to create a graph(s) at run time based on the dataset?</p>

<p>To clarify, I have a count of patients suffering from a health condition, split by week. I need to make a graph per condition with weeks on the X axis and patient count on the Y. Nice and easy so far.</p>

<p>The problem is that the number of conditions displayed in the dataset will be different depending on the values entered for the start and end dates for the reporting date range. </p>

<p>With this in mind can I create a single graph then tell it to replicate once for each condition returned and only look at the data for that specific condition?</p>

<p>The graphs can't appear in rows as they must aggregate data from multiple rows (where the condition is the same) and plot the various count values over week numbers (the dataset returns a count, a week number and a condition with a group by on the week number and condition)</p>

<p>As an added challenge none of this can be hard coded as the single report has to work across multiple sites.</p>

<p>Thanks</p>

<p>P</p>