Hi Everyone,

First post here!

Basically I have to make a report which uses the same table and the same fields multiple times.
The general structure is like so;

Machine Name--------Group 1
Operator Name---- Group 2
Total Operation length, Total Operation length for Maintenance, Total Operation length for Break, etc

So these come from my table. As an SQL query, I can do:

SELECT *
FROM Operations
WHERE Operations.Operation like '%maint%'

This is what I need but for the different operations. What is the best way to go about this? I thought of subreports but I have the feeling it may cause serious performance issues as the Machine is in another table so I have to link through another table to get to it;

machinetable -> recordedTime -> Operations

Extremely Confused with it all at the moment, so any response would be great.

Thanks

Hi,
This is what I'm going for, it needs to show the totals of each operation on the same report. I have tried it with subreports, but its excruciatingly slow.
[IMG]http://s27.postimg.org/tf4t647lf/crystal.png" />

So the first suggestion wont be possible unfortunately.

W̶h̶a̶t̶ ̶i̶s̶ ̶a̶ ̶C̶r̶o̶s̶s̶ ̶T̶a̶b̶?̶

EDIT: Looked at cross tabs, however, I'm not sure how to use this to select different rows based on another field.

Edited by Hwach - 14 Jul 2014 at 9:31pm

Let me try that, seems like a good way to do it!

Place the field {operations.operation} directly into your report to see the exact values. The first formula should work, as I am using it myself in several reports as well.

Edit: Make sure that the values is exactly the same (case sensitive)

Edited by Gurbs - 17 Jul 2014 at 12:30am

Okay I seem to be having an issue where it is not pulling in all of the columns. I have it setup by X=Operation, Y= OperatorName and they are summarised by length. For some reason, it pulls 2 or 3 per machine when there is actually more operations with time recorded against it stored in the database...

Edited by Hwach - 17 Jul 2014 at 11:32pm