We have used the same dataset for years, it is very very simple. But it seems to me that Reporting Services can't deal with this simple dataset.
My question is: How can I get create a line chart using this dataset.
The data set consists of 1 row with 96 columns (a day divided into 96 sets of 15 minutes). Each column records how many events occurs within the 15 minutes. Along the x axis I would like to display a vertical line every 4 hours. The y axis should be numbered 0 to the highest value in the results.
I could not make this dataset any more simple than it is. But Reporting Services just chokes on this.
Here is a sample of the dataset :
1 2 0 4 5 6 7 8 9 10... 96It looks as thought what I may need is to reset the dataset to look like this:
time events
00-14 1
15-29 2
30-44 0
...
The only way I could do that with the existing tables would be 96 unions.
96 Unions!
Microsoft I must say that I am not so impressed with reporting services. Dragging fields to a myesterous chart "category" or "series" was dumb to begin with.
No comments:
Post a Comment