Showing posts with label managed. Show all posts
Showing posts with label managed. Show all posts

Sunday, February 19, 2012

Chart data from custom assembly method?

Hi!
I'm new to reporting services and have a question for you.
I've managed to get a single value from a custom assembly method and publish
it on a report,
what I want to do now is to fill a chart with data from my custom assembly
method, the data
is returned like a dataset.
Displaying a single value was no big deal, found a lot of examples on the
net and in this forum, but
setting the custom dataset as source is very hard to find.
Regards,
Peter Larsson!Isn't this possible, anyone?
/P
"Peter Larsson" <peterskola@.frillesas.nospam> wrote in message
news:eAHDhuahHHA.1624@.TK2MSFTNGP06.phx.gbl...
> Hi!
> I'm new to reporting services and have a question for you.
> I've managed to get a single value from a custom assembly method and
> publish it on a report,
> what I want to do now is to fill a chart with data from my custom assembly
> method, the data
> is returned like a dataset.
> Displaying a single value was no big deal, found a lot of examples on the
> net and in this forum, but
> setting the custom dataset as source is very hard to find.
> Regards,
> Peter Larsson!
>
>

Chart Colours

Hi,

I have a problem relating to customising colours in SQL reporting services 2000. On one of my reports i have managed this no problem. This report however used series which were stored on individual fields in the data base. i.e.

Chanrt Type : Stacked column chart

Xaxis : dates

Yaxis : counts of various status' (Known, Unknown, Understood, Designed, Verified)

each of the status types has a seperate field in the database to store the count on a given date.

The new version changes the structure of the database. I now hav a date field as before, but now a Status field (stores whatever status for that date), and a Statuscount field (storing the count for that status on the given date).

My chart now has an X axis of dates and Y axis of the value of the status field. The difference here is that there are not individual series from which i can change the colour.

Does anyone know of a way to customise the colour of this chart? I appreciate i may not have explained myself too well so apologies if this post makes no sense.

Many thanks in advance

Grant

Hi again,

Nevermind. I have managed to resolve the problem. It seems that i needed to put a function into the code section of the report properties which selects a colour depending on the value of the series filed. I can then call this function from the series style fill attribute. Seems to work just perfect.

Cheers

Grant