Group headers and Columns
I am trying to create a report that looks like the following.
MachineID: 45
Time - Temperature| Time - Temperature-
4:50 - 10 | 4:54 - 10 -
4:51 - 15 | 4:55 - 05 -
4:52 - 20 | 4:56 - 04 -
4:53 - 15 |
MachineID: 46
Time - Temperature| Time - Temperature-
5:50 - 10 | 5:53 - 15 -
5:51 - 15 | 5:54 - 10 -
5:52 - 20 | 5:55 - 05 -
Im sure you get the idea... basically i want to have
2 Columns of data.... this data should be much like if you use the (BAND COLUMNS) however this lists by row.
Thus your readings will be:
1 - 2
3 - 4
5 - 6
.......
The nice thing about this is that it auto sizes to use the maximum columns available, thus creating the minimum row requirement (saves paperspace)
BUT, i am still left with the problem that i need this data looking like this
So.. basically problem #1: making the data read top to bottom and fill as much of the column spaces it has available.
I CAN NOT USE PAGE COLUMN because it will re size my group band which i need all the way from the left side to the right side of the screen.
Unless someone knows how to make my GROUP BAND ignore PAGE COLUMNS....
Anyone have any thoughts? thx...
MachineID: 45
Time - Temperature| Time - Temperature-
4:50 - 10 | 4:54 - 10 -
4:51 - 15 | 4:55 - 05 -
4:52 - 20 | 4:56 - 04 -
4:53 - 15 |
MachineID: 46
Time - Temperature| Time - Temperature-
5:50 - 10 | 5:53 - 15 -
5:51 - 15 | 5:54 - 10 -
5:52 - 20 | 5:55 - 05 -
Im sure you get the idea... basically i want to have
2 Columns of data.... this data should be much like if you use the (BAND COLUMNS) however this lists by row.
Thus your readings will be:
1 - 2
3 - 4
5 - 6
.......
The nice thing about this is that it auto sizes to use the maximum columns available, thus creating the minimum row requirement (saves paperspace)
BUT, i am still left with the problem that i need this data looking like this
So.. basically problem #1: making the data read top to bottom and fill as much of the column spaces it has available.
I CAN NOT USE PAGE COLUMN because it will re size my group band which i need all the way from the left side to the right side of the screen.
Unless someone knows how to make my GROUP BAND ignore PAGE COLUMNS....
Anyone have any thoughts? thx...
Comments
see the users manual on using the engine object.
Not sure how i can use 1 band for everything i am trying to accomplish.
Wouldent i need a group band and a master band?
that way for every different machines i have i get their respective temperatures.
Now when i dont use PAGE columns, my data apperes like this
12
34
56...
This is no good for me, i need it to look like this
14
25
36
Perhaps i should attach a proper picture....
I do have a solution for all of this but its my last resort.
I would have to recreate how i want the data to be displayed.
I know i have 2 static columns
Thus i can create a DUMMY table called recreated_readings
It would look like this.
Machine ID - COL1 - COL2
My current one looks like this
Machine ID - READINGS
Thus... i know I have 2 static columns, in this case I would have to read and write to the new table and make it look just like I want it in the report...
That way i can just place 3 FIELDS in the master data and it would accomplish what i need. HOWEVER quite the long process to do and eventually if I would like users to generate their own reports it would get ugly.
So here is my file, Il show you guys what im doing. and perhaps i am missing a required step.
I have attached a picture of how i have it now and how i need it done.
Thx for any insight, ive been on this all day.