Embed Chart

• bcronce

  SSCrazy

  Points: 2597

  More actions

  January 13, 2011 at 7:41 am

  #388624

  I have a bunch of user data that needs to be aggregated and organized in a custom way that I have to do it in SQL. I display this aggregated data in a table, but I also need to display a chart/graph for each of these rows.

  I need to have a chart for each row and I need it to pull its own dataset and the charts will be repeated since I need to display a chart for each customer and each customer's sub-settings.

  I'm a bit lost.

  Thanks 🙂

• bcronce

  SSCrazy

  Points: 2597

  More actions

  January 13, 2011 at 7:51 am

  #1273054

  Actually, I should find out if I can do it the "correct' way first.

  Is there a way of do this kind of aggregate using expressions and groupings in SSRS 2005:

  count(distinct case when bAtAbove = 1 then m.iuserid end)

  I need this functionality if I want to use SSRS to do my calculations for me, which would then solve my chart issue.

  Thanks again 🙂

• Linda Claes

  Old Hand

  Points: 308

  More actions

  January 14, 2011 at 1:26 am

  #1273433

  Hi bcronce,

  Please try to following statement = CountDistinct(iif(Fields!bAtAbove.Value = 1, Fields!iuserid.Value, nothing), "group_name")

  Hope this helps.

  Kind regards,

  Linda