Grouping on one field wanted to show another field(CRcharts)

[bouser69]

Hi There

How can I solve this issue?

In Bar chart I want to group by one variable (ID) on X axis but I want to display some other Variable (Message). Because ID is the Unique one not the Message. It could be a chance that for different ID the Message will be the same because of that reason I want to group by ID but wanted to show other variable.

Any suggestions Please..

I am using Crystal XI, SQL server database

 

[lbass]

I think the only approach available is to concatenate the two, as in:

totext({table.ID},"0000")+" - "+{table.message}

Add enough zeros to match the longest ID field--this will ensure the IDs are sorted numerically. Use the formula as your "on change of" field.

-LB

 

[bouser69]

Thanks For the quick reply

Is that possible without concatenating?

Because I do have report and charts with the same purpose. For reports I did grouped by Id and in report I showed the Message. We need to have same in the chart.

I am not sure whether my Business users will accept this or not.

 

[lbass]

The reason I suggested the concatenation is because I do not think there is a way in charts to use one value for the charting, but a different value for the axis display.

-LB