I am new to using Crystal Reports and could use some advice. I am trying to write a report that will do a few things. The first is to give me a total of patients that a Dr. has seen and I have completed that. The second is to break out the total number of diagnosis that were Medical ( there are 80 or so), Routine ( only 3 or 4) and Test( 20 or so) codes. I have started with a simple script (which is below) to make sure I am getting the syntax correct. I put this on each line of the detail section and I am recieving a "True" for the rows that meet the "else statement" and a "False" for the rows that meet the "then statement". I was wanting this to return a 1, is this possible? I then would like to put this into a while or until loop to run through all of the records and I can put the total in the footer. Is this possible and if so can someone get me started with an example? Thank you in advance.

 

 

whileprintingrecords;
numberVar i:=0;
If {LEDGER.CODE} = '92004' then i=i+1
else i=i+0;

 

Thanks,

Ray

Could anyone give me an example on how to loop through the records to return the count of each type of Diagnosis code?

 

Thanks,
Ray