SSRS Chart Line With Markets

• adid

  Newbie

  Points: 9

  More actions

  January 9, 2011 at 5:59 am

  #63769

  hello !

  i running .rdl report with chart line with markets.

  in the chart i define :

  series group - QCTypeId

  categroy group - timeStamp

  values - valActual

  here is data for exaple :

  QCTypeId timeStamp valActual

  ======================

  2 , 22/11/2010 , 5

  2 ,23/11/2010 , 6

  2 ,24/11/2010 , 7

  3 ,22/11/2010 , 8

  3 ,24/11/2010 , 10

  the problem is that the graph is draw all the markets but without all the lines.

  if i filter the report to view just the data for QCTypeId = 2 i see three points with lines between them. if i filter the report to view just the data for QCTypeId = 3 i see two points with line between them. but if i filter the report to view QCTypeId = 2, 3 i see all the points but with lines between the points with QCTypeId = 2 only. the problem is that i don't have data for QCTypeId = 3 and timeStamp = 23/11/2010. i go to properties of the chart series and set emptyPoint->color to be "Lime" color for eample and than i saw i line between the 2 points of QCTypeId = 3. the problem is that all the groups with "Missing points" will get the color "Lime" instead of random color as menthioned in the legened area. how can i fix the lines color to be randomly ?

  thank you,

  adi damty