Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS Chart Line With Markets Expand / Collapse
Author
Message
Posted Sunday, January 09, 2011 5:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 01, 2012 1:14 AM
Points: 1, Visits: 2
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
Post #1044972
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse