sql server reporting services: Add dynamically series in Dundas chart -- sql server reporting services

Add dynamically series in Dundas chart

vladsm NO[at]SPAM rambler.ru
7/25/2006 7:57:51 AM

sql server reporting services: Hi!
Does anybody know how to add dynamically at run-time a new series in
Dundas chart and bind it to the data in dataset?

For example, I have the following dataset:

LineType PoinNo PointX PointY
1 1 10 20
1 2 15 40
....
1 20 100 30
2 1 5 15
...
2 40 30 20
and so on.

I want Dundas to draw me one line (Series) per LineType value. Of
couse, I can filter out points by LineType for each Series (specifying
its values), but at design time I dont know how many LineTypes there
will bee in the dataset.

One solution is to define a lot of series at design type and show/hide
them at run-time, but it is nogood enough.

Does anybody have any idea?

P.S. Of course it is Dundas chart .NET for Reporting Services version

Thank you in advance!

Re: Add dynamically series in Dundas chart

andrewb NO[at]SPAM dundas.com
7/28/2006 2:08:59 PM

Drop the value you wish to have as the Y Value in the Data Values drop
zone (top). For the series groupings, drop the LineType field in the
Series Grouping field (right) -- this will create a new series defined
by the Y Value field for each new LineType.

Open the chart Values editor associated with the YValue to change the
chart type from the default Column Type to a Line or another series
type. You may also define the XValue for the data or drag the XValue
field in the Category Grouping landing zone (bottom).

If you have further questions, please send an email to
support@dundas.com.

Thanks

Andrew Bryan
Dundas Software

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.