We have web-based application for the Crystal Reports.
We just find out those running different reports with different schemas on data source (Stored Procedure) application executing only one Stored Proc.
For the different Schemas, we have same procedure name, but logic of procedures are different.
In my case running report with data source of [BTAR]. [XYZ] ‘par1’, ‘par2’ application calls right report but executes of [BTAC]. [XYZ] ‘par1’, ‘par2’
When running report itself as .rpt file it has executes right proc.
I do not think that same proc name can cause this problem.
Can someone point me to right direction?