Thanks for the response. Better late than never. It gives me something to think about. I am still developing the database at this time so I still...

Thanks, After many hours of reading I have also come up with the same general idea. It is nice to hear the idea I came up with is not...

After many hours of playing with this problem still no clue how to fix it. If I run a report that has all fields filled in, it works correctly....

No one has any ideas at all why this is happening?

thanks that worked. 

thanks for the replies... it looks as if i am going to use a stored procedure that does all the joins and stuff.  I was wanted to populate a table...

Thanks for the Replay, i know you can't pass them into a view but is the anyway to change the @TrackingNo to a1.TrackingNo or DECLARE a variable and set it...

I am not sure if i understand... it only seemed to add an extra row at the end that is the same as the row above it...

still not working like it should.. i went into the host machine and added a group called System User and then added the people that need to run reports in...

i have put the users in all the places i can and still they can not access the reports unless i make them administrator for the host machine.....  I am...

I ended up figuring out how to get the list as i needed it... using the code below... but now when i send that list as a parameter to my...

i am using report server 2000 sp2 ... i think the above code will be helpfull i am just a little lost... currection in my VB code i return an...

no.. i don't have any hyperlinks at all..

It is fixed right now.. i ended up reinstalling RS yesterday and now RS runs almost twice as fast... not sure why but my...

I have found a fix that fixed both of my problems with solution.

-Go to your IIS Manager

-Right Click and go to the properties of your ReportServer vitural directory

-In the virtaul...

i was thinking the credentials were not being supplied also.. but wasn't sure how to supply them since my company wants to use Windows Authenication for everything.... and my site...