I'm trying to create a chart in crystal reports that displays count(x) on change of A , B
it's supposed to show number of merchants "count(x)" who paid "B" for each region "A"
the problem is that on Data tab in chart expert, on the available fields, it shows only the numeric fields "e.g: region ID / payers ID" while i want it on change of names not ID
*Note: they're already displayed on the report so it's not a connection/command problem
I tried to check all the types that CR accepts in charts and it were numbers / date / varchar
the fields in my DB was "nVarchar(MAX)" I tried to change it from DB, but CR didn't get affected by this change (God knows why!) and also even if it got affected this will result in other problems , so I thought about changing the type from the CR itself and it really worked
right click on "Formula fields" > New > name your field then in formula workshop write:
CStr ({table_name.field_name})
while creating your chart, made it on change of the field you've created
I hope it helps as I've made a lot f research and came across many facing the same problem without a working solution
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments