Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 291
  • Last Modified:

Web-based application for the Crystal Reports.

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.
Sample:
Schema [BTAC]
Procedure [XYZ]

Schema [BTAR]
Procedure [XYZ]

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?
0
LISCNY
Asked:
LISCNY
  • 2
1 Solution
 
mlmccCommented:
Not sure I follow the problem.

Are you running the wrong report? or is the report running the wrong SP?

If it is the "wrong" SP then remember Crystal runs the SP it was built with unless you update the report to reflect changes in the SP.

mlmcc
0
 
LISCNYAuthor Commented:
We find the solution.
Latest SP for CR viewer.
0
 
LISCNYAuthor Commented:
After updating SP for Crystal Report viewer application start working fine.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now