Group based on a column name given in Table.column

[sajisher]

Hi,

At run time, need pick up the text from Table1.column1. If it is 'Currency' then it should be grouped by Currency, if it is 'Country' then it should be grouped by Country.

Is this possible in Crystal report 9 pls. I googled for sometime but could get an answer for this scenario.

thanks

 

[Turkbear]

Hi,
If there are more possibilities in that field then use a formula like:

If Table1.column1 = "Currency"
then
"Currency"
else if Table1.column1 = "Country"
then
"Country"

and Group on that formula, not the Table1.column1

What should happen if it is neither?







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

I think you should show some sample data that includes your other fields that relate to this field.

-LB

 

[sajisher]

Thanks Turkbear, I will try sample report on this logic.

Thanks lbass, still need to get the actual report to be modified, then I will have more data/details to provide.

Always appreciate the support from this forum.