Creakinator
Programmer
I'm not sure if this is the right forum or not as I'm not sure if a formula or a sql expression will do this for me.
SQL databse through an ODBC connection
Crystal Reports XI
I have a table name 'cases' that has a field 'T_AGENCY_REF'. In this table I have both 'parent' cases and 'sub' cases.
The parent case contains all the demographic information including the T_AGENCY_REF number. A parent case number would be ##-##### (ex: 11-12345)
The subcase contains the statistical data I am trying to compile into a report. A sub case number would be ##-#####-A-## (ex: 11-12345-L-01).
cases.Name cases.T_agency_ref cases.Parent_case
Parentcase filled in NULL
subcase sometimes completed/sometimes null parent_case #
My report shows all the statisical data from a subcase, but I need to show the T_agency_ref field from the parent case.
I hope this makes sense. Let me know if I need to make anything clearer
Thanks.
Christy
SQL databse through an ODBC connection
Crystal Reports XI
I have a table name 'cases' that has a field 'T_AGENCY_REF'. In this table I have both 'parent' cases and 'sub' cases.
The parent case contains all the demographic information including the T_AGENCY_REF number. A parent case number would be ##-##### (ex: 11-12345)
The subcase contains the statistical data I am trying to compile into a report. A sub case number would be ##-#####-A-## (ex: 11-12345-L-01).
cases.Name cases.T_agency_ref cases.Parent_case
Parentcase filled in NULL
subcase sometimes completed/sometimes null parent_case #
My report shows all the statisical data from a subcase, but I need to show the T_agency_ref field from the parent case.
I hope this makes sense. Let me know if I need to make anything clearer
Thanks.
Christy