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