Search results for query: *

I have this query which pulls all the cases that are 14 calendar days old....I do not know how to change calendar to business days. So for example if I run the query as it is...I get all case with a date of 06/30/2008 but need the ones with a date of 06/25/2008. Posted is the query can...

I have a query that will pull a member's line of business desc from their current eligibility sequence. In most cases the members have only 1 current sequence, however we have a subset of the population that will have 2 current sequences. In this case when the member is chosen, if they have 2...

I have report that I need to choose a range of eligibility records based on a date parameter. I would like to display the min start date and max end date for each period of eligibility if there is no status change and no break in consecutive months of coverage. I am using Crystal XI and Oracle...

I need to compare the first 2 records for each member in a file that has multiple records. I only want to show where the status in record 1 has changed from record 2. A sample is listed below. I am using Crystal Report XI. ID# Name Status Eff Dat Term Dt Plan 12345 DOE,JANE A 20060301...

Does anyone know how to pass a parameter from a application built with power builder and using oracle to a crystal report? I need to pass a member id from a window the user has open to a report that is accessed when the user clicks a button on the window. The report is opened with Crystal...