HI, does anyone now if it's possible to create a time line like the one that appears in some of the default reports in management studio 2008, the Performance Data Collectors ones. I only manage to do something similar with a chart, but I'd like to implement something more like the time line in SSMS. This is the time line I'm referr...
I'm running MOSS 2007 with SSRS 2008, and I'm encountering an issue with an SSAS-backed report that has four parameters, all of which are attributes on the same dimension. When I run the report from MOSS, it works just fine. When I change the parameters from the default values to specific values, the report still runs fine. When I try...
I need to be able to join 2 datasets together. I can't do it in a query because each dataset comes from very difference datasources (one is SQL Server 05 and the other is IBM iSeries). And I can't do it via a master/subreport set up for various reasons. If I can't join 2 datasets together I may resort to building and referencing a custo...
I am looking for a management tools for SSRS 2008 other than Management Studio and SSRS Portal interface. I would like to be able to clone folders or deploy reports to multiple folders etc. Currently I am doing these task with rs.exe scripts but we need a better solution. Thanks, Fahad ...
Okay, I have a report with multiple charts in it. I have tried a few different ways to get these charts to format the legend the same way, but i have failed. My goal is to make the legends have the same color scheme and ordering across the different charts. Example, my chart show the count of projects in each of the following fundin...
I'm writting a custom assembly to be referenced in a report. I'd like to be able to access the Report object from that assembly, so that I could then access the report parameters and other stuff that I can access in custom RDL code by using Report.stuff. I obviously need to reference some reporting services assembly to do this, yet I ca...
I have an instance of SQL Server 2008 and SSRS 2008 running on a desktop PC for to be used for development. This PC is registered under my user id and I can remote desktop into it and connect to SSRS just fine from my laptop (also registered under my user id). Also, I can access the website from my laptop when I am NOT logged into the PC...
I'm dynamically generating RDL files for SSRS 2008, assembling my reports from "building blocks" which I defined as reports on Report Server, and which I use as subreports on my generated report. On my Report Server, I have a single, shared data source which does work as long as I run stuff directly on the report server. What I'm tryin...
In a report model I have some entities which have attributes which are integers (set to integer datatype) but should not be summed or aggregated in any way. For examples ID's. But when I create reports with the wizard, sometimes the report builder will try to sum the values even though it doesn't make sense to sum ID's. For example let's...
I can't believe this - I just starting developing an SSRS report, using a SQL 2008 Report Server project in VS 2008. When I try to render the report in the VS 2008 ReportViewer control, I get this error The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sql...
I have a stored procedure that returns hierarchical data in a single long row, for example: ContractID | ContractName | AssetID | AssetName | UnitID -----------+--------------+---------+-----------+------- 2 | Test | 7 | My asset | 24 5 | Another one | 51 | Vehicle | 89 I need to create an SSR...
Given a SQL Server 2008 Reporting Services installation, what's the "cheapest" way to check whether a given report (given by its report name + report path, e.g. /MyReports/SomeOddballReport) exists (or not) ? I see lots of potential candidates on the ReportServer web service - which one is the quickest and the one using the least amount...
The company that I work for will soon (2Q) no longer be supporting SRS. They want everyone to use Business Objects. I have over 100 SRS reports that I currently use. I need to find out if there is a way to run them locally on our webserver. Some of these reports need parameters to be selected and others get them passed in. I would pref...
I have finally gotten the ReportViewer to work in Local mode. Now I would like a report to render as a PDF or Excel spreadsheet automatically. ...
What is the recommended best practice for reports deployment in SSRS 2008. We have a solution where the reports are accessed from the application using webservices exposed from SSRS and also we allow end users to schedule reports (schedules created using webservices in SSRS). Whenever we change reports, we have to redeploy the reports wh...
I have a DataSet with 4 fields. For example: FieldA, FieldB, FieldC, FieldD FieldA is the data field, and FieldB is the category field. Normally the Legend will display the category field. By applying custom format in the Series Properties --> Legend --> Custom legend text, I could format it like this: FieldB - FieldC - FieldD Because...
I need to build a report that shows data in four grouped levels. The tricky part is: the actual fields to be displayed on those four levels are to be passed into the report as parameters. My main issue right now is this: how can I tell a textbox on the report to not display the value of the parameter @X, but the value of the field by th...
I have a report in SQL Server Reporting Services which should show a text box with a static text for "normal" users a text box with a hyperlink to open up a new details windows for "super" users The user level is determined by a parameter being passed into the report. How can I achieve this? I tried to create a textbox with a text ...
We are creating large reports in SSRS 2008 (with Dundas) that when exported to PDF, are coming out with a file size of about 4.5MB. The same reports in 2005 came out at just under 1MB. Is there something configurable that can be changed? We've experimented with setting the global DPI configuration down to 96 in SSRS, but this doesn't ...
Before I get too far in SSRS, is it possible to calculate an mean, median, mode standard deviation, etc. of a column of data? In general, is it possible to do these sorts of math calculations? ...