Thanks for the response. I'm aware of  like 'abcde%' or  like '%abcde%'. I was just using that for an example of how the overall flow was in my head. That...

I'll have to change the port. Any suggestions on whether or not I should stay within the registered  port range or go with the dynamic/private range? Creating a VPN has been on my list...

I took a look at the Application log and I see a lot of failed attempts for SA and Admin login. Looks like they were attempting to hack it.  Every...

Thanks again gentlemen. One day I'll make a usefull contribution to this site, (aside from helping inflate others heads).

Of course the lovely  HAVE clause.

Thanks MOM and Remi. Much appreciated.

OK I added the sub-report to the data row and choose the parameter value that I wanted to supply it and it worked. Only thing is it takes a lot...

Right on Remi! I looked at the BOL but it isn't always clear. Eventually I'll get beyond my novice ability and hopefully I won't have to bother anyone. Thanks!

Nope.  I have windows integrated authentication enabled for the website and the virtual directories.

Thank you  James for the suggestion I'll look into that. 

Steve,

It's when they access the site it self. I don't have anonymous access enabled. 

I have been testing different logins and I...

Yeah I tooled around with it for a while. It was a grouping issue. Finally got it to work. Thanks for the reply.

The ampersand works! Thanks!  What language is this using?  I am only really familiar with SQL.

This solution worked for me:

Microsoft suggests creating a DWORD entry called DisableLoopbackCheck to a value of 1 in the HKLM\System\CurrentControlSet\Control\Lsa

http://flarepath.blogspot.com/

Thanks much- gonna tool around with this!!!!!

oops! typo. Suppose to be 10001 to 10099 (100 numbers) not 100099 (thank god!)

John thanks for your post.PW thanks for your post too but that wasn't what I was asking. Sorry if I came across the wrong way. I am trying to insert...