By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,573 Members | 3,017 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,573 IT Pros & Developers. It's quick & easy.

Merging in a report if data is repeated

P: 14
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
Oct 16 '07 #1
Share this Question
Share on Google+
6 Replies


Rabbit
Expert Mod 10K+
P: 12,366
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:
Expand|Select|Wrap|Line Numbers
  1. New Table
  2.         A       F
  3.     2   B   D   J
  4. 1   3   C   Z   P
  5. 2   5   P   Y   R
  6.  
Oct 16 '07 #2

P: 14
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:
Expand|Select|Wrap|Line Numbers
  1. New Table
  2.         A       F
  3.     2   B   D   J
  4. 1   3   C   Z   P
  5. 2   5   P   Y   R
  6.  
Oct 16 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Oct 16 '07 #4

Rabbit
Expert Mod 10K+
P: 12,366
I think I see what you're getting at ... but why do it this way? It's convoluted and confusing.
Oct 16 '07 #5

P: 14
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.
Oct 17 '07 #6

MMcCarthy
Expert Mod 10K+
P: 14,534
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?
Oct 17 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.