Somehow QoTD regularly reinforces recently acquired knowledge. Like this....thanks.

Glad to help

🙂

Not sure about that one.

I would try 2 things. First substitute a hard value to see if you can get it to work like 12 MOD 5.

Second check the...

Try this format for your URL instead.

http://hostname/ReportServer?/folder/report&parameter=value

I am not sure I am completely reading your sample URL properly but it would end up something like this:

http://itsssa118/ReportServer?/CHE+Reporting+Services%2fHEAT+Reports/Ticket+Journal+Entries&CallID=01344470

If I understand your question and the title, it will be something like this:

=IIf (Fields!eSourceProvider.PGMIDANNUAL.Value > 0, Parameters!EmAnnual.value Mod Fields!eSourceProvider.PGMIDANNUAL.value, 0)

Try dropping the rs:command=Render. I don't think that works without a follow on format command like &rs:Format=render.xml

This does not answer your question directly, but it may be the solution you are looking for:

http://msdn.microsoft.com/en-us/library/aa337169.aspx

Hope this helps.

So, the URL you see in Report Manager does not work when you paste it into another browser tab or instance?

If I understand the first part of your question, it is pretty straight forward. Just make the available values of a paramater based on the results of your query....

You can use many different data sources. However the way your BIDS project is configured will determine when the data sources are deployed. If you 2 different sources...

reflections

Great question. I got it right....and still learned a couple of things in the explanation. Thanks.

You might also see it as Microsoft Visual Studio 2008, maybe in a separate program group.

Normally Mondays don't really bother me that much, but today I got hit with a bunch of alerts and errors first thing. What...

Curious, the difference in default behaviour between a DECLARE and a CONVERT.

I suppose this just puts another check mark in the Always Declare Everything column.