need info from old and new fields for a report

[mvalley]

I have a report that I need to pull old data as well as new data due to a field name change.
Field 1 is {anes_staff} which contains data prior to 3/1/2014. This field could have 1-3 names listed
Field 2 is {anesthesia_staff} which contains data since 3/1/2014. This field also could have 1-3 names listed

I assume it would be best to create a subreport, but I am having trouble creating one to pull all information. I would truly appreciate any suggestions. Thank you. Mary

 

[SkipVought]

hi,

Please give a tabular example of the data you might have in {anes_staff} & {anesthesia_staff} and then a representation of what you expect your report to display based on the tabular example.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[mvalley]

{anes_staff}and {anesthesia_staff} are based on patient records and may include a CRNA as well as an Anesthesiologist OR just an Anesthesiologist

Examples: MMOUSE CRNA and BMOOSE MD or just
BMOOSE MD

{anes_staff} would contain this information for records prior to 3/1/2014. On 3/1/2014, this field was changed from {anes_staff} to {anesthesia_staff} and contains the same name examples as above. The difference is that the anes_staff field was documented by nurses, and the new anesthesia_staff field is now documented by the anesthesia provider.
I need for all providers to display on the report when it is run, for all date ranges. Does my explanation make sense?
Thanks, Mary

 

[PeterDimitrov]

What is the database type? Do you have both the new and old fields in one table? Why the data from {anes_staff} was not backfilled in {anesthesia_staff} when it was created?

http://www.R-Tag.com

Viewer and Scheduler for Crystal reports, SSRS and Dynamic Dashboards.

 

[SkipVought]

Mary,

Your example is prose. I was hoping to see a TABULAR representation like...
[pre]
anes_staff anesthesia_staff
MMOUSE CRNA and BMOOSE MD MMOUSE CRNA and BMOOSE MD
BMOOSE MD BMOOSE MD
[/pre]

But then WHAT do you expect to be displayed, based on your TABLUAR example?

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[mvalley]

I fear I am not explaining myself very well, to which I apologize. Fields are as follows:

v_CRA-anes_staff
cr_urn
anes_staff
anes_staff_descr
cd_seq

v_CRA_anesstaff_clinicalrole_group
cr_urn
anesthesia_staff
clinical_role
cd_seq

What I would like to do is create a formula to display anesthesia providers that is something like the below formula. Some of these records have the same results in BOTH fields, which means the names repeat on the record. I realize this formula does not work, but is there a way I could write a formula to accomplish what I am looking to achieve?

if({v_CRA_anes_staff.anes_staff_descr}="") then ({v_CRA_anes_staff.anes_staff_descr}) else
if({v_CRA_anesstaff_clinicalrole_group.anesthesia_staff}="")and({v_CRA_anes_staff.anes_staff_descr}="") then
suppress ({v_CRA_anes_staff.anes_staff_descr} and only display({v_CRA_anesstaff_clinicalrole_group.anesthesia_staff})

 

[SkipVought]

O.L.

No example

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}