I have a custom interface where my users select multiple reports and export them all at once. I need to programatically export these reports and preferably offer all the same format options. I understand this can be done through the SSRS API.
View 1 RepliesI am programmatically exporting multiple reports to a pdf via the ssrs web services using C#.Net. It exports a single report just fine, I was wondering if there was a way to export multiple reports? I tried block copying the byte arrays from all the reports into a single byte array, but it only displays the last report.
View 1 Repliesdifferences between ssrs reports and crystal reports?
View 2 RepliesI'm pretty sure SSRS doesn't do this on its own, find a third party product that could accomplish what I need from SSRS.
Specifically, I need SSRS to preserve settings when I export a report to excel for such things as excel page headers and footers, print range, column width, etc.
How can I accomplish this with SSRS, or what third party API will accomplish this?
I am using SSRS 2005.
I have a problem when I am exporting my report to Excel.
When exported to excel, I could see the table header on only the first page but not on all the pages. I have also checked the option "Repeat Header rows on New Page", but that didnt work.
I've done a asp.net application to generate reports over a particular data. Initially i created local reports (.rdlc) to generate reports. I created separate .xsd for each rdlc and designed the reports. I build the dataset programmatically and bind it to the rdlc. I used the following code for binding the datasource to the reports -
rptMyReport.LocalReport.ReportPath = Server.MapPath(srdlcName);
rptMyReport.LocalReport.DataSources.Add(rds);
Now i have converted all the rdlc to rdl following this msdn article and i've published the reports to the report server.
rptMyReport.ServerReport.ReportServerUrl = new System.Uri("http://ReportServer/ReportServer");
rptMyReport.ServerReport.ReportPath = "/ReportFolder/ReportName";
Now how can i set the datasource to the reports programmatically?
I have SSRS (discountasp.net) and I currently display reports on my web page using Reportviewer and use .net code to authenticate them (username/password). Recently I have bought VPS (Windows Server 2008 Web Edition + .net 4.0) and would like to use SSRS the same way as above. I have never done this before so need some guidance on that just to ensure the server is still "safe". Below are some questions that I think are related but feel free to add other comments that I didn't think about.
1) Set up new user? What permissions are required?
2) Configure SSRS to for external connections?
3) Firewall?
I'm designing some reports to summarize recently compiled research findings. These reports are going to be posted on an ASP.NET page (via the report control) on the web site. I do not want to authenticate users, as the findings are meant to be public and requiring users to register and authenticate would add a barrier and is likely to decrease traffic.I've seen similar posts where reports are meant to be viewed by everyone on an intranet and permissions could be set using a designated workgroup. I need alternative solutions to the problem of making a report viewable by everyone who visits a site. I'm also currently unfamiliar with Kerberos (and I know that will probably pop up as a potential solution), so if there's a convenient way outside of that it would be great.
View 3 RepliesI am using VWD 2008 with VB.Net code-behind. I have multiple parameterized RDLC reports that use tableadapters in a .xsd dataset that I use a reportviewer to view / export the PDF reports.
Lately, we have noticed that the reportviewer is causing many errors on our webserver and sometimes causing the webserver to crash. It has been recommended to me to move the RDLC reports to SSRS, which we also have up and running on another server.
My question is how do I do this? Do I have to convert them to RDL files? What about the fields on the .aspx pages that supply the parameters? Also, what do I do with the tableadapters?
We want to not use the reportviewer but still have the capability to retrieve the RDLC reports in PDF format.
Starting to look into an web app thet uses the ReportViewer to display SSRS reports. This is for SSRS 2008. What would be the best way to go about the follwoing: The reports are sales reports so only ceratin people will get to see certain reports.
1: If a user opens a report which they can see and that report has a subreport which they can't, will the subreport still be viewable?
2: If the webapp will be used by many different people internally and eventually by outside people, what is the best security startegy to use, just plain ServerReportCredentials passing, or something else?
sometimes an export in pdf, or word format, is not the same of the report i mean about a lines, a dimensions of controls and other
View 1 Replies1> "change the color of the background of report to the RGB (240, 240, 240)" and
2>change the background of the legend to "white" i am able to do the second requirement
We have to integrate an SSRS report in sharepoint.When we will click on the report it should open in a custom aspx page and not under Report viewer.
View 1 RepliesI have been developing reports using BIDS 2005 and deploying them to a report server on my development machine.
These reports can be called succesfully from both the report manager and my asp.net website.Everything has been working fine.
Some time back some early versions of the reports were deployed to a test server in order that they could be tested away from the development machine. The reports processed successfully.Today I have uploaded a number of completed reports (using Report Manager) to the test server and am getting an error message for each one when I try to run it direct from Report Manager.
The message is: "An error has occurred during report processing Common Language Rutime detected an invalid program"
I've been trying to resolve this for a few hours now and am getting nowhere. Google has thrown up some finds on the error message but these seem to refer to people having issues with the compilation of large methods or forms with a very high number of controls.I can't see this being appropriate because most of the reports are relatively simple and the most complex probably has only 100 different controls.
my boss wants show a page exporting , but in the combobox he wants remove the ".doc" format
View 2 RepliesI have an ASP.NET site at work that uses a SQL Server 2k database.
Some pages on the site have buttons to export data via Crystal Reports and the user has the option to save or open. I also export to MS Excel using Response with content type.
Everything works fine until the workload increases and many documents are exported. What happens is that the site stops exporting when the buttons are pressed. It simply does nothing.
you can still use other features of the site but no exporting.
the only solution i've found so far is to restart IIS (Hosted on a Windows 2k3 server).
this only lasts about an hour or less and i have to restart again.
I have web application using asp.net and from that i generate crystal report after generation of report when i'll export it to pdf from crystalreportviewer inbuild function. So report is saved by name crystalreportviewer.pdf but I want to change name of report at the time of generation.
View 1 RepliesWe currently have two web servers (Windows Server 2008 Standard, IIS7) setup to host an ASP.Net website and are using the basic features of our hardware firewall to provide network load balancing (NLB) between the two servers. This means we have had to change the ASP.Net session state mode to SQL Server in order to make the data stored in session accessible no matter which server responds to the request. The main issue now is that crystal reports (basic edition packaged with VS2008) do not seem to support serialization which is needed in order to store/transfer the report to session state on SQL Server.
From what I have read so far in order to get crystal reports working in a web farm environment it seems the only option is to upgrade to Crystal Reports Server and load the reports from a third server. Another option may be to use SQL Server Reporting Services (SSRS) as we already have this so no extra cost involved, however I'm not sure if SSRS would resolve the issue with storing reports in session?
How to create ssrs with parameter in asp.net with c# using sql ....
View 1 RepliesI am using crystal report and I am exporting data to PDF. In crystal report for a particular field I have HTML text as input. So I have set Text Interpretation as 'HTML Text' for that field in crystal report. But still in PDF few things are not working. That is, it is not showing bold, and bullets etc. Underline and color and font are working fine. HTML text is :
[Code]....
i have a asp.net project i want the user be able to select the fields from checkboxes near every filed in grid and also filter it by selecting the operator form dropdownlist and filter string from textbox in grid so i create a empty datatable in dataset and it have 7 columns i bind my crystal report to it and i use the following code for showing fields it works and i see the data but when i want to export or print it only the headers remain data disappeare here is my code:
protected void Button1_Click(object sender, EventArgs e)
{
MultiView1.ActiveViewIndex = 1;
//ReportDocument objRpt = new ReportDocument();
string reportPath = Server.MapPath("CrystalReport.rpt");
[Code]....
i Have upgraded my Reports from Report server VS 2005 to VS 2008 .
My reports works fine in local, development & test server.
After Ugrading to 2008 it works fine in local server & devlopement serverr.
When i deployed to Test server i am trying to access my reports i am getting below errors,
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors ..
i checked the Datasource conncetion properties..its pointing to correct Test database only..
My reports are windows integrated...
Now it works in srs 2005 developement & test server. For same properties it works in dev server, it doesn't works in srs 2008 test server.
I am Exporting Crystal Report to pdf in hindi font it displaying as boxes i have installed adobe reader 11.0 with asian extended language pack in my local system. (English is working fine problem is with only with hindi font)
View 1 RepliesI am getting "ASP.NET Session Expired" error when viewing SQL Server 2008 reports using the Microsoft ReportViewer web control. I found this article http://balanagaraj.wordpress.com/2009/09/25/session-has-expired-in-asp-net/ which suggests to use one worker process in IIS application pool, but that may affect performance, is there any other solution for this? I tried setting "AsyncRendering" to false already and that didn't work.
View 2 RepliesI am using asp.net 2.0 with c#.
" myReportDocument.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Response, false, rptName);"
As soon as compiler execute this statement i get error
" [System.Threading.ThreadAbortException] = {Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack.} "
What will be the possible reasons for the error.
Although it throws execption but it will allow to convert report when i deployed my site using http but when i deployed my site using https then it will shows error .