Grouping action times

[FlyerNut]

Working on a report that has data such as this:

Job Number 1234

action 1 machine1 1:30
action 2 user 2:30
action 3 user 3:30
action 4 user 4:30

My SQL query grabs actions and times for users only, so the first action is action 2 @ 2:30.

I have the report grouped by job number, in the grouping I have a begin date and end date, in order to provide a summary of start and end time and total minutes used on a certain job. Currently the grouping shows action 1 through action 4, when it should only show action 2 through action 4. The SQL query runs properly in the detail section, but the grouping fails to pick up what's in the detail section and picks up all info for the job.

Any ideas?

 

[IdoMillet]

Your description is a bit confusing (at one point you say the query doesn't include Machine data and then you say it does).

In any case, sounds like you can get the data you want by either using a record selection formula to remove Machine data or use a Running Total to summarize only data for Users.

Cheers,
- Ido ixm7@psu.edu

 

[FlyerNut]

Sorry if this was confusing, maybe this will help to better explain my problem:

The data looks like this:

Job Number 1234

action 1 machine1 1:30
action 2 user 2:30
action 3 user 3:30
action 4 user 4:30


The report looks like this in the detail section, the report is grouped by job number:

Group area: JOb Number

Detail area:
action 2 user 2:30
action 3 user 3:30
action 4 user 4:30

Group footer:

Job # Start time 1:30 End time: 4:30 Total: 3 Hours

The problem is the detail area shows the right data, but the grouping shows the wrong start time, it should be 2:30.

 

[IdoMillet]

Now it's clear. You need to include the Machine data in your group, but suppress detail sections for records of Machine type by using a formula in the Suppress attribute:

{type} <> &quot;user&quot;

Cheers,
- Ido ixm7@psu.edu