Is there another layer of security there? What's to stop a user from Germany, clicking on Ireland reports?

Annoyingly, the export to PDF will readjust your margins too. No matter what you do, your margins will always be one inch. Horrendous waste of paper and/or report...

rather than use the Hidden property, you could pass the fiscal year to the subreport and filter your data there instead.

what might be easier is to set up your logic for what rows get highlighted in the query. Add another column called Highlight and set it appropriately...

I export to csv and excel, the only time I've run into a problem exporting is using SSIS and it saving things as UTF instead of ASCII which screws up...

When you choose the report in the drop down BIDS should pick up the Parameters. Then Right under that there's a spot to add parameters, you add the parameters...

it depends how you want to access the, if you use a subreport from the toolbox then you set the parameters the same way as you would a dataset. ...

I want some reasonable winter temperatures. We have snow but it''s been to cold to ski(Around the -30C).

Other than that, I'm not a gadget person, but I would...

can you post the code you used for url?

What's the error?

When you pass a multivalue parameter you have to do a

=join(Parameters!PraramName.Value,",")

I always forget this step, that and forgetting to make my receiving SP variable large enough to...

I'm not sure one would work and not the other. I use it to hide the entire tablix, not just columns. The interactive Option I hadn't seen before....

Ha! RPL it is. the way I had my IIF set it would have worked even if I had "CAT" in there. Never too late to fix...

Hmmm, yes I see your point. The link that Koen posted has RPL in it, yet the code I have in a working report is RDL. not sure...

For the Parenthesis:

=IIF((Globals!RenderFormat.Name = "EXCEL" OR Globals!RenderFormat.Name = "PDF"), False, True)

Nested

=IIF(Globals!RenderFormat.Name = "EXCEL" , False,

IIF(Globals!RenderFormat.Name = "PDF", False, True)

...

what about =IIF(Globals!Rendername.Name!='RDL',TRUE,False)

Haven't tested, just a guess?