Sailee Govekar
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
I 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
I 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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes.
mlmcc
mlmcc
ASKER
There is one NULL row in the cross tab. How do I suppress it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It worked by altering the Stored Procedure
ASKER
Should I give same sort Id to the same parameter name? so that it will be shown combine.