concatenating data

[garycc]

I am a brand new user with no training. I need to add patient allergies to a presciption form. I have added the field successfully. Unfortunately, if the patient has 3 allergies, the prescription prints 3 times, once for each allergy. I tried adding allergy.name + allergy.name (etc) and it printed the same allergy that number of times. Can someone point me in the right direction. Please??

Thanks

 

[synapsevampire]

Insert a group for the Prescription and show the Prescription in the group header, and the alleriges in the details.

You may have some specific output concerns, but you need to share them if that's the case.

In general, share:

Software edition and version (any technical support request should include this()
Database/connectivity used
Example data
Expected output

Hope this helped.

-k

 

[garycc]

I apologize for my lack of knowledge. I cannot get the group function to work as expected within this report.

I am using Crystal Reports 8.5 with an ODBC connection. I have been able to create a seperate report that is does group allergies by patient name:

First Patient
Penicillin
Advil

Second Patient
Milk
Entex
Penicillin

The report I am trying to add this information too however, looks like this:

Name: First Patient (@PatientName)
Addr: 1234 Road (@StreetAddress)
City: Cinti, Ohio 12345 (@Citystatezip)

RX: Albuterol 90 mcg/act aers (@RX)
Disp: 1 (@disp) Refill: 5 (@refill)

Allergies: _________________

Right now as I said, it prints 2 presciptions (one for each allergy). I was not able to recreate the group correctly, (it would print 1 and 2, 2 and 3, and 1 and 3 of 3 allergies). I was wondering if it would be possible to do this with an if/then sort of formula that looked to see if there was another allergy listed. Is this possible?

Thanks again

 

[synapsevampire]

No need to apologize, you're doing fine.

Rather than suggesting architecture, you might be better served to describe your environment. Posting what you have when it's incorrect isn't very useful.

"Cannot get it to group" doesn't describe the situation.

Please state any errors or improper results. Perhaps this date is NOT a date, rather a numeric or string representation of a date.

Right click it and select browse data, it will tell you how Crystal interprets the data type and show examples.

Example data should state fields used and their type, expected out should show what the results would look like based no the example data.

Also posting the database type might prove useful, ODBC is just a type of connectivity (which is generally slow, but often time unavoidable).

-k

 

[synapsevampire]

Sorry, I was confused about the date part, please ksip that (2 threads going at once).

But please state what cannot group means.

Use Insert->Group and select the field.

-k