Hi All, We are having an SSRS server configured over a live IP. Before I can start building reports, I want to know What are best practice for developing reports that are easy to deploy How can I maintain SVN copies of my reports I was suggested to create shared data sources, what are they and what are benifits? What are security rela...
I have some SSRS reports that I work with in Report Builder 3. On the SQL server 2008 r2,just upgraded to latest Report Viewer 2010 and we deploy to an asp.net interface via first to Report Manager. I have one report that displays pie charts of the data and it works correctly in Report manager, and as well in Report Builder, but on the ...
Hi All, I got a problem while creating a report in SSRS. The ERROR shows: Error 1 [rsInvalidReportParameterDependency] The report parameter ‘COUNTRY’ has a DefaultValue or a ValidValue that depends on the report parameter “COUNTRY”. Forward dependencies are not valid. C:\Users\wiksat\Desktop\New Folder\New folder\Visual Studio 2...
I have a assignment question. How to integrate Sql Server Reporting Service (SSRS) with visual studio? i know that when you have installed BI tools it's possible to create SSRS reports as a Visual Studio Project. I'm not sure about the answer to the above question. Can some one help me regarding this..... ...
I need to deliever an SSRS report via subscription to a SharePoint document library. Setting it up in integrated mode is not an option. I have tried to use WebDAV interface to SharePoint, but for some unknown reason, I'm getting an access denied. I attempted to run the SSRS Service as a network user which has access to the SharePoint ...
I have a very complex report. I found out, that several rendered report instances of the same report (as PDF) showed an empty last page (only the header and footer was visible). Problem is, there should be data on the last page which is not shown (i.e. the page is empty - although the data is available). I was able to make the data vis...
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? Thanks in advance. ...
I have a simple .NET 4.0 web forms app that references the Microsoft.ReportViewer namespace: <%@ Register assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" namespace="Microsoft.Reporting.WebForms" tagprefix="rsweb" %> with a simple ReportViewer control on a page: <rsweb:Re...
I have a report that runs a Stored Procedure in Oracle. This procedure fills several tables with data in Oracle. I then want to query those tables and load several Tablix(s) in my SSRS report. I need the Stored Proc to run first. How can I ensure the Stored Proc runs before the DataSet queries that I use to fill the Tablix(s)? ...
Is it possible to have add a row to an SSRS 2008 Matrix that spans all of the matrix's columns? This crude diagram shows roughly what I'm looking for: The basic idea is that each line item is a person, and each column is a field in a form for that person. The fields themselves are dynamic (and implemented as column groups on the matr...
We can implement drilldown report using grouping feature of SSRS 2008, where we just give SSRS filtered data and group expression and rest is doen by SSRS, great. Our problem is that we have very larg data even after giving filter, so it takes lot of time for SSRS to get data and group it. What can be ideal situation is that we have oppr...
I'm running SQL Server Reporting Services 2008, with Custom Authentication, and without IIS. Everything works (Report Builder, Report Server, Report Manager, etc), with one exception. I can upload arbitrary files (via Report Manager), but I can never download them again via the Report Manager (http://server/Reports). I am able to downloa...