It appears that you added the element I said to add to your WHERE clause to the query that pulls the options for your parameter. That is not where...

OK, first I need to clarify something.

Is your parameter supposed to be multi-value (that is you can select 1, some, or all of the available values)? If it is,...

I am assuming that the first dataset is used to populate the parameter for selecting the manager, and that this parameter is not set to be a multi-value.

That being the...

My first suggestion would be...

I would venture to suggest once again my strategy for using 2 separate text boxes that contain the same value, one with the action defined to jump to report (along...

I've tried that, and while it is true that you would not send the user anywhere, you would still have the cursor change from an arow to hand (or whatever...

What I have done in the past in similar situations is to place a rectangle in the matrix instead of a textbox. Then, in the rectangle, place 2 textboxes...

In your table, try creating a group (outside of any current grouping you have) with no header or footer, and the page break after value set to true. For...

No problem. Glad I could be of assistance.

shiv179 (1/8/2009)

---

chujohnson (1/8/2009)

---

Would it work to, instead of doing the calculation for the report item in a text box, as I assume you are doing now, add a new field...

You could try putting a rectangle in the cell of the table, then putting two subreports inside the rectangle overlying each other, and setting the visibility property on each of...

Would it work to, instead of doing the calculation for the report item in a text box, as I assume you are doing now, add a new field in the...

Shooting in the dark here, but would it work to simply delete the reports in question from the deployed location, set the security you want for the parent folder, and...

Don't know if you figured this out yet or not, but you could do something in your where clause similar to this

WHERE (@Parameter = 0 AND CASE_CLOSED IS NOT NULL)...

Have you verified that the user credentials supplied in the subscription have the correct access to the location where you are trying to have the exported file written?