Cannot Print From ReportViewer When Using HTTPS
Nov 1, 2007
Hi,
We are using the ReportViewer web control (SSRS 2005) to render server reports on a webpage that is exposed over the internet. Clients connect using HTTPS, however they are connecting to an ISA server which forwards the requests to the website using plain HTTP.
Reports are shown correctly, however when the user clicks the print button, the request to the web server is sent using HTTP not HTTPS and the ISA server is not allowed to accept incoming HTTP traffic. The result is that reports cannot be printed. We have proven that the reports do print if we manually alter the request to use HTTPS, so there is definitely no problem with our printers.
The problem is that we cannot work out how we can get the print request to be automatically sent using HTTPS.
We had a similar problem when we implented ReportBuilder, but we got around this by specifying HTTPS in the ReportServerExternalUrl tag in the RSWebApplication.config file. Unfortunately this has no effect on the print request from the ReportViewer.
So if anyone has got a solution/workaround/suggestion for this problem we would be very grateful.
Thanks,
Dean.
View 1 Replies
ADVERTISEMENT
Jul 4, 2006
Hi All,
How can I use the Print event of ReportViewer control in my web application? I am trying to print a server report automatically so that the user does not have to click on the Print button in the tool bar of the report viewer.
I came across one article that talks about the Print event -
http://msdn2.microsoft.com/en-us/library/ms318531.aspx
But I could not find it in VS2005 version that I am using.
Please let me know if there is a method to print the report automatically other than exporting it to some file and printing it from there.
Any help will be greatly appreciated!!!
View 3 Replies
View Related
Nov 5, 2007
is it possible to close automatically report preview after user's print
Noticed there is event print but it fires *before* printers dialog show
I need somethink like AfterPrint
Plz help
View 2 Replies
View Related
Dec 29, 2006
We are experiencing a problem where a server report is rendered in the
ReportViewer control successfully but when the user chooses to print the
content, the print output is incomplete (ex. only 18 of 23 pages are printed,
etc.).
This is happening consistently and has been reproduced for multiple
different reports. It does not happen if the same report is printed via the
Report Manager web interface.
I have also found that if I switch to Print Layout mode and then initiate
the print from the ReportViewer that the problem does not occur. This is our
current workaround, but it would be nice to know what is causing this and
have it fixed.
Has anybody else seen this? Is this a known issue with my current version
(SQLRS 2005 with SP1 applied).
Thanx in advance.
View 3 Replies
View Related
Nov 30, 2007
Hi,
I have a MS Reporting Services Report which I display in a ASPX page inside a iFrame (i.e. an other ASPX page displayed inside the main ASPX page).
The report is rendered to the screen using the normal ReportViewer control.
Everything works fine, except when I click on the Print Button on the ReportViewer control, I get a Blue Screen of Death (BSOD) and my computer restarts.
This is something that happens every single time I click on that Print button
Has this happenend to anyone else?
Regards,
Thysie
View 4 Replies
View Related
Sep 27, 2007
Dear Friends,
I am facing the following issue in SSRS:
Problem:
When SSRS report is viewed in Reportviewer control in FIREFOX browser, then Print,Zoom and Search tool bar icons are not displayed.
The same problem is also seen, when SSRS report is viewed using URL in Firefox browser.
Description:
When SSRS report is viewed using reportviewer control in IE browser, then All tool bar icons are displayed.
Following are the Toolbar icons displayed:
1. Search.
2. Next Prev Button
3. Print
4. Zoom
5. Export
But, when the same SSRS report is viewed using Reportviewer control in Firefox browser, then following toolbar icons are not displayed:
1. Print
2. Zoom
3. Search
I would appreciate any pointers to resolve this issue.
Thanks,
S Suresh
View 1 Replies
View Related
Sep 27, 2007
Dear Friends,
I am facing the following issue in SSRS:
Problem:
When SSRS report is viewed in Reportviewer control in FIREFOX browser, then Print,Zoom and Search tool bar icons are not displayed.
The same problem is also seen, when SSRS report is viewed using URL in Firefox browser.
Description:
When SSRS report is viewed using reportviewer control in IE browser, then All tool bar icons are displayed.
Following are the Toolbar icons displayed:
1. Search.
2. Next Prev Button
3. Print
4. Zoom
5. Export
But, when the same SSRS report is viewed using Reportviewer control in Firefox browser, then following toolbar icons are not displayed:
1. Print
2. Zoom
3. Search
I would appreciate any pointers to resolve this issue.
Thanks,
kk
View 5 Replies
View Related
Mar 2, 2007
We are having problems printing Reports (when printing by clicking on the AcitiveX print control), where the font for the fields are set to "C39HrP24DhTt" (barcode).
While viewing the report it displays as Barcodes but while printing, the Barcode does not get printed, but the string gets printed.
Environment: SSRS 2005
Using the ReportViewer Control in a .Net 2.0 Web App to render the reports.
BarCodes print fine in the following situations:
1. When the Report is exported to Excel and when printed from there
2. When you click on the print button on Internet Explorer
3. When saving as html (from view source) and opening that html document and printing.
BarCodes do NOT get printed in the following situation:
1. When printing by clicking on the "Print" (Active X Control) icon. Even the "Print Preview" does not show the Barcode.
View 2 Replies
View Related
Mar 15, 2006
I am going to use https for our website. Will this encrypt all of our web page? Can i just use https for some of pages?
Many thanks.
View 1 Replies
View Related
Mar 20, 2007
UPDATE #2: When it said "Do you want to install Microsoft SQL Server" I said "yes" and that caused it to work. I exited and re-ran and now the print runs w/o the "install SQL Server" (If the prompt had said "Do you want to install the print dialog" we wouldn't be having this discussion...)
UPDATE: After posting this i discovered that the same thing occurs when attempting to print the report direct from IE6: First a dialog pops up "Do you want to install this software?" Name: Microsoft SQL Server. When I click "Don't Install" I get the dialog "unable to load client print control." Since this happens direct from IE6 I suspect it's browser settings. I'll resume tomorrow and post a followup.
My WinForm C# app integrates Reporting Services by calling them from WebBrowser controls. The problem is attempts to print cause a dialog: "unable to load client print control."
I've read prior posts that say "enable Active-X in your browser" - I don't know how to do that from a WebBrowser control.
Any ideas how to support Reporting Services "Print" from within a WebBrowser control?
RELATED THREADS
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=332145&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=264478&SiteID=1
View 1 Replies
View Related
Jul 23, 2005
My host does not provide a good web based management tool for the sqlserver database I am using. They queue imports and exports so it takesseveral hours before things are finished. They provide this web basedaccess and access through asp or asp.net. Does anyone know how I couldtunnel a connection from enterprise manager to the database using aasp.net web application?ThanksTy
View 1 Replies
View Related
Sep 18, 2006
Hi there
I have two machines one 64bit machine with SQl 2005 on it and another 32 bit machine which I use as my web server both running win2003. I have followed the knowledgebase article from Microsoft (http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx) and also researched postings on this site but can't seem to access the cubes remotely. I have changed to msmdpump.ini file to have the <ServerName>mycomputername</ServerName> which points to the SQL box.
I can connect to the cubes from the 32 bit machine using somethign like crystal reports and connecting directly to the server name but can't connect to https://localhost/olap/msmdpump.dll I get an error about could not connect to the computer name or the computer is not runing analysis services.
Any ideas?
Cheers,
Derek
View 3 Replies
View Related
Jan 22, 2006
Hi,
In my CLR stored procedure, I made a https request. To by pass the security check, I change the property of ServicePointManager: ServerCertificateValidationCallback . But SQL server 2005 does not allow me to do this and gives me exception related to security.
It seems the CLR assembly does not have permission to set the property of ServicePointManager: ServerCertificateValidationCallback.
What kind of user should I use to run this stored procedure?
I already assign external_resource to the assembly in SQL server 2005.
The code:
ServicePointManager.ServerCertificateValidationCallback = new RemoteCertificateValidationCallback(myCertificateValidation);
public bool myCertificateValidation(Object sender,
X509Certificate cert,
X509Chain chain,
SslPolicyErrors Errors)
{ return true; };
thanks,
Guangming
View 9 Replies
View Related
Apr 20, 2007
I'm unable to do a RDA.Pull() when I have the sqlcesa30.dll running under HTTPS. What are the requirements to allow me to pull with the dll under HTTPS?
what are the impacts running under https:?
View 4 Replies
View Related
May 1, 2007
Hi
We have about 70 clients, each with their own databases synching to a copy of their database on a remote webserver. They synchronise using a Windows Service which we wrote using RMO.
For completeness, our setup is as follows:
subscription.CreateSyncAgentByDefault = False -- I wrote a windows service to synchronise
subscription.UseWebSynchronization = True
subscription.InternetSecurityMode = AuthenticationMethod.BasicAuthentication
subscription.SubscriberType = MergeSubscriberType.Anonymous
Sometimes, one of our clients synchronisation goes up the spout - it might take hours to synchronise - despite their internet connection being fine. And once this starts to happen, nothing will fix it. We've restarted their server, rebooted their router etc etc.
Well, the only way of fixing it is to recreate the publication, copy the backup, reinitialise and start again, which costs us a days work and inconveniences the client greatly.
What would be the likely trigger for this. How can we stop this happening again.
If it helps we could create a trace to help resolve this.....
Regards
Bruce
View 1 Replies
View Related
May 1, 2007
We currently have a few reports running on a external website. The users have to log in to the website using their Domain Username and Password. Our network admin wants to move from simply http, to a secure https protocol.
My question is: Are there any conciderations for making this move? ...Will it break my reports?
View 1 Replies
View Related
Feb 2, 2008
Hello All,
I have an application pulling data from SQL Server 2005 which is running on windows mobile 5 devices, and RDA is setup and working perfectly over http and this is in the production for long time, but we have decided to implement SSL for transportation recently and we have a certificate installed to the server and i am trying to pull data using https and getting "the request to send data to the computer running IIS has failed" message, only RDA stopped working over SSL, i can access scripts and other resources from the device using https (I made code to trust any certificate for any web requests) the link to the dll is accessible from outside, i have installed the root certicate on the server, the virtual directory has been changed to communicate via https on web synchronization wizard, then problem occurs, otherwise it will work ok, i am totally stuck at this point, is this a problem with port setup port 443 is opened, the issue is clearly a SSL issue. any help would be appreciated..what are the things to be done to implement SSL for RDA, i don't see anything more in msdn.
thank you so much!
sush
View 4 Replies
View Related
Mar 1, 2007
I have some code in a SQL CLR stored procedure that calls out to a web service at UPS to obtain tracking information for a package.
The code fails on the last line, in the call to WebRequest.GetRequestStream(), with the following exception:
"System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
--- End of inner exception stack trace ---
at System.Net.HttpWebRequest.GetRequestStream()
at UPSTracking.TrackShipment(String TrackingUri)"
Here is the relevant code:
WebProxy proxyObject = new WebProxy();
WebRequest request = WebRequest.Create("https://www.ups.com/ups.app/xml/Track");
request.Proxy = proxyObject;
request.Method = "POST";
request.ContentLength = strXMLData.Length;
request.ContentType = "application/x-www-form-urlencoded";
StreamWriter sw = new StreamWriter(request.GetRequestStream());
This same code works just fine when not running in the SQL CLR assembly. The assembly is marked as External, but I've also tried marking it as Unsafe, which did not work either.
Any suggestions on what the problem might be or how to troubleshoot this further would be greatly appreciated.
Thanks,
Steve F.
View 4 Replies
View Related
Feb 13, 2006
Hi
We are using anonymous HTTPS merge replication.
The windows password used for the client subscriber expired on the publisher.
I reset it on the publisher - but SQL still seems to think that it is not expired - I get the following message in the event log of the publisher running SQL Server 2005
Login failed for user 'XYZ'. Reason: The password of the account has expired. [CLIENT: <local machine>]
Any ideas ?
thanks
Bruce
View 1 Replies
View Related
Oct 25, 2005
Please, I need your help... I`m desperate...
I`m trying to connect to the Analysis Services (AS 2000 Enterprise Edition SP4 on Windows Server 2003 EE, respository is in Access DB) throught Analysis Manager over HTTPS(HTTP) connection. I dont want to use domain account.
I need to specify USER_ID and PASSWORD to the Analysis Manager, but in registration of new server is only IP address or HTTP adress (for http://server) - but it doesn´t work - it says Unauthorized. But I`ve tried to use Anonymous account and it doesn`t work (client wan`t able to make connection)... I would like to use Basic Authentification.... Thise account is member of OLAP_Administrators... but the problem is where should I put USER_ID and PASSWORD???
It works perfect in Excel 2003.... MSOLAP.asp work fine in IE...
Thanks very much for your advise
Ricmond
View 1 Replies
View Related
Aug 10, 2006
Hi,
I have setup reportserver with default settings (non https) and afterwards in IIS added a certificate and https support.
Know I am able to work really well and secure over the internet, but some links in report manager pointing to http://server.domain.com/reports instead of https:
For example if i call a report and then in the top there are (view, properties,...)
- View is HTTPS
- Properties is HTTPS
- History is HTTP
- Subscription is HTTP
I have read some articles - mentions I should configure https, but
- in Report Configuration you could not setup HTTPS
- in rsreportserver.config i have entered the https link version but did not change anything
- in RSWebApplication.config the Reportserverurltag is blank - so i did not change anything
Thanks for any help
HANNES
View 6 Replies
View Related
Nov 22, 2006
Hi!
I'm new using MSSql 2005 Express. How can i access my DB using http/https for reporting and DB changes/administration?
Regards,
JP
View 1 Replies
View Related
Jul 17, 2015
I have a Web application in SharePoint 2013 which is HTTPS. I have powerpivot installed and it is working fine when I try to access the PowerPivot Gallery with the port number.For e.g. URL...Everything is working fine.
But when I try to accesss the same URL...without port number I am getting the error. something went wrong Could not load
type 'Microsoft.AnalysisServices.SPAddin.ReportGallery.ReportGalleryView'.
View 4 Replies
View Related
May 19, 2008
I've got a report server that I recently inherited. I'll be the first to admit that I'm not an expert on SSRS, but I've figured out a lot in the past few weeks.
One issue I'm having (apparently it's always been there, but nobody ever bothered to fix it in the past) has to do with the report subscriptions and linked reports. We have an SSL cert inside IIS. I have SSRS configured to "require SSL connections" in the Report Server Virtual Directory tab.
So the user gets an email with a link to a report. But the link has an "http://" as opposed to "https://." When you click on the link, it throws your standard "page must be viewed on a secure channel." When I manually append an S to the url, it works great.
There has to be a way to automagically add the S to the url, but I can't seem to figure out how. Anyone ever run into this before? Google has not been good to me this morning either.
View 1 Replies
View Related
Aug 8, 2006
Hi
We are using HTTPS merge replication
Our setup is as follows:
subscription.CreateSyncAgentByDefault = False -- I wrote a windows service to synchronise
subscription.UseWebSynchronization = True
subscription.InternetSecurityMode = AuthenticationMethod.BasicAuthentication
subscription.SubscriberType = MergeSubscriberType.Anonymous
Some of our subscribers have low-quality internet connections - how do I get the agent at the publisher/distributer use a slower profile - I've read How to: Work with Replication Agent Profiles (Replication Transact-SQL Programming)
but can't see where you specifiy an alternate agent profile
On the distributer / publisher (same machine) I go to replication monitor -> Warnings and Agents - I can only set the profile for the snapshot agent....
thanks
Bruce
View 4 Replies
View Related
May 19, 2015
How to enable http for SSRS service in my current sharepoint 2013 environment with https.
this is needed as we have a limitation in SSAS: We cannot specify HTTPS in the Analysis Services Report Action.
View 3 Replies
View Related
May 14, 2015
How to check if web merge sync is working between a subscriber and publisher thru HTTPS ? SQL port 1433 at subscriber is blocked so no direct connection to subscriber.
View 2 Replies
View Related
Sep 21, 2007
Is that possible to use report viewer without any other application as like we design normal rdl reports in Report designer.
View 2 Replies
View Related
Feb 17, 2006
Hi all,
I'm creating a custom interface for reporting services but I am having a few problems. This is my environment:
Using the ReportViewer component in remote mode to show my reports of the report server. There are 2 user levels of which any user can be apart of, Admin & user. In every report, there is a parameter called MERCHANTID, when the user who logs in (via custom login interface) is of group admin, then the merchantid parameter gets prompted before the report is run, if the group of the user is "user" then the merchantid parameter is hidden, and is passed programatically to the report. The report path also
My Questions:
1. When my reportviewer component loads up the report and prompts for a parameter, when you select a parameter value or type it in, it just posts back with no results, just the parameter prompt again with no data... How can this be corrected?
2. How do I pass report parameters programatically... so that when my user id of group "user" then "merchantid" gets passed automatically, but if there is any more parameters, then that gets prompted...
Thanks for your help.
View 11 Replies
View Related
Aug 27, 2007
hi to one and all ,
i've installed the SSRS 2000 ENT Edition i trying to add reportviewer dll in my webapplication but i haven't find that dll so could any help in this issue ?
Thanks in Advance
by,
Veera Vinod.
View 6 Replies
View Related
Feb 21, 2006
Hello,
I try to embed my Reports of Reporting Services to ASP .NET Application. I use ReportViewer component of Visual Studio 2005.
When I try to set Height property to 100% there is no report content shown. I tried to set SizeToReportContent property but there wasn't success.
At the same time when I set Height to any particular value e.g. 400px, everything is OK. But of cousre I can't know particular height for every reports.
Did you have any such problems? Can you help me?
Thank you,
View 20 Replies
View Related
Jan 8, 2007
Does anybody know how to get Reportviewer 2005 working on .Net 2003 web application?
View 3 Replies
View Related
