Search results for query: *

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

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

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

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

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

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

Hi all I am using CR9 I am trying to figure out a formula for crystal to recongnize days in "Week 1" , "Week 2" , "Week 3" etc for any given month. So far the only thing I have come up with is hard coding every month with a if day is inbetween 1 and 7 then week 1. Does anyone have a more...

Hi. I am new to this site. Cheers to anyone reading this post... Crystal 9...Using running totals in subreport and then declaring a shared variable in the subreport (the running total field is placed in a group) ex. WhilePrintingRecords; Shared CurrencyVar IndyChargesDOS; IndyChargesDOS :=...