I am using SQL Server 200 with VB6 and Crystal Report 9.2. I have a created a cross tab using SQL Server stored procedure. My table as follows:

PNo Head Amount

I have turned Head as Privot. Now the problem is every employee has different No. of heads in this table. There may be any number of rows an employee has.

How may I design a report so that all possible colums may be printed, as CR only shows the available no. of columns.