Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Stored procedure for the crystal report is getting Post Reply Post New Topic
Author Message
goirik
Newbie
Newbie


Joined: 17 Apr 2007
Location: India
Online Status: Offline
Posts: 3
Quote goirik Replybullet Topic: Stored procedure for the crystal report is getting
    Posted: 17 Apr 2007 at 12:12am

In our project we have a requirement to execute Crystal Report with stored procedure as their data source. Here we have used the Crystal Report XI as the reporting tool and Sybase as the database. The problem is that for each time when the report is executed, the stored procedures are getting executed twice. Due to this reason reports are taking more time to execute. We have also found that this problem exists with the XI version of the crystal report only. We tried the same with crystal report version 7 and found that the stored procedure gets executed only once. For this issue we have already installed the service pack 3 for Crystal Report XI. But the issue is not resolved yet.  We stuck with this problem for a long time but till now we have not got any solution. Any help in this regard is highly appreciated.

IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 17 Apr 2007 at 9:14am
This is a bug that should be reported to tech support. Do you have a simple sample to recreate the problem using the SQL Server example database? I could notify them of the problem.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
anil
Newbie
Newbie


Joined: 17 Apr 2007
Location: United States
Online Status: Offline
Posts: 9
Quote anil Replybullet Posted: 17 Apr 2007 at 11:08am
I don't think this problem is being caused by crytal, we are also calling stored procedure in XI but our stored procedure is executing once. Did you  executed the stored procedure in isql or dbartisan?
anil
IP IP Logged
goirik
Newbie
Newbie


Joined: 17 Apr 2007
Location: India
Online Status: Offline
Posts: 3
Quote goirik Replybullet Posted: 17 Apr 2007 at 10:32pm

Thanks BrianBischof for your valuable reply.

If you will get any information regarding this issue from tech support please inform me.

Thanks in advance.

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.