Search results for query: *

We are using crystal XI on an Oracle database. We have a certain 14-digit number that can show up anywhere from 0-20 times in a field, always after the words "Order Number: ". I need a way to loop through all occurences of "Order Number: " to pull those numbers out. Thanks!

I have a similar quesiton as thread767-1300499 I need to convert this crystal XI formula: dateadd("s",{table.seconds},datetime(1970,1,1,0,0,0)) to a SQL expression so that it is passed to the database. The report runs too slowly otherwise. I tried...

Hi there, I have a table with the following fields: Key Member ID Fill Date Drug Name 1 1000512 1/12/2006 Lipitor 2 1000512 2/13/2006 Lipitor 3 1000512 3/10/2006 Lipitor ... And I need to find out the days between fills like this: Key...

Hi there, I'm using Crystal X with SQL Server 2005 and I need to find the last 12 months' eligibility counts broken down by group and month: Group Mar 06 Apr 06 ....... Feb 07 1 2000 2100 ....... 2500 2 2500 2600 ....... 3000 3 1750 1600 ....... 1800 4...

Running totals through SQL. I have a pharmacy claims database. I have a CRW 10 report using OLE DB to access a SQL server. My report identifies members who have hit a total drug spend limit and pulls their entire claims history. The report works great. However, now the report requestor...

I use Access and Crystal to report out of a SQL server, Excel files, and Access databases, sometimes all three at once. In both programs I have noticed that my records will duplicate anywhere from 2-15 times in the detail section. Select Distinct or some variation thereon only works if you...

I work with claims data, and I need to be able to analyze data on claims that we have actually paid. In our data there are some claims that were paid and later reversed, or paid, reversed, and paid again (for a different or same amount) with the same ID number. Is there a way to select and...

I am a true newbie to CR, and I have only a small amount of programming experience - forgive me is this is a truly stupid question. I am trying to design a report using claims data from several years ago, and it is just pulling data from a single Excel file for now. For a certain field we only...