brett grammar (1/25/2007)

So RS does not have Report Headers, only Page Headers, which are created and appended after the body of the form is generated. I had a fairly simple...

I feel sorry for you. These areas are very poorly documented with real world examples of usage, even in books dedicated to RS (I know, because I've read them all).

Sacheen (9/29/2010)

I have created one parameter in a report which takes values from a dataset.

I have marked option to allow NULL values but when values are populating in the parameter...

That's what I do (in some cases, for some specific reasons, that escape me right now):

WHERE InvoiceDate >= DATEADD(d, DATEDIFF(d, 0, @StartDate), 0)

AND InvoiceDate < DATEADD(d, DATEDIFF(d, 0, @EndDate), 1)

There's a knowledge base article on Microsoft's site that lists all the SQL updates since each main release and service pack.

2008: http://support.microsoft.com/kb/956909

2008 SP1: http://support.microsoft.com/kb/970365

(there's none for SP2 yet that...

I don't know about MDX, but I do know about RS's Hidden parameter and how it sometimes doesn't do what you expect. For example, sometimes it leaves blank space and...

There's a list of groups at the bottom of BIDS, you can right click the group you want and click to add a row outside the group above; that will...

I have a hundred or so reports that need to be deployed into different folders, and copied across multiple servers (development, testing, production) which means that the BIDS deploy function...

I store files locally, and keep them in source control. We used a 3rd party program for that named Fortress, and it integrates properly with BIDS 2008. It puts little...

I couldn't understand what you were trying to do, but accessing sub report values from the parent report isn't possible.

I think what you want can be done in a different...

I would love to hear any real world implementations of report models. As far as I've seen them, they're unusable if there's going to be any changes in the database...

You're comparing an integer with a string by accident, so it fails. I think you want to do:

=IIf(Fields!TotalCalls.Value Is Nothing, 0, Sum(Fields!TotalCalls.Value))

I loved your entry today, it summarises my feelings about a lot of companies today - and getting dropped instead of being transferred seems to happen a lot more than...

Resolved:

WITH Link_CTE (link_id, next_link_id, root, level) AS

(

SELECT link_id, next_link_id, root = link_id, 1 AS level

FROM things t

WHERE EXISTS (SELECT * FROM customer c WHERE c.link_id = t.link_id)

UNION ALL

SELECT t.link_id, t.next_link_id,...