reporting-services

ssrs 2008 missing data and preview panes

hi im used to working with ssrs 2005. it has 3 panes data,layout,preview now in 2008 I only have the layout. what is wrong? should i install something? ...

ssrs 2005 charts display no data on runtime

hi i'm creating a report on local report it contains 3 charts (pie,line and bar) and one table the preview works ok but when i take the report and run it from my aspx (VS2008) aplication i get no data on any of the charts, but the table works fine. for debugging i added 3 more tables to the report ,just to prove that the data reaaches t...

Is there a workaround for placing placeholders in a textbox in SSRS2005

Does anyone know of a workaround for placing placeholders in a textbox in SSRS2005. I am stuck with SSRS2005 but need to insert database fields into specific places of a textbox containing other static text. ...

Displaying single-instance business object data on SSRS

I have a SQL Server Reporting Services local (i.e. RDLC) report displayed in a ReportViewer, with two subreports. I am using business objects to populate the datasets. What is the best way to populate single-instance data on my report, e.g. a dynamic title, or a text box that lists a calculated value, not based on the report data? I am ...

Report loses color when exporting to Excel

Hi, I have a local report in a WinForms application that is giving me some trouble. On this report, I have a table and I am trying to change the BackgroundColor of the Detail row. When I change it to "Red" and view the report, the row is Red as hoped for. When I export the report to Excel and PDF, the row is Red, too. So far, so g...

SSRS vs Crystal Reports for Standalone Windows Application

Many developers prefer SSRS over Crystal Reports. Is SSRS also better for a standalone Windows app that connects to a local SQL Server Express Edition (deployed as a downloadable app distributed over the Web)? ...

Reporting Services - setting a field value dynamically based on parameter

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...

Report expression help

I am using the following expression in a local report for a WinForms application, but I receive "#Error" when the field value is null: =IIf(Fields!MyField.Value = "", "NULL", Left(Fields!MyField.Value, Len(Fields!MyField.Value) - 2)) I am doing this to strip off a trailing comma and space of the value. The IIf() works, the Left() wor...

Textbox in Reporting Services - show text or hyperlink

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 ...

SQL Server Reporting Services and UTC time

I've been storing all dates in the database as UTC time for several years now, but recently, it's becoming more of a pain to deal with date range queries in reporting services where the date range is specified in local time. Specifically, let's take this example data set: EmailAddress DateCreated [email protected]...

SSIS and SSRS Books

Can someone please recommend good books on SSIS and SSRS? ...

Default path for MSDN Reports Services /ReportServer and /Reports virtual directories

I'm trying to use MSDN Reports Services 2005, but I'm realising that I broke the installation, so I'm trying to fix it without having to rebuild it entirely. (Though I'm becoming more tempted the longer this goes on.) Unfortunately, all the documentation assumes you haven't done something stupid. ;) Amongst the things I've broken in t...

Invisible Attribute Hierarchy under Dimension

Below is the snippet of an mdx query used in a report. with member [Measures].[Leased Coin In] ([Machine Dimension].[Leased Flag].&1 , [Measures].[Coin In]) Now, my question is: In the cube under Machine Dimension, there is no attribute hierarchy name called Leased Flag. I looked at in the xmla script, there is no such name. But, the ...

Problem in MS CRM 4.0 with Expand/Collapse on a SSRS 2008 report

Hello, I'm working on a SSRS report wich is deployed in a IFRAME in MS CRM 4.0. The deployement works, the report is available in the IFRAME. I have two linked problems (in my opinion): The function Expand/Collapse works in SSRS, but not in my CRM's IFRAME. The report contains parameters. Changing their values doesn't work in MS CRM,...

SSRS Excel output sorting image problem

Hello, When exporting my simple data report to Excel (Using ReportViewer in localmode) I can sort the table data fine but I have images in all of the rows and they do not sort with the data. My basic setup is a C# class that provides a List<> of a data type with a few columns and a byte[] image in it as an object data source. I just d...

Sql Server Reporting Services (SSRS) or Microsoft .net 3.5 Chart Controls

Under what circumstances would you use SSRS rather than Chart Controls? I'm trying to determine if it makes sense to use reporting services to produce charts for a .net project, but I'm not sure about the learning curve, potential benefits, potential drawbacks. The only benefit I can immediately see is the ability to setup reports to b...

SSRS form parameter passing: input type submit vs. image

I need to use an image to submit a form that contains the SSRS parameters that get passed into the report. Is there any way to get SSRS to not take "input type=image..." as a parameter along with all the "input type=hidden...' ones it greedly sucks in? Instead of this: input type="submit" value="Submit" I'm trying: input type="image...

Is it possible to access the "Reporting Services\ReportManager\Web.config" file directly from a report?

I want to read an appSettings value from the c:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportManager\Web.config file and display it in a report. I added a reference to System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a and set field Value property to System.Web.Configuration.WebConfigura...

SQL Azure Reporting

For everyone playing with SQL Azure, what are you using for reporting? Do the Visual Studio reports connect seamlessly? What about reporting services? ...

One resultset across different tablix

Hello, My first post here with 2 questions. Question 1 I am new to SSRS environment and have been looking to get architectural information to explain me how rdl is processed and rendered. For e.g. all datasets executed and resultsets cached, then all tables rendered... etc. So if someone has any link that would give me an overview, i...