Recent content by crzycrystlgrl

Hi and thank you in advance I use CR9 and SQL. I am trying to sum up percents for a specific period of time. Mainly what percent of my payments have come in by the average week calculated by total payments by week. EX: GROUP #1MEDICARE week 4 10000 26% week 5 20000 53% week...

ok....CR 9, SQL server, ODBC So I am trying to include records which have no return... example: so if I had three doctors i was looking to track referrals on- and 2 of the 3 referred patients - I would still want to see the 3rd doc....which doesn't show up on the report -as there were on...

you are a genius!!!!!

hello all CR 9 -- - SQL/ODBC does anyone know of a why to have crystal recognize the first space in a text field? I am trying to figure out a way to extract just the street name from an address field...and since the street numbers are anywhere from 1-6 char long...I am not sure where to...

You are a genius!!!!

Does anyone know if a free version on AdobeReader exsits for TS?

ok this is what I am trying to do... example patientA: 3 exams were preformed. (grouped on patient) detail looks like this: (and the running total counts the exam sequence 1, 2, 3) {PatientA} {ExamCode1} {#RTotal0) {PatientA} {ExamCode2} {#RTotal0) {PatientA} {ExamCode3} {#RTotal0) what i...

CR9 Okay I am trying to find a way to label an ascending order of exams. (Think medical- If you have more than 1 exam/procedure- you are the same patient with lets say 3 exams) I would like to label them 1, 2, 3 if possible. A running total works however- I need to be able to make assumptions...

thank you.

OK, CR9 + foxpro.... am trying to come up with a formula which will set an order to the number of exams a patient had been charged for. So if I had a patient who had three exams (of which all have unique transaction ids) I need to find a way to label the first exam "1" the second one...

Hi Okay so SCR 9.... I am trying to figure out a way to export a report to a text file which needs to be of a fixed character length for a various # of fields.. I looked at http://www.tek-tips.com/viewthread.cfm?qid=496291 and tried this solution..and it works...however...even using a 11x17...

Hi Okay so SCR 9.... I am trying to figure out a way to export a report to a text file which needs to be of a fixed character length. I looked at http://www.tek-tips.com/viewthread.cfm?qid=496291 and tried this solution..and it works...however...even using a 11x17 landscape orientation- I...

Might you know of some if then else statement which would say "if there was a space...then...." ? thanks

That is the problem. I cannot seem to find a common rule for all the variables. The only thing I can come up with is the first part of the field is a number (address), then a space (the name of the street), a space (whether it is a road or ave or blvd) and then a suite if applicable comes...

ok, happy sunday, I am trying to figure out a way to split an address field into four fields. I am using CR9. ex. 16543 15 MILE RD STE T4 1500 MARKER AVE #1000 211 EAST RD I need to be able to have the first line in the example to return 16453 15 MILE RD STE T4 the second one as 1500...