CPEAUT Error Occured on Server. 20609 : Creating data source failed. 1

[JasGrand]

Hello, i have a report that stops working if i place a selection criteria (in the record selector formula field).

This is the formula that i use in the record selection formula:

if {?initiative} = "*" then
(
{V_PROJ_WITH_AMOUNTS_RESC.FILE_NUMBER} in {?begFileNum} to {?endFileNum} and
{V_PROJ_WITH_AMOUNTS_RESC.CLAIM_DATE} >= {?date_resc}
)
else if {?initiative} <> "*" then
(
{V_PROJ_WITH_AMOUNTS_RESC.FILE_NUMBER} in {?begFileNum} to {?endFileNum} and
{V_PROJ_WITH_AMOUNTS_RESC.CLAIM_DATE} >= {?date_resc} and
{V_PROJ_WITH_AMOUNTS_RESC.INITIATIVE_ID} = {?initiative_id}
)


The report works if the following line is taken out:

{V_PROJ_WITH_AMOUNTS_RESC.INITIATIVE_ID} = {?initiative_id}

I get the following error with the above line in the report:

"CPEAUT Error Occured on Server. 20609 : Creating data source failed."

I don't have a clue why it's not working... Any help is appreciated.

Thanks,


Jason Grandmaison

 

[JasGrand]

Sorry, i forgot to mention... the {?initiative_id} is a number parameter... and the report works in the actual crystal reports v7.0 designer... but doesn't work over the web...

Thanks again,


Jason

 

[FredHelm]

Are you using CR Version 7 installed on the web server? It seems odd that changing the record selection formula would cause a create datasource error message.

Are you using ASP to display your report over the web?
Which COM object interface are you using?
Are you manipulating the rpt file in your ASP?
Does your anonymous user have access to the datasource?

Just would like a bit more information.

Fred

 

[JasGrand]

Yeah i'm using CR v7.0 and i'm using ASP to display over the web... nope, not manipulating the rpt file through the asp... this is just a simple report... grabbing a simple view from oracle and displaying the fields with a selection criteria.

Thanks,


Jason Grandmaison

 

[JasGrand]

Hello, i have fixed the problem... i just attached that part of the select statement to the sql statement through asp.

Thanks again,


Jason Grandmaison