I'm designing a layout for a report in VS2008 using SSRS/RDLC format. And every time I setup a part of that report i test it on my workstation to see if everything is ok. But, today, i finished the first page of that report and uploaded it to my hosting server (were it's going to be used), and when i press the button to convert the report to .pdf and download it the layout is completely ruined :-/ When i do the same thing in my workstation every thing 'comes out' beautifully, but up on the server it doesn't .
I 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.
I've never done anything like this before, I guess it's better to ask before starting at all to just don't get the whole process wrong.We have a report that has to be called from an ASP.NET application, it could be a simple button. Through the code-behind, I gotta pass in a paramater, render the report, and don't save it anywhere, just open it to the user, as a .pdf file so he could save or print it.
I'm pretty familiar with ASP.NET, and am currently writing an MVC app in ASP.NET.I'm at the point where I need to integrate reports into my application.The option I chose to go with (and I'm flexible on this) is SSRS.I have zero experience in SSRS and it seems that there are a LOT of steps involved in getting that set up, from installing the Report Server, configuring the Report Server, creating a report project in Business Intelligence Development Studio, and publishing the report to the Report Server. 1.) Set up and install SSRS properly. I'm using SQL Server 2008. (Not R2).2.) Creating and publishing a report to the Report Server.3.) Being able to access this report from my ASP.NET web application.
I am doing a SSRS report to generate some kind of print outs.
I need to have different footers inside the whole print out.
e.g. After first several pages I need to use page number as page footer( this can be easily done). but after that i need have footers as Annex A -1, Annex A-2, or Annex B -1 , Annex C - 1, when the page is Annex A, Annex B...etc.
I'm a software manager that want to select a Reporting engine and develop international application , i want to know Dose SSRS support multi-languages environments(Special in Report Builder for end users) or not ?
I am new to SSRS. I have created a report and was able to deploy it on the server. I am calling the report from ASP.NET application. How can I change the CSS of the report? I want to change the styles for individual data cells of the table deing displayed also. How is it possible?
I need a reliable method to switch off users' access to SSRS dynamically. If you care about the reason, users are not allowed to access SSRS from home, but they are allowed access from within the factory walls.
I can generate a token or event when they arrive at work or leave, no problem, such is the sophistication of our security system.
So I can create a little .net app that pokes SSRS in some way and tells SSRS to allow that username to access reports. When the users leaves the premises, the .net app will prod SSRS to deny that username access.
I considered dynamically adding and removing usernames from the authentication section of web.config in the SSRS root dir, as in <deny=usernamelist />. But given the frequency of changes (dozens per hour at peak times), that seems too intrusive, as it probably causes the restart of the app.
I tried adding usernames to the ACL on the SSRS physical directory (Microsoft SQL ServerMSSQL.2Reporting ServicesReportServer) as deny reader, and for a few brief minutes I thought I had arrived at a solution, but for some reason SSRS decided to serve pages to denied users seemingly at random. Must be cached somewhere, although I can't for the life of me figure out why that would be happening seemingly at random.
I rather like the ACL idea from the perspective of ease of control, and if there's a simple thing i have overlooked in the way SSRS interacts with IIS and NTFS permissions, I hope someone can point it out so I can understand why the ACL seems to be mostly ignored.
I have SSRS report and have customized the toolbar with textbox. User can enter the report page number and can press enter so that report will generate with report number. I have made autopostback=true to the textbox and below is my code in textbox_textchanged event
Suppose if I enter 2 in textbox and then press enter,it is not firing and if i press enter second time it is working. From page 2 if i enter 1 in textbox and press enter also it is not working.
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.
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 am using sqlserver 2008R2 for reporting services. . My Database is located in remote computer. I am able to get the data and make a report and able to view the report using Business Intelligent Development Studio(BIDS). . After deploying the report, wen i try to view it from the browser it is giving an error message
An error has occurred during report processing.
Cannot create a connection to data source 'DataSource1'.
The feature: "The edition of Reporting Services that you are using requires that you use local SQL Server relational databases for report data sources and the report server database." is not supported in this edition of Reporting Services.
is this some error or do i need to change the version of SSRS?
if i need to change the version. which version supports my scenario.
using Database in the remote server, Visual Web Developer2008
I'm about to begin a new asp.net application using .net 4.0. Only concern I have is since the project calls for reporting, I cannot use SSRS with SQL Server 2008 b/c the tempate for Bus Intelligence Projects is missing from 4.0. I've been told that the next release of SQL Server 2011 (some time this year), will resolve this problem. Meanwhile, I'm wondering if the following approach would work:
1) Create the application in VS2010 using the SQL Server 2008 db.
2) Create the SSRS Bus Intelligence project using VS2008 and create a seperate website pointing to the same SQL Server 2008 Db?
Kind of a hack, but I guess the only problem with this is, the Bus Intelligence project will not be able to reference and leverage and DLL or code from the application.
I need to convert an old html report to SSRS . The current report uses two datasets- one is a parent table that is iterated through to pull a data key; the report then pulls an array based upon the key and displays the associated records. Is there any simple way to do this in SSRS?