Hi all,
i am facing a problem regarding crystal reports.i am working on a software which contains a large number of crystal reports.A user might open a large number of reports having different information.Whe n i view in Activity monitor of SQLSERVER2005,m y software has a session with db server(its ok,as i have made it run seperate) and each report has its own session(its ok aswell).The problem which i face is even after closing report the session still exists in Database.Just imagine the overhead when 200 users connects to this software,openin g different reports.I wrote a code to dispose this report but this doesnot work effectively.I am using visual studio2005 with C# .Here is the code which is called for every report but it shows effect on the closing of all reports(all the sessions are closed when last report is closed,not before that).
private void ReportViewer_Fo rmClosing(objec t sender, FormClosingEven tArgs e)
{
// REason :To reduce overload on SQL server
CrystalDecision s.CrystalReport s.Engine.Report Document reportObj = (CrystalDecisio ns.CrystalRepor ts.Engine.Repor tDocument)crVie wer.ReportSourc e;
reportObj.DataS ourceConnection s.Clear();
reportObj.Dispo se();
crViewer.LogOnI nfo = null;
crViewer.Report Source = null;
crViewer.Dispos e();
GC.Collect();
GC.WaitForPendi ngFinalizers();
}
Please take me out of this dilema.Thanks in advance.Waiting for ur kind and quick response.
0 1958 Sign in to post your reply or Sign up for a free account.
Similar topics |
by: touf |
last post by:
hi,
I'm using Crystal reports to generate a simple report in a VB.net windows
application, I've defined all my stuffs (accessMDB,query, 2 parameters) in
the report design, and it's working fine, when a report is opened it prompts
me to input the parameters values .
But, in order to incorporate this report to my application, I have 3
quetions:
1- How can I send the parameters from my form directly (so there will be no
prompt)?
2- How can...
|
by: Henry |
last post by:
I am writing a Windows forms VB.Net/MS SQL application that utilizes
Crystal Reports. I want to be able to dynamically set the report data
source at run time. According to article
"cr_rdc9_connectionproperties.pdf" on the Crystal support web site I
should be able to do the following:
Dim ConnectionInfo As CRAXDRT.ConnectionProperties
I get a "Type CRAXDRT.connectionProperties is not defined" error from
the VS designer when I enter the...
|
by: Henry |
last post by:
I am writing a Windows forms VB.Net/MS SQL application via VS 2003 that
utilizes Crystal Reports. I want to be able to dynamically set the
report data source at run time.
I'm trying to change the the reports "integrated security" from TRUE to
FALSE via the "Set Location" dialog in the report designer with no
success. It is not intuitive (at least not to me.)
I get the following error:
|
by: Michael O'Donnell |
last post by:
Hi All
Am having major problem with crystal reports...Have
designed my report no problem, its when I try to run and
display ther report that I am getting a "Login Failed"
message. At first I thought it might have to do with the
regristration key, but that ok, when I right click on
Servers in the server explorer and then expand the
Crystal Server, there is a red x beside the Crystal
Enterprise. When I click on log in, I am asked for a
|
by: Peter Proost |
last post by:
Hi Group,
I've got an interesting problem, I don't know if this is the right group but
I think so because everything I've read about it so far says it's a .net
problem. Here's the problem, we're using crystal reports 9 and vb.net and
we're using the crystalrepotViewer to show our reports. But every time we
open a report the connection to or sql server remains, so if I open 5 forms
with the report viewer I've got 5 sleeping connections in...
| |
by: Chris |
last post by:
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...
|
by: bonita |
last post by:
In my ASP.NET page, I have 2 checkboxes for users to choose which
crystal report they want to display. These two reports use different
tables. If report1 has been choosen and displayed in the crystal
report, then I cannot check another checkbox to display report2
afterwards. If I close the website and open again, I can choose report2
and display as crystal report correct, but now I cannot check the
checkbox1 to display report 1 afterwards....
|
by: Smiles |
last post by:
Hi there,
thanks for help in advance.
here is my case.
i have form1, defines the selectionformula of form2.crystalreportview
form1:
form2.crystalreportviewer1.selectionformla = strSelection
|
by: Mark Gold |
last post by:
Hi! We have a VB application using Crystal Reports 6 that has worked
successfully on hundreds of systems for over 10 years. Now, on one
network, the application and access database does not close. It seems
to hang on the command.
When we open the application an peruse the screens without opening up
a report (using crystal reports), the application and access db closes
fine. But as soon as we run a report and then close the report and...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |