reporting-services-2008

What installer contains the Microsoft Business Intelligence Development Studio 2008?

My installation of Visual Studio Team System 2008 (Development Edition) does not have it. I can't find it in the SQL Server Enterprise 2008 installer either. ...

Reporting Services 2008 - Can you link 2 datasets together?

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

Mode Statistical Aggregate Function in sql server Reporting Services 2008

I am trying to compute Mode along with a bunch of other aggregates (SUm,Min,StdDev) on a report. Currently there is a Row Group and a Column group. The row Group is by region and the Column Group is based on the results from a column. Following an tutorial online, I got this custom code working for it. Dim values As System.Collections...

Using a shared data source for dynamically generated and deployed reports

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

SQL Server Reporting Services: combine initial rendering level and interactive expansion

I have a report in SSRS 2008 that shows data aggregated from four levels of grouping. I'm using the ASP.NET ReportViewer control to show the report on my webform. If I show all four levels in detail, the report gets very very long (hundreds of pages). So therefore, I'd like to set a default level to show (1-4) when I render the report -...

Using Shared Dataset in Subreport

Greetings! I am using SSRS with MS SQL Server 2008 R2, which has the new feature of supporting shared datasets. First, I created my shared dataset, and made sure that it worked correctly and had a good connection. That worked great. Second, I created a new report (Let's call it "ReportSub"), and I had it use my shared dataset. The rep...

Report services report fixing a data driven field to display a fixed list regardless of data there

Hello, Reporting Services 2008. Have a field in a dataset - Report table is a matrix. This is a row group. I see the data form this field only if there is corresponding data for it - But I would like to make that list, a fixed list, that is numbered - Is there any way to do that? Example - Current display: Broken Dish ...

SSRS R2 Deployment issue with lookup built in function

I have a SSRS R2 report built and it works fine on the preview tab but when I try to deploy the report to the report server I get the following error: Error 1 The Value expression for the text box ‘Textbox23’ refers to the field ‘Bats’. Report item expressions can only refer to fields within the current dataset scope or, if i...

Dynamic Column from SQL in Reporting Services/SSRS

Right now i am using two rdlc file to achieve. except for the field gender and field age , rest are the same. these are the two queries i use. query 1 :select state,gender,count(*) from table query 2 :select state,age,count(*) from table how do i dynamically set the column frm the dataset to achieve in a single rdlc file. do i need ...

Upgrade from SQL2008 to SQL2008 R2 caused problems with complex reporting services report

After upgrading our report server from SQL2008 to SQL2008 R2, one of our complex production reports will no longer work properly. This report has several parameters such as selecting all data or a specific group of data, and selecting summary data only or detail along with the summary. Since going to R2, if we select a small group detail...