closing the database connection

Hi all,
sorry if this is in another post - I did a few searches and found nothing.
We have a custom asp .net ui and are rendering our reports directly to pdf.
We are running sql server stored procedures to populate our reports. What I
have noticed, however, during the course of testing the reports, is that if
you look in SQL Server EM the connections (listed as .Net SQL Client
Provider) seem to stay open for quite some time. This is a concern, and I am
trying to figure out if there is a way that we can close the connection(s) as
soon as the data has been retrieved and the report populated. I believe this
must be the connection from RS directly calling the SP to populate - has
anyone else seen this?
Thanks,Perhaps you can set some timers in the rsconfig.
I've noticed that my oracle connenctions stay open relatively long to;
although it has something to do with congestion on either de DB-server or the
RS-server. I notice that when I automticly rennder a number of reports (to
make chached-reports for all parameter values) the RS-jobs sometimes heap up
and the open connections do also (although there are never more than tree
reports rendered at the same time). The problem solves itself automaticly
thoug, everything slows down and apperantly RS gets time to clean it up.
"Myles" wrote:
> Hi all,
> sorry if this is in another post - I did a few searches and found nothing.
> We have a custom asp .net ui and are rendering our reports directly to pdf.
> We are running sql server stored procedures to populate our reports. What I
> have noticed, however, during the course of testing the reports, is that if
> you look in SQL Server EM the connections (listed as .Net SQL Client
> Provider) seem to stay open for quite some time. This is a concern, and I am
> trying to figure out if there is a way that we can close the connection(s) as
> soon as the data has been retrieved and the report populated. I believe this
> must be the connection from RS directly calling the SP to populate - has
> anyone else seen this?
> Thanks,

Client-side Printing and page hesitation

When printing reports from my normal computer to my default printer, all but
one report print without any hesitation between pages. My boss prints
reports and gets a lot of hesitation between pages for most of the reports.
If I print to a differnt printer I too get a lot of hesitation betwen pages.
Does SRS print pages as graphics or as text? Are there any settings on the
server that can alter printing performance? Anyone else having issues with
print hesitation and found a solution to the problem?When u want 2 controll the print properties u should set them at the Report
Properties->layout.
All properties in this tab are 4 the print setting.
"Rob 'Spike' Stevens" wrote:
> When printing reports from my normal computer to my default printer, all but
> one report print without any hesitation between pages. My boss prints
> reports and gets a lot of hesitation between pages for most of the reports.
> If I print to a differnt printer I too get a lot of hesitation betwen pages.
> Does SRS print pages as graphics or as text? Are there any settings on the
> server that can alter printing performance? Anyone else having issues with
> print hesitation and found a solution to the problem?

Clients?!

Is there any way to write reports for WAP, or other clients'
KKjell,
With RS reports can be generated in HTML. HTML 4.0 is used for uplevel
browsers and HTML3.2 for downlevel browsers. So, for browser-equiped
clients, such smart phones, reports should render just fine. Other formats,
such as cHTML will require writing a custom rendering extension.
Another option is to export the report in XML and apply XSL transformation
using the Data Output tab.
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Kjell Brandes" <kjell@.brandes.tv> wrote in message
news:uOjow%23lmEHA.3432@.TK2MSFTNGP14.phx.gbl...
> Is there any way to write reports for WAP, or other clients'
> K
>|||Hi Teo, Thanx for your reply!!
About writing rendering extensions.
Is this something you write about in your book, or do you have some tips on
good sites handeling this matter'
reg.
Kjell
"Teo Lachev" <teo.lachev@.nospam.prologika.com> wrote in message
news:e9SW9PsmEHA.3712@.TK2MSFTNGP15.phx.gbl...
> Kjell,
> With RS reports can be generated in HTML. HTML 4.0 is used for uplevel
> browsers and HTML3.2 for downlevel browsers. So, for browser-equiped
> clients, such smart phones, reports should render just fine. Other
formats,
> such as cHTML will require writing a custom rendering extension.
> Another option is to export the report in XML and apply XSL transformation
> using the Data Output tab.
> --
> Hope this helps.
> ----
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ----
> "Kjell Brandes" <kjell@.brandes.tv> wrote in message
> news:uOjow%23lmEHA.3432@.TK2MSFTNGP14.phx.gbl...
> > Is there any way to write reports for WAP, or other clients'
> >
> > K
> >
> >
>|||Kjell,
I don't think that the rendering extension interfaces are documented as of
this time. The functionality is there but there is no documentation or
samples to the best of my knowledge. My book doesn't include an example of a
rendering extension.
For more information about this please see the following thread:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=OgC7Pr8eEHA.1604%40TK2MSFTNGP11.phx.gbl&rnum=7&prev=/groups%3Fq%3Drendering%2Bextension%2Bsample%2Bgroup:*.reportingsvcs%26hl%3Den%26lr%3D%26ie%3DUTF-8%26scoring%3Dd%26selm%3DOgC7Pr8eEHA.1604%2540TK2MSFTNGP11.phx.gbl%26rnum%3D7
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Kjell Brandes" <kjell@.brandes.tv> wrote in message
news:ePnZPxymEHA.2140@.TK2MSFTNGP11.phx.gbl...
> Hi Teo, Thanx for your reply!!
> About writing rendering extensions.
> Is this something you write about in your book, or do you have some tips
on
> good sites handeling this matter'
> reg.
> Kjell
>
> "Teo Lachev" <teo.lachev@.nospam.prologika.com> wrote in message
> news:e9SW9PsmEHA.3712@.TK2MSFTNGP15.phx.gbl...
> > Kjell,
> >
> > With RS reports can be generated in HTML. HTML 4.0 is used for uplevel
> > browsers and HTML3.2 for downlevel browsers. So, for browser-equiped
> > clients, such smart phones, reports should render just fine. Other
> formats,
> > such as cHTML will require writing a custom rendering extension.
> >
> > Another option is to export the report in XML and apply XSL
transformation
> > using the Data Output tab.
> >
> > --
> > Hope this helps.
> >
> > ----
> > Teo Lachev, MCSD, MCT
> > Author: "Microsoft Reporting Services in Action"
> > Publisher website: http://www.manning.com/lachev
> > Buy it from Amazon.com: http://shrinkster.com/eq
> > Home page and blog: http://www.prologika.com/
> > ----
> >
> > "Kjell Brandes" <kjell@.brandes.tv> wrote in message
> > news:uOjow%23lmEHA.3432@.TK2MSFTNGP14.phx.gbl...
> > > Is there any way to write reports for WAP, or other clients'
> > >
> > > K
> > >
> > >
> >
> >
>

Client Printing Hangs

We are accessing SSRS reports using web service. We call the Render the reports using http://<server>/ReportServer/Pages/ReportViewer.aspx?reportName&rs:Command=Render

All reports render fine. However for one particular report when we click the print button on the report viewer in IE, Active-x pops up a message "Printing Now" and hangs eternally.

The error occurs even when I am logged in with Admin privileges to the machine and Active-X client works fine for other reports except this one.

Work-around tried: If I call the same report from Report Manager it works fine. Even on the server I have been able to print the report fine.

The report is just 1 page and the data loaded is also not very heavy. Any idea why client side report printing hangs?

hello... have you solved it yet? I got the same issue too.|||

Hi quantum,

Have you tried unstinstalling and reinstalling the Print Control?

You can set a registry key to on the client machine that will start client print logging. It creates a log file in your temp folder. Here is the key.

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Reporting Services]
"LogRSClientPrintInfo"=dword:00000001

You can send me the log file and I can take a look to see if I know what the issue is. Remove the online in my email address.

|||

We are also experiencing the problem from all client PCs. The problem only occurs on one report that contains a subreport. Besides the IE browser, it also hangs when trying to print from Studio 2005.

Has anyone solved this problem yet?

|||We have the same problem. Except that the problem occurs on a report containing a matrix control and no subreports. It started happening with a new version of a report. When I deployed an old version of the same report (that printed nicely earlier), it also hangs during printing.

We have RS 2000 with SP2.|||

Folks, we've seen a similar issue in our testing but were not able to reproduce the scenario for it. Without a stable repro, it makes it close to impossible to identify and fix the issue.

Would it be possible for one/some of you to follow the instructions that Brad provided earlier in this thread and then post a bug with that information, the RDL you're using, and (if possible) a sample dataset that causes the issue on our product feedback site:

http://lab.msdn.microsoft.com/productfeedback/

Thanks for your help on this,

-Lukasz

|||

the issue seems to a problem the local machine and the rights it has to install exes. My machine our organization stop us from installing any exes from the web etc. I have the same printing issue and the browser hangs.

But when I tried the same page from a machine in the DMZ zone which does not have restrictions, the priting is working fine.

|||

We are having the same issue described above, however it only appears to effect the larger reports. The other interesting thing is that we get this error, if the client waits long enough - about 10 min.

INVALID PAGE NUMBER
The requested page does not exist.

Can someone give me some more specifics as to how to run the client logging utiltity mentioned above. I am assuming that the registry edit should be made on the server - not the client? Also, where does the log file go - exactly. If it is in a %temp% directory, is this is the directory for the user under which reporting services runs, or the IIS user, or the local user or what?

We are running:
Windows Server 2003, SP2, 64bit
SQL Server 2000, SP4, clustered, 64bit
IIS 6.0 on Windows Server 2003

|||

Hi Brad,

I couldn't find the registry keys on my machine. We are using SQL Server 2005 and Reporting Services 2005. Reports are being rendered via browser using ReportViewer.aspx with various query string parameters.

I am thinking that this is not a stable approach to render reports from Report Server. Do you know if directly accessing reports from client browser using ReportViewer.aspx is not a recommended approach?

Thanks

Uday Hegde

|||

I am having the same issue, started yesterday. All of a sudden, the report wouldn't print.

here is the data from the printlog

CRSClientPrint:rint - Starting Function.
reportServerUrl = /ReportServer
reportPath = %2fAR%2fAR0006(b)+Statement+of+Accounts+-+Known+as+Name&rsessionID=wkawsv3n2prf1gv2hnili455
reportName = AR0006(b) Statement of Accounts - Known as Name
CResourceManager:etLocaleInfo - Starting Function.
SetUICulture - Starting Function.
Attempted UI LCID = 9
Using UI LCID = 1033
SetUICulture - Ending Function.
CResourceManager::LoadResourceDLL - Starting Function.
CResourceManager::LoadResourceDLL - Ending Function: 0x00000000.
CResourceManager::CanUseCurrentLocale - Starting Function.
CResourceManager::CanUseCurrentLocale - Ending Function.
CResourceManager::LoadGDIPlus - Starting Function.
CResourceManager::LoadGDIPlus - Ending Function: 0x00000000.
Attempted culture = 1033
Using culture = 1033
Culture name = English_United States.1252
CResourceManager:etLocaleInfo - Ending Function: 0x00000000.
CPrintDlg:rint - Starting Function.
CPrintDlg::InitializePrintDlg - Starting Function.
CPrintDlg::GetDefaultPrinterName - Starting Function.
CPrintDlg::GetDefaultPrinterName - Ending Function: 0x00000000.
CPrintDlg:etPrinterPaperSize - Starting Function.
CPrintDlg::GetDefaultPaperSetting - Starting Function.
CPrintDlg::GetDefaultPaperSetting - Ending Function: 0x00000000.
CPrintDlg:etPrinterPaperSize - Ending Function: 0x00000000.
CPrintDlg::InitializePrintDlg - Ending Function: 0x00000000.
CReport:etReportName - Starting Function.
CReport:etReportName - Ending Function: 0x00000000.
CReport::Fetch - Starting Function.
CReport::ComparePrintInfo - Starting Function.
Value of diff = 2
CReport::ComparePrintInfo - Ending Function.
CReport::ClearPages - Starting Function.
CReport::ClearFetchedPages - Starting Function.
CReport::ClearFetchedPages - Ending Function.
CReport::ClearPages - Ending Function.
CReport::ResetNextFetch - Starting Function.
Next Fetch set to 1
CReport::ResetNextFetch - Ending Function.
CReport:tartFetchThread - Starting Function.
CReport::GetPageToFetch - Starting Function.
Page to fetch = 1
CReport::GetPageToFetch - Ending Function.
CReport:tartFetchThread - Ending Function: 0x00000000.
CReport::Fetch - Ending Function: 0x00000000.
CPrintPreviewDlg::CreatePreviewDialog - Starting Function.
CReport::GetPage - Starting Function.
Page = 1
CReport::FetchThreadMain - Starting Function.
CReport::GetPageWrapper - Starting Function.
Page wrapper = 0x00000000
CReport::GetPageWrapper - Ending Function.
CReport::GetPageToFetch - Starting Function.
Page to fetch = 1
CReport::GetPageToFetch - Ending Function.
CReport::FetchAllPages - Starting Function.
CReport:erformFetch - Starting Function.
CReport::GetPaperSize - Starting Function.
Height = 11000, Width = 8500 IsMM = 0
CReport::GetPaperSize - Ending Function.
CResourceManager:etInvariantCulture - Starting Function.
CResourceManager:etInvariantCulture - Ending Function: 0x00000000.
CResourceManager::ResetCulture - Starting Function.
CResourceManager::ResetCulture - Ending Function: 0x00000000.
Url = http://10.1.1.130/ReportServer?%2fAR%2fAR0006(b)+Statement+of+Accounts+-+Known+as+Name&rsessionID=wkawsv3n2prf1gv2hnili455&rs:Command=Render&rs:format=IMAGE&rcutputFormat=emfplus&rctartPage=1&rc:EndPage=65535&rcageWidth=8.5in&rcageHeight=11.0in&rc:MarginTop=3.048mm&rc:MarginBottom=3.048mm&rc:MarginLeft=3.048mm&rc:MarginRight=3.048mm&rsersistStreams=True
CPage::CreateEnhMetaFile - Starting Function.
CPage::CreateEnhMetaFile - Ending Function.
CReport:erformFetch - Ending Function.
CReport::FetchAllPages - Ending Function.
CReport::GetPageWrapper - Starting Function.
Page wrapper = 0x05E76D00
CReport::GetPageWrapper - Ending Function.
CReport::GetPageToFetch - Starting Function.
Page to fetch = 2
CReport::GetPageToFetch - Ending Function.
CReport::GetPage - Ending Function: 0x00000000.
CReport::FetchPage - Starting Function.
CReport:erformFetch - Starting Function.
CReport::GetPaperSize - Starting Function.
Height = 11000, Width = 8500 IsMM = 0
CReport::GetPaperSize - Ending Function.
CResourceManager:etInvariantCulture - Starting Function.
CResourceManager:etInvariantCulture - Ending Function: 0x00000000.
CResourceManager::ResetCulture - Starting Function.
CResourceManager::ResetCulture - Ending Function: 0x00000000.
Url = http://10.1.1.130/ReportServer?%2fAR%2fAR0006(b)+Statement+of+Accounts+-+Known+as+Name&rsessionID=wkawsv3n2prf1gv2hnili455&rs:Command=Render&rs:format=IMAGE&rcutputFormat=emfplus&rctartPage=2&rc:EndPage=2&rcageWidth=8.5in&rcageHeight=11.0in&rc:MarginTop=3.048mm&rc:MarginBottom=3.048mm&rc:MarginLeft=3.048mm&rc:MarginRight=3.048mm&rs:GetNextStream=True
CReport::GetPaperSize - Starting Function.
Height = 11000, Width = 8500 IsMM = 0
CReport::GetPaperSize - Ending Function.
CReport::GetPage - Starting Function.
Page = 1
CReport::GetPageWrapper - Starting Function.
Page wrapper = 0x05E76D00
CReport::GetPageWrapper - Ending Function.
CReport::GetPage - Ending Function: 0x00000000.
CPrintDlg:rawFile - Starting Function.
CPrintDlg:rawFile - Ending Function: 0x00000000.
CReport::GetPaperSize - Starting Function.
Height = 11000, Width = 8500 IsMM = 0
CReport::GetPaperSize - Ending Function.
CReport::GetPage - Starting Function.
Page = 2
CReport::GetPageWrapper - Starting Function.
Page wrapper = 0x00000000
CReport::GetPageWrapper - Ending Function.
CPage::CreateEnhMetaFile - Starting Function.
CPage::CreateEnhMetaFile - Ending Function.
CReport:erformFetch - Ending Function.
CReport::FetchPage - Ending Function.
CReport::GetPageWrapper - Starting Function.
Page wrapper = 0x05EA5908
CReport::GetPageWrapper - Ending Function.
CReport::GetPageToFetch - Starting Function.
Page to fetch = 3
CReport::GetPageToFetch - Ending Function.
CReport::GetPage - Ending Function: 0x00000000.
CPrintDlg:rawFile - Starting Function.
CReport::FetchPage - Starting Function.
CReport:erformFetch - Starting Function.
CReport::GetPaperSize - Starting Function.
Height = 11000, Width = 8500 IsMM = 0
CReport::GetPaperSize - Ending Function.
CResourceManager:etInvariantCulture - Starting Function.
CResourceManager:etInvariantCulture - Ending Function: 0x00000000.
CResourceManager::ResetCulture - Starting Function.
CResourceManager::ResetCulture - Ending Function: 0x00000000.
Url = http://10.1.1.130/ReportServer?%2fAR%2fAR0006(b)+Statement+of+Accounts+-+Known+as+Name&rsessionID=wkawsv3n2prf1gv2hnili455&rs:Command=Render&rs:format=IMAGE&rcutputFormat=emfplus&rctartPage=3&rc:EndPage=3&rcageWidth=8.5in&rcageHeight=11.0in&rc:MarginTop=3.048mm&rc:MarginBottom=3.048mm&rc:MarginLeft=3.048mm&rc:MarginRight=3.048mm&rs:GetNextStream=True
CPrintDlg:rawFile - Ending Function: 0x00000000.
CReport::GetPaperSize - Starting Function.
Height = 11000, Width = 8500 IsMM = 0
CReport::GetPaperSize - Ending Function.
CReport::GetPage - Starting Function.
Page = 3
CReport::GetPageWrapper - Starting Function.
Page wrapper = 0x00000000
CReport::GetPageWrapper - Ending Function.
CPage::CreateEnhMetaFile - Starting Function.
CPage::CreateEnhMetaFile - Ending Function.
CReport:erformFetch - Ending Function.
CReport::FetchPage - Ending Function.
CReport::GetPageWrapper - Starting Function.
Page wrapper = 0x05ED4798
CReport::GetPageWrapper - Ending Function.
CReport::GetPage - Ending Function: 0x00000000.
CReport::GetPageToFetch - Starting Function.
Page to fetch = 4
CReport::GetPageToFetch - Ending Function.
CPrintDlg:rawFile - Starting Function.
CReport::FetchPage - Starting Function.
CReport:erformFetch - Starting Function.
CReport::GetPaperSize - Starting Function.
Height = 11000, Width = 8500 IsMM = 0
CReport::GetPaperSize - Ending Function.
CResourceManager:etInvariantCulture - Starting Function.
CResourceManager:etInvariantCulture - Ending Function: 0x00000000.
CResourceManager::ResetCulture - Starting Function.
CResourceManager::ResetCulture - Ending Function: 0x00000000.
Url = http://10.1.1.130/ReportServer?%2fAR%2fAR0006(b)+Statement+of+Accounts+-+Known+as+Name&rsessionID=wkawsv3n2prf1gv2hnili455&rs:Command=Render&rs:format=IMAGE&rcutputFormat=emfplus&rctartPage=4&rc:EndPage=4&rcageWidth=8.5in&rcageHeight=11.0in&rc:MarginTop=3.048mm&rc:MarginBottom=3.048mm&rc:MarginLeft=3.048mm&rc:MarginRight=3.048mm&rs:GetNextStream=True
CPrintDlg:rawFile - Ending Function: 0x00000000.
CReport::GetPaperSize - Starting Function.
Height = 11000, Width = 8500 IsMM = 0
CReport::GetPaperSize - Ending Function.
CReport::GetPage - Starting Function.
Page = 4
CReport::GetPageWrapper - Starting Function.
Page wrapper = 0x00000000
CReport::GetPageWrapper - Ending Function.