sql server reporting services: Weekday chart -- sql server reporting services

Weekday chart

Kyler
10/3/2005 1:58:03 PM

sql server reporting services:

Greetings,
I have a query that returns one row with the following columns...
Sunday Revenue
Monday Revenue
Tuesday Revenue
Wednesday Revenue
....

I want to create a chart that displays bars for each day of the week. The
problems is that the numbers for each day are COLUMNS instead of separate
rows for each day. Any ideas how I can transform this data so that it can go

Re: Weekday chart

Robert Bruckner [MSFT]
10/3/2005 6:55:49 PM

Technically it is possible to create a chart based on the given dataset
structure. However, you would need to use "static categories" in the RDL.
There is no report designer support for static categories at this point, so
you would need to hand-edit the RDL and upload to the report server. If you
really want to perform this non-trivial exercise, then you may want to
carefully study this related newsgroup thread:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=e384f9b6-d6d4-468d-b7c5-2ec0b680af14&sloc=en-us

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]