Search results for query: *

Thanks Ian. Only other step I had to add was to group by visit date as many of the patients had multiple visits and I needed to report their equipment for each visit. Thanks again!

Hi, I am working on a report where I am pulling data from a patient's chart. I need to pull 1) a yes or no answer to a question & 2) if yes to first question, then the type of equipment. Problem is, both values for question #1 & #2 are the same field. The way I can distinguish them is by...

Hi, I am working on a report where I am pulling data from a patient's chart. I need to pull 1) a yes or no answer to a question & 2) if yes to first question, then the type of equipment. Problem is, both values for question #1 & #2 are the same field. The way I can distinguish them is by...

Thank you fisheromacse. Your formula worked; my report is pulling the correct dates. [ponytails]

Hello, I am trying to write a Crystal Report formula for a report that will would be scheduled to run automatically each month and provide associates who were hired between the 2nd up until the last day of the month for the prior month. So for example, if I ran the report as of the 6th of...

Hi, I am trying to include phone numbers on an associate listing. However, not all associates have a phone number listed in the database. Therefore when I add in the phone number field, only those who have a phone number are displayed on the report. Therefore, I tried creating an ISNULL...

Yes, the formula was in the records selection formula and the drop down states exceptions for nulls. I tried your suggestion of putting the field in the detail section and it did not work. I only received records that had a charge number (were not null). Any other ideas?

Sorry, I meant to say that I do not receive any records.

Hi, In my crystal report, I am trying to display only those records that do not have a charge number associated. I have tried the following formula and I do receive any records: ISNULL({phcharg.charge_no}} Any suggestions? Thanks, Meg

Hi, I am writing a report in which I need to provide a sum if the person has more than one pay check per the pay period. I can only display one total hours, net and gross per person. Unfortunately, it is not as simple as creating a formula to add multiple checks together as I am creating this...

I had the formula written in the right spot, just not the correct format! Thank you for your help :-)

Hi, I am trying to write an if/then statement in crystal reports, however I keep receiving an error message stating that a boolean is required. Here is my formula: if {time_project_tasks.task_code} in ["WORK"] then ("003652252-070196") Or if {time_project_tasks.task_code} in ["MGTGS"] then...

Hi, I am writing a crystal report and am working with a table that contains pay rates and effective dates. If a person has had pay increases, they have multiple pay rates and effective dates within the table. My question is, how would I write the formula to state that I only want the most...

Hi, I am trying to write an if/then statement. I have a code that is five digits long. What I want the formula to do is if the last digit of the code is a '1', then I want the word 'Manager' in my report. I tried the following: if {emp_person.distribution_code} = 'xxxx1' then 'Manager' Any...