Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Merging cells after execution in report server 2005

Status
Not open for further replies.

Stripes1283

Programmer
Jun 13, 2007
28
ZA
I have two sections on a report a member side and a beneficiary side. The members side only needs to show one member for whatever amount of beneficiaries is allocated to this one member. The report used to work as example 1 below. I then used the previous function in report server so that it works like example2. This worked fine but now it left me with an open cell where the second "James" used to be. So they wanted me to merge the cells so that "James" display in one cell and merge with the other "James" cell.
I could not find a merge function for this so i simply made the top and bottom borders "None" as order by a IIF statement. This worked fine until i tried to export it to pdf then it just showed me the cells for the second "James", when i export it to excel the merging was fine it worked but i require it to work for pdf. Any ideas pls?
Or even an actual way to merge cell after execution, using an IIF statement.

Example 1:

Member Beneficiary
---------------------------------
James Leon
James William


Example 2:

Member Beneficiary
---------------------------------
James Leon
William

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top