Link to home
Start Free TrialLog in
Avatar of Sailee Govekar
Sailee GovekarFlag for India

asked on

Merging Rows in Cross Tab

I am having a multiple cross tabs (on page 4 of 4)  in my report displayed below attach image
User generated imageI want to merge the rows for same name list.
As you can see, "Running Time" is repeating twice. I have taken sorting ID to bring the Values in the required format instead of viewing in Alphabetical order.

Below is the location.
https://drive.google.com/open?id=1sH07hjkIqn5JG8G8EsyX6wEe53MzbpDh
SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sailee Govekar

ASKER

Hi,

Should I give same sort Id to the same parameter name? so that it will be shown combine.
Avatar of Mike McCracken
Mike McCracken

Yes.

mlmcc
There is one NULL row in the cross tab. How do I suppress it?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
It worked by altering the Stored Procedure