I try to develop a data processing extension for SSRS 2008 in order to access database through an entity framework. But when I copy and register the extension in BI Development Studio, it gives me an error message while loading the extension". I built it with targeting framework 4.0 by using Visual Studio 2010 because my data model class...
Hi is it possible to change the direction of column header values ? By default header valules displayed in horizontal direction only. But I want to show the values in vertical direction. Is it possible? I tried from the last 3 days. But no where I got any good results. Thanks in advance ...
I've managed to obtain the report definition schema for SQL Server 2005, but cannot find the xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" schema anywhere. Is it part of the 2005 install buried somewhere? The reason I ask is because I've recently started writing RDL files for SQL Reporting Services. I'd lik...
I'm trying to create a stepped line chart in reporting services 2008. By default the transitions between data points move horizontal then vertical. I'd like to be able to tell the chart to move horizontal then vertical when the series value goes up and move vertical then horizontal when the series value goes down. Possible? ...
Have you ever had a matrix in a report become too big to display it all? I think i am experiencing that now. My report has about 5 drop down filters. IF you select all the sites it can be approximately 230 items that will be down the left side of the matrix. If I select more than 32 it acts oddly, it doesn’t show them all and what it...
I am trying to understand when we should use one over the other. From my understanding the local mode means you just bind data to a ReportViewer server control and it renders it as a report. The server version seem to be the same except it also comes with a Report Manager site and using a SQL DB. I am thinking that using the server ...
I have one report that does not export to excel friendly from SSRS 2005. I know I can use <Render> <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"> <Configuration> <DeviceInfo> <SimplePageHeaders>True</S...
I have built an RDL report and after rendering any tab characters contained within my returned data do not appear in the generated report. Is it possible to display tab characters? (Users want to have the basic formatting of their 'comments' field to appear.) Tabs added to the rdl itself are maintained, but those in the data seemed to be...
Hi there I just migrated a project from .NET 3.5 to 4.0, accordingly the reports now use SSRS included in .net 4.0/VS2010. Before conditionally setting a rectangles visibility did the trick for me. (inside the rectangle I put a rectangle with a pagebreak) But this stopped working now.. any help appreciated ...
Hello....I have a report with 12 Tablixes on it. The user can pick and choose which one of these Tables and their associated data shows when the Report is generated. However, when chosing a subset of the 12 tables, the report shows blank space where I hide the non-selected tables. Is there any way to make the report resize/fit the siz...
Hello....I have a report in SSRS that needs to disable the "Export" functionality based on who the User is. Is this do-able? And, is it possible to disable all Export options except the PDF option Thanks Mike ...
Hello I was here trying to figure out why my Reports manager is empty, there's no tabs at all. I installed SQL Server 2008 complete, but didn't not configure Reporting Services. When installing SQL Server 2008, this Windows 7 version didn't have yet IIS installed, I installed it later. I don't see where is this localhost/Reports phy...
Hello....I have a web site in 3 environments (DEV/TEST/PROD). The Web Site uses SSRS which also has 3 different environments(DEV/TEST/PROD). Currently, I am deploying the reports using the Manual Deployment mechanism provided in the SSRS Solution (i.e., right click a report and click "Deploy"). I have to manually change the Deployment...
Can I create a line chart that looks like the one(which I have provided as a link. Please click the link to see the chart image) using SSRS 2008? If so, please help me how to do that? Please see the below link for sample http://i48.tinypic.com/20ib1v8.png ...
I have an application that retrieves a report from SSRS 2008 and prints it automatically. This works except it always prints the report in Letter/Portrait. This particular report is Letter/Landscape. I have tracked the problem down to when calling the Report.GetDefaultPageSettings() function for this report, it returns PaperSize.Heigh...
Hello.... I have an SSRS report that contains several subreports. The user has the ability to select/deselect which subreports they want to produce using several Boolean parameters. If a subreport is deselected then it is not rendered by setting the Visibility property. However, the DataSet associated with the de-selected subreport s...
The scenario: Big system (~200 tables). 60,000 users. Complex reports that will require me to do multiple queries for each report and even those will be complex queries with inner queries all over the place + some processing in PHP. The approach: I have seen an approach, which I am not sure about: Having one centralized, de-normali...
I'm having a problem with my SSRS 2008 configuration at the moment. This is how we are currently set up. 1 server hosting SQL Server and SSRS, no integration with sharepoint etc. Users access the SSRS web application, and then from there they access the "Report Builder 1.0" too, which they can use to create and run reports based off a...
Is it possible to use eps or svg images with SQL Server Reporting Services ? ...
I'm using the ReportViewer control in a WinForms app. How do I change the "NULL" checkbox text to anything else? (just right of 'Begin Date' in the below picture) ...