Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Web-based application for the Crystal Reports.

Posted on 2011-02-23
3
Medium Priority
?
287 Views
Last Modified: 2012-05-11
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
Comment
Question by:LISCNY
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 34963208
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
 

Accepted Solution

by:
LISCNY earned 0 total points
ID: 34963496
We find the solution.
Latest SP for CR viewer.
0
 

Author Closing Comment

by:LISCNY
ID: 34995456
After updating SP for Crystal Report viewer application start working fine.
0

Featured Post

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question