Merging in a report if data is repeated

[TSGB]

Hi,

I am trying to make a report where I have the same item in a column and I need it to be merged or just printed once for all the other fields that have the same value underneath. Example of what I have :

Field 1.....Field2.....Field3.....Field4.....Field5

1.....2.....A.....D.....F
1.....2.....B.....D.....J
1.....3.....C.....Z.....P
2.....5.....P.....Y.....R
This is how I need it to look like in the report:
Field 1.....Field2.....Field3.....Field4.....Field5

..............A.............F
1.....2............D
..............B.............J
.......3.....C.....Z......P
2.....5.....P.....Y.....R
Any Idea how to do this?

Thanks

[Rabbit]

Hi,

I am trying to make a report where I have the same item in a column and I need it to be merged or just printed once for all the other fields that have the same value underneath. Example of what I have :

Field 1.....Field2.....Field3.....Field4.....Field5

1.....2.....A.....D.....F
1.....2.....B.....D.....J
1.....3.....C.....Z.....P
2.....5.....P.....Y.....R
This is how I need it to look like in the report:
Field 1.....Field2.....Field3.....Field4.....Field5

..............A.............F
1.....2............D
..............B.............J
.......3.....C.....Z......P
2.....5.....P.....Y.....R
Any Idea how to do this?

Thanks

I have no idea how you reached that conclusion. You seem to have an extra record. Shouldn't it look like this:

New Table
        A       F
    2   B   D   J
1   3   C   Z   P
2   5   P   Y   R
 

[TSGB]

Sure the same thing but I need the Item in the middle like if you having them in excel and then merging the 3 cells and fromating to center center.

Thanks,

I have no idea how you reached that conclusion. You seem to have an extra record. Shouldn't it look like this:

New Table
        A       F
    2   B   D   J
1   3   C   Z   P
2   5   P   Y   R
 

[MMcCarthy]

Sure the same thing but I need the Item in the middle like if you having them in excel and then merging the 3 cells and fromating to center center.

Thanks,

Sorry its confusing

Can you show us the result as it would appear in Excel if you were using it.

[Rabbit]

I think I see what you're getting at ... but why do it this way? It's convoluted and confusing.

[TSGB]

I just need the format. Currently I have the report with grouping and group header and it works but the standard format for the excel document I am replacing has those repeated cells combined and centered.

I there a better way to make it more readable instead of having empty spaces in the report?

Thanks Again,

I think I see what you're getting at ... but why do it this way? It's convoluted and confusing.

[MMcCarthy]

I just need the format. Currently I have the report with grouping and group header and it works but the standard format for the excel document I am replacing has those repeated cells combined and centered.

I there a better way to make it more readable instead of having empty spaces in the report?

Thanks Again,

In the report if you set the properties of the textboxes to hide duplicates what happens?