Report Grouping

[mountaindo]

Hi,



I would like to do the simplified example report below and can't quite get the grouping right to do what I want.

My table looks like:

Employee X	.5	January
Employee X	.6	February
Employee X	.7	March
Employee Y	.5	January
Employee Y	1.0	March

I want my report to display:

	January	February	March
Employee X	.5	.6	.7
Employee Y	.5		1.0

My current report is grouped in the Detail section, and uses iif to display:

	January	February	March
Employee X	.5
Employee X		.6
Employee X			.7
Employee Y	.5
Employee Y			1.0

Or I tried to group on employee name but it will only show one of the records, i.e.:

	January	February	March
Employee X	.5
Employee Y	.5

So my question is how do I using the grouping to only list each employee once, while also displaying the multiple records?

Thanks!

[June7]

Are you using the report Grouping & Sorting tool that opens at bottom of the report in design view?

Employee name/ID in group header section. Other data in Detail section.

[mountaindo]

Thanks for the quick response!

Yes, that's the grouping I was using.

[June7]

And data in Detail section?

If you still have issue, can you provide db for analysis? Follow instructions at bottom of my post.

[mountaindo]

Doing it that way still has seperate lines like in the "current report" version in my original post.

I'm looking to display all three months on one line.

[June7]

I should have read your OP more carefully.

You don't want to use standard CROSSTAB?

With query using IIf expressions, make it an aggregate query grouping on the Employee and use the Max function under each month calculated field. Use that as the report RecordSource.

[mountaindo]

I've never used a CROSSTAB before but I'll do some research and try it out.

Thanks for your help and time!

[mountaindo]

CROSSTAB was just what I was looking for. Thanks again!