dystopia

You can add

& VbCRLF &

to add a carriage return/line feed to your expression.

This pattern will work in SQL when you are only dealing with a single column of data.

USE AdventureWorks

GO

DECLARE @listStr VARCHAR(MAX)

SELECT @listStr = COALESCE(@listStr+',' ,'') + Name

FROM Production.Product

SELECT @listStr

GO

I never tried to use Not Like in an SSRS before, but I don't see any clear way to do it. I checked expressions, filters, etc. and there is...

Buffalo

quoth

If I understand your requirments, you have an invoice header and detail and you want to display both on a report.

I would query the header and detail data in a...

Is the textbox you are using a part of the report that groups the detail that you are trying to hide or make visible? The error would indicated that...

Moving

Had to read a bit to figure it out, learned something. Thanks.

So if I understand correctly, my query returns 11 employees twice, one each with a Y and one each with an N?

If my query did not return the 11 employees...

I wrote a blog about this exact problem. I hope this helps:

http://www.bidn.com/blogs/Daniel/ssas/1766/ssrs-use-row_number-to-resolve-datasets-with-different-levels-of-aggregation

You have a Yes/No parameter in your main report? Why don't you just use that to feed your second report instead of making the user choose Yes?

I think you could probably use one report. Add a group by your parameter and then put a page break between the groups. The page break should simulate...

Using SWITCH would be easier than using multiple nested IIF. A switch is a series of boolean tests and return values that will return the first value where the...