I'm just trying to protect myself from the infamous MDB corruption issues. That and allow for a lot of data... so we'll see. Just don't know how I...

oh, sweet! That's handy! So I just have to use Windows Scheduler directly instead of using a job (which probably talks to Windows Scheduler)... Okay.

Thanks!

So you have data that's not clean? You might want to look around here for Fuzzy Matching articles. If you have SQL Server Enterprise, you can use it...

REPLACE is your friend...

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