Showing posts with label cross tab. Show all posts
Showing posts with label cross tab. Show all posts

Saturday, September 19, 2015

Repeat row value in Cross-Tab crystal report

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

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.
SELECT DENSE_RANK() OVER(ORDER BY g.[FirstColumnInCrossTab]) SrNo, * FROM