Search results for query: *

I just wanted to thank you all. This formula did the trick: IF onfirstrecord=TRUE then 1 else IF ({Command.PATIENT_ID} = previous({Command.PATIENT_ID}) and ({Command.SERVICE_DATE_DT} = previous({Command.SERVICE_DATE_DT}))) then 0 else 1 Looks like i learned something new...

Mike, Thank you for your response. The report was initially just a data dump that would allow managers to export the results into excel. The CR is run off of a SQL Script that then populates just the detail section of the report. This worked fine. However one of the managers wanted a...

pmax9999, Thank you for the response. That solution will give me a 1 for all of my rows. So based on the data example below I would like a formula that will look at the line below and, if the patient_id and the service date are the same, will give me a zero instead of a one. If I do a...

Hello. I was wondering if it would be possible to get a distinct count of ID when a person has 1 or more rows for the same DATE. For example, Bobby has 2 DATES of 7/9/2012. I would like to show a 1 for the first row and a 0 for the second. This data is all on the "detail" level on CR...

That did the trick. The reason I was having an issue was because I was joining the sub-report using the specialty parameter field on both the main report and the sub-report. When I linked the specialty parameter from the sub-report to the specialty field of the main report it worked like a...

Thank you for your input. I placed the subreport into the specialty grouping (GH1). However I am still only seeing the last value of the subreport placed on the subreport. Example: I am only seeing the number for Pediatric Surgery. Subreport Dermatology 35,310 Endocrinology 14,246...

Hello, I created a report in Crystal 2008 and need some help. I have a subreport that generates a total by specialty. For examples: Subreport GF1 Allergy = 13160 GF1 EMERGENCY = 93308 I created a shared variable on the subreport to call onto my main report @shared wrvu = //subreport...

It worked like a charm. Thanks a bunch LB...you're awesome. I really do appreciate the help.

Thank you for the prompt response lbass. I have done what you've said and have moved formula 2 from GF2 into GH2: GF2 Session (Hidden) //Moved from GF2 to GH2 whileprintingrecords; numbervar sumx; if not inrepeatedgroupheader then...

I just had a problem getting a formula to present the correct data in the correct a GF and RF and just needed a shove in the right direction on this. It's probably something very minor but I can't seem to put my finger on it. I can't get my formula to add correctly on GF1 or RF. Any help will...