I am new to crystal reports and I am trying to understand this for a while. I'm running Crystal Reports XI Please help.
Data: John respMonitor 5 ABE case MGMT4 cyst test 1 4 clair respmonitor 5 mb test 3 2 bob case mgmt 8 lyn respmonitor 4 rick test 2 33 ray test 1 31 al test 1 24 etc. .
I want to create the following data:
Group cost sumOfTests1_3 124.0 < ====== Only want a number of tests respMonitor 5.0 case 7.0 mmsmt 7.0 responitor 3 Responitor 2 caseMgmt 4 etc.
That's why I want to be able to make the tests alone except for other groups alone.
I have created a SQL expression field: {% testCM} (PatientTbl) "Select" from "PatientTbl" amount ("patient" "cost"). "Group" = 'test1' or 'patientTbl'. In my record selection I have: ["responitor", "case mgmt", "test1", "test2", "test3"] "group" = 'test2' or 'patientTbl' '"group" =' test3 ') In {PatientTbl.group} I have also created a formula field: {{test1 "," test2 "," test3 "] in {PatientTbl.group} then {% testCM}
There should be another block in the formula area to print the rest? I do not think how to collect only the costs for the group "test", while other groups are being printed individually. Not sure where to go from here.
Thanks, John
not me It looks like you need a SQL expression just add this formula and use it as your group expression and then add value. A group with a value will still show the correct value.
< Code> if {PatientTbl.group} in {"test1", "test2", "test3"] then "test1-3" other {PatientTbl.group}