Prompting failed with the following error message

[garban]

Hi all,
I am not sure if issue belongs to this forum. I did not find much about this error in any forum.
I migrated a report from Seagate Info 7.5 to Crystal Reports XI using Data Source Migration Wizard. So far I have migrated @ 50 reports. When I open report in CR XI and try to Verify Database, I am getting following error.

Also 'Map Fields' window pops up but on right hand box (Database Fields), instead of parameter names from stored proc I get "Expr1000" as parmeter name.

Error: Prompting failed with the following error message: ''
Error Source: Error code: 0x000FFFF

Meta Info:
Report has a subreport.
Report and subreport uses two different stored procedure in SQL Server 2005 which were migrated to sql server 2005 recently.

Any help is appreciated,

Thanks a lot

 

[synapsevampire]

The map fields doesn't list parameters, it lists fields.

If it defaults to an expression, then I would guess that the finalselect uses a function against a field without using an alias, so Crystal is creating one.

Check the final select in the SP and make sure that you've named all fields, as in:

select field1, field2, getdate() MyDate from table

Where MyDate is defining an alias.

-k

 

[garban]

Hi synapsevampire,
I am sorry, don't know what I was thinking, they are fields not parameters.
In final select clause, I don't have any function but I am selecting one of the parameters passed and one declared variable in SP and two fields from temp table.

Query (Final select):
select 'global_participant_id' = @global_participant_id, 'global_participant_name' = @global_participant_name, trade_product_name as 'trade_product_name',
fees as 'fees'
from #t_name
order by disp_id

global_participant_id is one of the parameters passed.
global_participant_name is declared variable (which is selected from other table using global_participant_id).
Rest two are from temp table #t_name.

I put aliases, as in query above, but it's still coming as EXPR1000 and EXPR1001 when I open report in CR XI.

Any thoughts?