Immunization Dates from multiple rows in one section.

[Spworf]

Hello,

I'm using Windows 7 and CR 11.5 build 2, pulling data from SQL 2005.

I have to display the dates of patient immunizations on a state form. The form has been scanned and placed into the report to underlay the data. I have variables set up for all of the occurrences of the immunizations (up to 5 dates each), and I'm trying to display them on the proper place in the scan. My problem is each immunization is in a different row of the table, so I end up with a 20 page report with one immunization date on each page. Is there a way to pull the dates of the immunizations into an array to display all of them on one level of the report?

 

[CoSpringsGuy]

Can you group by patient then underlie the form in the details section?

_____________________________________
Crystal Reports 2008 and XI
Intersystems Cache 2012 ODBC connection

 

[Spworf]

I tried that, but it still wants multiple detail sections to show all the rows. They all have to show in one detail section to show on the scanned image.

 

[lbass]

You could group on patient and collect the dates in a variable to be displayed in the group footer, with the group header and detail section suppressed.

//{@reset} for the group header:
whileprintingrecords;
stringvar x;
if not inrepeatedgroupheader then
x := "";

//{@accum} for the detail section:
whileprintingrecords;
stringvar x := x + totext({table.date},"MM/dd/yyyy")+", ";

//{@display} for the group footer:
whileprintingrecords;
stringvar x;
left(x,len(x)-2)

-LB

 

[Spworf]

Lbass,

Thanks, this put all the dates into a variable. Now I need to assign the dates to each of the separate immunization fields. Do I need a different variable for each of the immunizations? This is what I'm going forward with, but if there is a different way, please let me know.

 

[lbass]

I don't know the result you are trying to achieve--visually. Why don't you show a sample row and label the fields.

-LB

 

[Sahubba]

Hello,
I am trying to see only the customers that are being helped at the same time with the same person.
I am not sure if how I can do this in crystal.

so if {customers} has the same {Sales person} at the same {Time}
Then I want them to show up.

I hope this makes sense.