Ok, I just performed those actions you asked for.

They seem successful.

ok, doing it now.

be back in a sec.

Thanks a lot Wayne

Craig,

The data was just dumped from mainframe to a .txt file and I just imported it to sql server db.

Hello good people, sorry for late response.

We have to leave the building at certain time of day and I just got here from heavy traffic.

Let me start responding from bottom...

Thanks Wayne,

I would have been able to display it as I showed in the example but the problem is that when I query the db, it displays only the first...

hi Jeff,

The data type is nvarchar(50) and it is stored one record per row.

However, rather than have the name appear, say 7 times ( or 7 rows), we want the...

Jeff,

You are absolutely correct. The correct expression is the % wildcard.

I don't know where this guy got his from.

This is where I found the * wildcard:

http://blogs.sftsrc.com/stuart/archive/2009/05/08/154.aspx

As you can...

Right, I do KNOW that the % is the wildcard character in sql server but I am also told that the % doesn't work in SSRS, rather it accepts the...

Thanks a lot Luke for your kind response.

This is asking for Windows authentication.

As stated, everything was fine before.

What's funny is that I can see view the reports when I fire...

I *think* I got it working Scott.

I am having difficulty putting your ideas together to work for me.

I did, however, "borrow" an idea that I have kind of used differently.

Since...

Actually, initially, the requirements weren't complete.

Initially, I was told to just worry about whether a client had been assigned to a judge previously for similar or different case(s).

If yes, automatically...

Keith and Greg.

Thanks a lot for your inputs.

I grappled and fretted with this design for a long time and asked a lot of the questions you came up with.

Eventually, I...

YES!

Experts-Exchange!!

I was actually thinking either Experts-Exchange or Tek Tips.

The legends of this forum continues to grow as it is loaded with superb talents.

Hope to get there one day.

In the last...

Hi Scott,

Thanks.

I have made the change - index change.

I guess I don't understand why they have to pick a judge from a dropdown vs. you just randomly assigning one. Couldn't...

Thanks very much Scott.

I am fine with these changes.

Infact, I have modified my db so they now like these.

How do I approach the code from here?

Do I trash the codes...