Hi folks, is it possible to have a macro on an SSRS Report that is exported in Excel format ? We need to rename the sheet based on content of the report a user is viewing. For ex: 'SalesReport' shows data for California - so sheet name might be 'California sales'; 'SalesReport' shows data for New York - so sheet name might be 'New York...
I know there is an Issue using SQL Server 2000 Reporting Services and Visual Studio 2005, but does this error still exsist with Visual Studio 2008 and 2010? If so, is there any work-aground to get this working? ...
I have a SSRS report which is the snapshot or another report. It runs every day @ 6 am. I want to add a header at the top of the report(snapshot), which indicates when the snapshot was taken so that the user knows when the snapshot was taken. Does anyone know how can i do that? ...
I have a brain-teaser for all you SQL Server 2008 Reporting gurus out there :-) I have a report which displays a bunch of data, including the UserID and OrgUnitID for users. It's a server report which I'm rendering on the server, from within an ASP.NET application. My requirement is that a "normal" user can only see his own data rows...
Is there a way to display/export english SSRS report in some other languages? ...
I am using some webrefernces for reporting services. The first time they load they are really really slow. Is there any way to reference the files locally? ...
I have installed the Visual Studio 2008 sp1 Report Viewer Redistributable on the web server. I had to download it from microsoft, because the location I've seen other people post does not exist on my install of visual studio. I downloaded the one that is located here: http://www.microsoft.com/downloads/details.aspx?familyid=BB196D5D-76...
I have an SSRS report that calls out to a stored procedure. If I run the stored procedure directly from a query window, it will return in under 2 seconds. However, the same query run from an 2005 SSRS report takes up to 5 minutes to complete. This is not just happening on the first run, it happens every time. Additionally, I don't se...
I have a report .rdlc the report contains 4 lists all contained within each other (so there are 4 levels): ----------------------------Page 1--------------------------------------- List1: Fields! items1 List 2: Fields! items2 List 3: Fields! items3 List 4: Fields! items4 Con...
We have a analysis services olap cube (SSAS 2008) deployed at a test server (MS Serve 2008) in our domain, you can browse the olap cube via ssms without problem. No problems with olap cube itself so far. The user account is admin on the analysis services server. We also have reporting services (SSRS 2008) installed at the same test serv...
I have a client report (rdlc) and want to repeat some textboxes in every pages. I can't put these textboxes in header. I bind data to these textboxes, so I can't put these at header. Is there any solution for this? ...
I have a dilemma. Here is my set-up: ASP.NET/NET 3.5 web application build using standards(DB layers, BL layers, etc...) I need to generate some reports. Standard way of doing that is to have reporting service query database directly OR I can have reporting services query web services(which I will create). I like web services approach ...
Hello: We are considering building a custom data processing extension for Microsoft Reporting Services in order to allow us to report directly off of our data objects. My question: Suppose I have an object that represents the row, but it has a member that is a complex object: public class TheRowObject { // a "normal" field publi...
Hello, Whether in SSRS 2005 or 2008, someone said that SSRS Report Model will cache the data defined within the report model and you will be required to update the report model regularly to get the new data into the report model views... is that correct? To me, it seems the report mdoel stores the definition/metdata only... could some...
Does the asp.net ReportViewer control work with LinqDataSource? If so are there any examples out there? Why don't Linq to Sql generated entity classes show up in the Website Data Sources pane, when editing a report? ...
When I click File -> Open on Report Builder, I can see a list of folders under Report Server Home root folder. But I don't want end-user to see any of the folders under root unless I grant them access. I tried hiding and removing permission on the folders but they are still visible in the root folder. ...
I have a dataset that is showing the correct data, but putting it into a stacked bar chart and using the RunningValue function to try and plot it cumulatively is giving numbers that start way higher than they should. My data is aggregated at the database, giving a dataset of: Date of data Count Sum of Value Filter Item 1 Time Since Da...
Guys, can anyone point me to a definitive Microsoft map for where Reporting Services is going regarding using WCF Data Services (ADO.NET Data Services, Astoria) as a data source? There's bits of fragmented info out there, some about creating custom data providers, some about some sort of extension enable connection to the Azure storage l...
I am having difficulty getting images to display when I render a report. The text all renders fine, but the images appears as broken. How do I fix this? My code: ReportExecutionServiceSoapClient rs = new ReportExecutionServiceSoapClient(); rs.ClientCredentials.Windows.AllowedImpersonationLevel = System.Security.Pr...
I'm researching using Microsoft Reporting Services as a replacement for Crystal Reports. In production, most of the reports would be built by technical end-users, or by professional report designers (people who are technical, but not developers) My question: I've created a report, and I have purposely put a syntax error in an expressio...