Create a new formula field.
In this formula field, joint all selected column i.e. column1 & column2 & column3. This will create a field which has all distinct values and include this field in your cross tab before the non repeating column.Now all required values will repeat in each row as you like.
Regards
world wide web development problems asp net php html xhtml css javascript jquery w3dproblems
Showing posts with label cross tab. Show all posts
Showing posts with label cross tab. Show all posts
Saturday, September 19, 2015
Wednesday, April 15, 2015
How to add serial no in crystal report cross tab
No option in crystal report instead use sql server's DENSE RANK FUNCTION
e.g.
e.g.
SELECT DENSE_RANK() OVER(ORDER BY g.[FirstColumnInCrossTab]) SrNo, * FROM
Subscribe to:
Posts (Atom)