nope, that doesn't work, but i'll let you know if i find something that does.

thanks.

I'm not sure how to fix the problem.

You can try disabling anonymous access in IIS and adding the domain users or a active directory security group to the report folder...

Never mind, I just hard coded the Parameter Names for now.

But if anyone has an answer, it would be nice to know.

Did you ever find an answer?

Thx, Megan

Still using 2000 here too...

That's exactly what I ended up doing - I created up arrow and down arrow images and put them next to each column name.  I added Sort Direction and Sort...

I might be misunderstanding what you are trying to do, and I'm no expert, but I do know that there is an option to set the toggle as expanded by...

Wow Wayne. Thanks so much for that thought-out response.  This info gives me a much better stepping stone to start on.

-Megan

I think you need to deploy your version of the report. Saving it is not enough.

see this post:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=171642#bm172701

Only on the server unless the developers have their own instance or RS.

No known issues.

Frank -

Honestly, I gave up for a while because nothing was making sense to me - and when I came back to it, everything started working as it should. ...

I'm not sure if I am fully understanding what you truly want to do, but I'll tell you what I did - right or wrong.

Actually, I only have ServerAB - both dev and production, it's a Windows XP SP2 box with VS2k3, SQL, and RS installed.  I verified that I can access http://pb000778/reports/ and...

You need to union on option for ' all customers'.

example:

parameter dataset:

SELECT     CustomerName

FROM         Customer

UNION

SELECT     ' All Customers'

OR

SELECT     CONVERT(varchar(25), CustomerID) AS CustomerID, CustomerName

FROM         Customer

UNION

SELECT     ' All Customers', ' All Customers'

(I add the...