Reports

IIF Function in Dataset
try changing Parameters!Depot.Value = "0" to Parameters!Depot.Value = 0, integer do not need the string quotes :) From http://www.developmentnow.com/g/115_2006_1_0_0_687155/IIF-Function-in-Dataset.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/ ... 14 Apr 2010 11:04

Table Group Header
How can I create a group header on a table object that displays a dataset field? I tried grouping but the group took up the whole column like sample below. John Doe 3/13 200 3/13 450 Instead, I would like it to display as below John Doe 3/13 200 3/13 ... 13 Apr 2010 12:50

Force subreport size
I am using SSRS 2008 and have a report with 2 subreports which work fine. However, I want to force them to be a certain size and not shrink. Is there a way to do this on the main report? I could not find a "Can Shrink" type of property. Or do I need to put them inside a rectangle in order to do this? Thank... 15 Apr 2010 11:24

Getting total pages per group/section
Hello, I am trying to include total # of pages per group on a SSRS report. For example, if the SRS reports has parameters customer ID and document date, it will print all invoices for that customer(s) for the date. For each page of the form, we would like to include page # + total # of pages, such as 1/... 12 Apr 2010 20:23

Strange join created by report model 2005
Hey, I have a created a report model which sits on top of a data warhouse, and for the most part it works fine. I am having an issue where te sql generated by the report is really bad and slowing down the report to crawl. Here is an exmaple of the sql SET DATEFIRST 7 SELECT [BESPOKE_factStates2].[Li... 12 Apr 2010 08:07

Odd behavior in SSRS 2005: different totals in dev version and deployed server version
Hi, Two issues: (I am using SSRS 2005) 1. I have a report that gives very different results for one grand total between the dev version and the desployed version. Same report, same stored procedure, but a differece of 20000 for this one total between the two versions. I even made sure that the report was being... 10 Apr 2010 14:37

Linking 2 subreports to main
I have a SQL 2008 main report that prints checks and is based on a stored proc and it works fine by itself. I have subreports that I want to add to this main report but I cannot figure out how to "link" them. I was able to drag the subreport from my solution in VS 2008 and place it on the main report but when... 15 Apr 2010 13:39

series point value
hi, how to get a seares point value, for example, first point value and last point value? Thanks. ... 9 Apr 2010 11:10

Calculated Member Failure
I have a calculated member issue that I'm sure is simple but cannot get to work. This works fine .... SELECT NON EMPTY {[Measures].[Clm Amnt], [Measures].[Denial Detail Count]} ON COLUMNS, NON EMPTY{[DenialPostongTimeData].[PrimeDate].[Month_Date]} ON ROWS FROM [Denial Detail Analysis] I would t... 9 Apr 2010 10:02

can't hit 2008 db with ssrs2005?
I'm using BIDS 2005 and I have some data on a new SQL2008 db, and it says I need to have 2005 beta 2 or better if I want to hit 2008? ... 8 Apr 2010 16:20