By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,853 Members | 995 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,853 IT Pros & Developers. It's quick & easy.

Crystal Report.Net DB Issue

P: n/a
I have the following situation in a VB.Net App I am working on:

1.)A report created in VS.Net 2003 using the CR.Net component of VS 2003.
2.)The datasource for the report is a Stored Proc in a SQL Server DB (pull
method).
3.)The Stored Proc has two input parameters of type date.
4.)The Stored Proc is a rather complex proc that was not written by me, but
does work(see next item). It currently returns about 13K rows of data.
5.)The Stored Proc runs fine when executing from SQL Query Analyzer. It
takes about 3 1/2 minutes to return results, but that is due to multiple
cursosrs being used in the stored proc, for the purpose of business logic
processing.
6.)The app that the report is in uses the Crystal Viewer Control to display
the report on a form.
7.)The appropriate connection info for the report to connect to the DB is
retrieved from an AppConfig file.
8.)The connection info being retrieved from the AppConfig file is correct
and as expected.
9.)Each table for each report section in the report has it's connection info
set to info retrieved from the AppConfig file.
10.)Parameter values are successfully and correctly created for the report.
11.)The ReportSource property of the Crystal Viewer Control is being
properly set.
12.)The Show method of the Crystal Viewer is called so that the control will
show the report.
13.)The version of the Crystal DLLs that I have referenced in my project are
9.1.5000.0
14.)The DB is running fine for all other areas and aspects of my app. I
also have a web app that I am coding to hit this same db and I have not had
any problems there. I have no problems with the db when doing various
actions in Enterprise Manager or Query Analyzer.

Here's the funkiness, if you are still with me:
1.)If the location property of each table in the report is set in code at
runtime, the app hangs indefinitely. I set a breakpoint before and after the
line where this prop is set and the app goes into oblivion. No error
messages, no nothing….just hangs.
2.)If I do not set the Location Prop of each table, the whole routine runs
fine…..even after the Show method call on the Crystal Viewer. However, the
app just sits and hangs and no report is ever shown in the Crystal Viewer.
Same deal as in #1….no error messages, no nothing…just hangs.
3.)If I try to do anything to the report that relates to the underlying DB
while viewing in Design mode in VS.Net(like Verify Database, Set Location,
etc), the sqlserver process takes almost 100% of the CPU resources for an
extended period of time(like more than 5 minutes).

These reports worked at one time not very long ago. I do not know of any
change to the report or database that would have triggered this behavior, and
as far as I know, no changes related to the report, the underlying stored
proc, the Crystal Viewer Control, of the form that contains the Crystal
Viewer Control were made. Basically, there is no change that I know of that
was made that I could pinpoint as a potential reason for why this behavior
started happening out of the blue. I am the only person working on this app
so no one else would have made coding changes that I was unaware of.

I have searched the web high and low on Google to get an answer, and while I
have found other people out there who have experienced situations similiar to
mine, usually these people's questions have gone unanswered.

If someone can give me a good answer or tip, I would greatly appreciate it
and rever you as a God of the computing world much more powerful than myself.

--
Thanks.

Chris Jones
Application Development Consultant
Nov 30 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.