Draw Dynamic Column with Static Columns

[Former Member]

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 · Accepted solution]

can you be more descriptive on what you are actually trying to accomplish.

Dynamic Columns--do you want these to update based upon parameters?

-

---

Name , Hair Color , City Age

Static Column -- these never change???

-

---

Mobile, Email

[Former Member · Accepted solution]

Thank you very much for your kind response. Actually i have dynamic Store Procedure results based on parameters and yes static column will never changed

Store Procedure Result

-

---

Mobile Age Email Key Value

-

---

+3531221234567 15 Email Address Name Jannie

+3531221234567 15 Email Address Hair Color Brown

+3531221234567 15 Email Address City Dublin

+3531451234567 20 Email Address Name John

+3531451234567 20 Email Address Hair Color Black

+3531451234567 20 Email Address City Dublin

And I want to draw report in following style

-

---

Name Hair Color City Age Mobile Email

-

---

Jannie Brown Dublin 15 +3531221234567 Email Address

John Black Dublin 20 +3531451234567 Email Address

[Former Member · Accepted solution]

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?