Hi All,
I've created a sample crystal report in table format using VS2005. That report gives employee details in a particular building by taking the building as a parameter. The report is working fine, but i want to change the view of the report. Suppose for building1 there are 4 employees and my report is coming like this..(shown below).
|
Building # |
Employee Id |
Employee Name |
Project |
Address |
|
1 |
2346 |
Emp1 |
FG |
HYD |
|
1 |
6543 |
Emp2 |
FGK |
HYD |
|
1 |
6546 |
Emp3 |
HJ |
DEL |
|
1 |
6525 |
Emp4 |
HK |
CHN |
Now i want to change the above report view similar to what is given below.
|
Building # |
Employee Id |
Employee Name |
Project |
Address |
|
1 |
2346 |
Emp1 |
FG |
HYD |
|
6543 |
Emp2 |
FGK |
|
6546 |
Emp3 |
HJ |
DEL |
|
6525 |
Emp4 |
HK |
CHN |
I mean to say...i want the duplicate cells to be merged and should be displayed as one..(building #: 1 and the Address Hyd)
Building '1' is repeating for all the rows in the first table. i want the 4 cells to be merged and should be displayed as given in the second table.
Can anyone plz tell me how to do this?
Thanks in Advance,
Venky