One of these should do it:

http://www.sqlusa.com/bestpractices/training/scripts/commadelimitedlist/

Most if this is trivial once you set up the calculated column/field/whatever you call it in the dataset. Then anywhere you want to show this value, you'd use the...

You could set the Fill color of a cell using something like this:

=IIF(Previous(Fields!Company.Value)=Fields!Company.Value,"Red","Transparent")

Here's how I did it.

Steps:

1. addd a tablix to your report.

2. Add Company, PurchaseOrder, PurchaseDate fields to the tablix.

3. Right-click the body line (with the lines).

4. Add Group: Parent Group

Group...

If you're in your dataset, you'd create a calculated column and use IIF(Parameters!MyParam="9999","ShowThis","Show That") Then just use the calculated value instead of the numeric value. Then you can...

ROFL... maybe I need a binary calendar?

not near enough information to help. How old is your latest backup? Do you have your transaction logs somewhere? what recovery model are you using?

Easiest way is to use a Calendar table and do the math in a stored procedure. Then base the report on that.

You tried grouping? Keep at it... that was the right direction.

SELECT ID

, MAX(Lang1) AS Language1

,MAX(Lang2) AS Language2

,Max(Lang3) As language3

,MAX(Lang4) AS Language4

FROM

(SELECT 1001 AS ID, Null as Lang1,'Japanese' as Lang2,Null As...

Cool! Thanks for the report.

What I found is that multi-valued parameters just plain don't work the way I expected them to. They work fine if you're stuffing them in an IN() clause in...

Looks like the simple answer to this is to use 3 separate Boolean parameters instead of one Multi-valued integer.

Just to test my theory, I tried creating a multi-valued parameter and...

since your result looks like a matrix, I just have to ask - what does your underlying dataset look like? (or the table in question).

If your data table isn't normalized...

Come to think of it, you might want to look up Doug Steele's DSNless connection code for Access. (Not entirely sure it works for SQL Server, but I don't see...

You should be able to relink the tables to SQL Server.

If you use integrated security in SQL Server (so Active Directory handles authentication), you would just have to create groups...