Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Draw Dynamic Column with Static Columns

Hi All

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

Dynamic Columns


Name , Hair Color , City Age

Static Column


Mobile, Email

I also face empty rows in cross tab report.

Please help and give me a chance of thanks.

Former Member
Former Member 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?

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question