Search results for query: *

That worked! thank you

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!

thanks LBass it will need to be selected based on a parameter, so it actually looks more like this: dateadd("s",{table.seconds},datetime(1970,1,1,0,0,0))>={?Download Start Date} I tried that and it did not show in the SQL Query

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

The patients and drugs are in no particular order. my ID is actually a random number, not sequential. is there a way to do a query that would sort the table by member ID, drug name, and filldate and then add in a sequential number? then I could use that query as a base for this query.

John, Won't that compare each successive Filldate with the minimum Filldate? I'd like to compare each filldate with the previous filldate. thanks Susan

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

Sure thing. Member 1001 was in group 2 from June 30th 2006 through January 31st 2007. He should be counted in the summaries for Jul-Jan and not the others. My raw data is like this: ELIGIBILITY SBSB_ID GROUP EFF_DT TERM_DT ELIG_IND 1001 2 06/30/2006 01/31/2007 Y...

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

Can you make it a top N report instead?

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

Crystal 10, so my menus are a little off from yours, but your suggestion worked! Thanks a lot!

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