Search results for query: *

Using CR 9.2, ODBC database: I have numerical fields that = 1 or 2. I wrote a formula for each of these stating if fld = 1, assign "some kind of text." I am writing a concatenation field with each of these formula fields using chr(13), chr(10), and my goal is that if the field does NOT =1, that...

This was right. Thank you for the tip. Technonurse-Spokane

We are using Crystal Reports 9 on one computer and 11 on another. We note that the list of available tables from our SQL database are not in the list. The list gets truncated to stop somewhere in the middle of the "Ps" or the "Rs" in both. I've never encountered this. What can be done to make...

The date range is in my select statement; not in the parameters. Where in the report can I insert this SQL statement? I am unfamiliar with that? Technonurse-Spokane

I am using Crystal Reports 9. I created a formula to show me the minimum date but cannot select it in my query. It says that this must be evaluated later. How do I create a report where the resulting "n" only reflects the MINIMUM date within a date range? Technonurse-Spokane

It is a group header and I suppressed on the actual group, not the fields. When I'd zoom, it showed no field hanging out as I said before. The weird thing is when I looked at "Print Preview" in our software that talks to Crystal, I'd see a white expanse to the right of the report. Now the new...

I also have a report I'm running in version 9.2.0.448. I am getting a blank page with a very tiny header at the top. When I preview it in our application (NextGen) I see a large white space to the right with no data fields showing up at all. I also have zoomed the view and looked at my report at...

I have passed this on to a more advanced report writer and he says it looks right to him. We will try later. Thanks. Technonurse-Spokane

I am running reports out of Crystal Reports 9. Am querying an ODBC database. A while back, I constructed a report using a large Avery label format so that medications ordered by a physician today could print 4 to a page. There is now a new law that says if prescribing meds on one page, any...

Thanks, guys. I used both of your inputs. I've never used the "previous" or "next" notations before in a formula. This helped me out a lot. Technonurse Technonurse-Spokane

Database type: ODBC, Crystal version 9.0 This is what I need to do. We have patients who come in periodically to take a test which shows a numeric score. I need to run a report which shows me those patients who have accomplished a 50% or greater reduction in scores between concurrent tests. I...

Oh, I am running Crystal 9.0. Thanks. Technonurse-Spokane

I need to suppress the printing of a medication script when the med is discontinued today. My plan is to do a conditional suppress on the sections based on {RX_stopdate} = {datadate}. My {RX_stopdate} has to remain a string field because when I convert it to a date field and try to run the...

Hi SV: What I ended up doing was creating a group for my allergies and placed the group in the details section and suppressed duplication. Everything else which constituted a one-to-one relationship I put up in the report header. The allergies come in as a list now. Technonurse-Spokane

Tables used: 1. Patient and all his/her demographic data 2. Allergy table with descriptions of all allergies the patient has. 3. Medication table containing patient's specific prescriptions Expected outcome: Report prints with patient data once, and for every medication prescribed, all of...

I am trying to print electronic prescriptions from our patient database. The Board of Pharmacy now requires that the patient's allergy list show up on each prescription. So this is my scenario: I have a patient with many allergies...a one-to-many relationship. Presently one prescription is...

Thank you to your great suggestions: I am trying out a couple of things per your overall suggestions and am close to a solution. Will pulbish as soon as I have a winner. Thanks again! Technonurse-Spokane

Scenario: Person takes a certain test and gets a score. I need to find out if the person was re-tested on the same test within the next 6 months. Person may take test several times, so essentially I need to compare just 1st date and 2nd date, all being pulled out of the same field. How can I get...

Suggestions all worked great. I believe this fixed my problem. Thank you! Technonurse-Spokane

My date field that comes in is in this format: yyyy, mm, dd. I write my formula as {my_field}[5 to 6] +"/"+ {my_field}[7 to 8] +"/"+ {my_field}[1 to 4 I do not write anything in to allow for nulls. Not sure how. Technonurse-Spokane