Type this in the jump to url field...

="http://sever99/folder1/page1.aspx?profitCenter=100&department=" & field!department.value

and that should do it.

1. Use the query to get the available fiscal dates for your parameter.

2. Combine the other two queries into one

----------------

declare @startdate datetime, @enddate datetime

SELECT @startDate = FiscalStartDate, @endDate = FiscalEndDate

FROM...

Wouldn't this work as well, and more efficient?

SELECT

a.ServerName

FROM

tableA a

LEFT JOIN tableb b...

Just a comment ....

One other thing that I've noticed, and haven't found how to get around (and I doubt you can), is that the settings in the users Adobe Reader...

My experience with Host Headers is this:

As long as the Report Server Address in your .config files, the address you use in VS for the RS match the host header...

To address the wait time for the subscription to complete, make the following changes to the stored proc. This solution was devised by hughthomas -> http://www.sqlservercentral.com/forums/userinfo.aspx?id=86254

Add the following lines...

What are the datatypes of your fields (ID and name)?

What is the error message you are getting?

Wouldn't this work?

.....AND (field in (@parameter) or @parameter like '%All%' )

?

I'll try to test this and get back to you asap.

I'm not positive, but I'm pretty sure it's not possible within one text box.

One possible solution is to use formula's to calculate the 'left' properties of your second and third...

The second agument of replace is the replacement text.

I think you want

REPLACE( REPLACE( thecolumname, CHAR( 13 ) , '' ) , CHAR( 10) , '' ) AS TheString

This may be a stupid question, but do you have "Allow saving Password" selected?

Just a thought...

create a table with the parameters as fields.

have the report's parameters use the value from this table as defaults but not available values.

have the dataset that is used...

My understanding of your situation is that you have restored a backup and want to know where to see it?

If this is correct, it is restored 'over' the database that...