Draw Dynamic Column with Static Columns
I have to show dynamic columns with static columns including column header and I am choosing the Cross Tab style. I have done this already in SSRS but failed to do in Crystal Report version (Crystal Report Basic for Visual Studio 2008).
Name Hair Color City Age Mobile Email
Jannie Brown Dublin 15 +353 122 1234567 Email Address
John Black Dublin 20 +353 145 1234567 Email Address
Name , Hair Color , City Age
I also face empty rows in cross tab report.
Please help and give me a chance of thanks.
Shwu Hua Gan replied
Have you tried Group by Mobile and Email and then display Max Value of Name Hair Color City Age ?
If you need to sort by name, then you can group by a formula that make up of :
Name & "-" & Mobile & "-" & Email
then display max value of Name, Mobile, Email, Hair Color City Age
Will that work?