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...

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...

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

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...

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...

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...

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...

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...

I am experiencing what seems to be a random problem. All of the dates I pull into CR are string fields which I convert to date fields. Most of the time these fields work fine, but sometimes when I rerun a report, which has been successful initially, I will get this error "Bad date format...

I am building a report which includes fields from a static table which has a one-to-one relationship with a patient demographics table. These fields are in section A with an equal join. In section B, I need to import fields where the tables have a one-to-many relationship with the patient...

I am trying to create one report for prescriptions, whereby if a patient is ordered 4 medications, I can split the report into 4 equal parts and have the different RX's print in each corner. What I'm getting now is that the upper half prints the same medication twice as does the bottom half so...

I am trying to create a report for prescriptions to print. I want to populate the page with 4 separate reports so that if 4 different medications are ordered on the patient, the 4 different meds show up on the same page divided into fourths. What I'm getting now is a mirror image from left to...

I am running a report which features a summary column (Total # of appointments the patient has had). I have grouped the account number field. This sum formula is set up like this: sum ({Patient_appts}, {Patient_AccntNumb}) I am adding a grand total based on COUNT of account numbers...

I need to compare a specific date field with exactly one year from that date. My formula needs to populate a column with an "X" if that specific date ages more than one year. E.G. A review was conducted on 10-3-02, so when 10-3-03 comes around, the "X" needs to populate the...

I need to know specific ranges of dates of birth of our children who have received vaccinations within a given month. Therefore, I have a need to know how to declare a date range variable, something I've never done. Example: Need to know vaccines given to children, age 0-1 year, then age 2...