Reporting logs

Ignition
1

I haven’t used the reporting module much but,
Here is what I’m trying to do.
This is what is sitting in my database:

line1 line2 line3 line4 line5 line6 line7 line8 line9 line10 line11 line12 reportdate
1 11 12 13 14 15 16 17 18 19 20 21 2011-11-20 16:12:37.663
2 11 12 13 14 15 16 17 18 19 20 21 2011-11-20 16:10:21.507
3 2 3 4 5 6 7 8 9 10 11 12 2011-11-20 14:32:05.380
4 11 12 13 14 15 16 17 18 19 20 21 2011-11-20 16:30:00.170
5 11 12 13 14 15 16 17 18 19 20 21 2011-11-20 16:06:54.247
6 11 12 13 14 15 16 17 18 19 20 21 2011-11-20 16:08:15.320

I’ve bound my report to this table and I have made the table just like this in the report.
I am trying to make a graph that would display the totals for each line. So, I may want a bar graph with 12 bars.
I also want to display the Time in the header of my graph, but I can only seem to bring in the date. I want both.

Any Ideas that don’t involve me reconstructing my table?

2

You want to use total, it is found under they Keys tab. This will give you the total for each line. The date format can be set by using the Format tab. The Mar8 button controls the date format. Select the @date@ in your header, click Mar8, enter your custom date time format.

3

I’d like to show on the graph:

line1 Line2 ect… with values of the total for that line.

This is the report designer view

I can’t seem to set this up right… I can’t even get anything to graph.
I’m not unfamiliar with reporting either, just not referencing something correctly I believe.