June 8, 2006 at 11:00 am
I have an image based of a company ID that i have to go and fetch... on the image property i have it set to External and i have this as the value...
="https://www.mycompany.com/inc/File.aspx?dbname=DEFAULT&key=" & Parameters!CompanyID.Value OR Parameters!SubCompanyID.Value OR Parameters!BranchID.Value & "&contenttype=AUTO"
would this work or is there a better way of fetching images based on the companyID i am being passed through a parameter???
Thanks
MC
Moe C
June 8, 2006 at 7:38 pm
We recently implemented something similar but used a standard 'if' statement to make the switch. I am looking to mod this to use a case statement (rather than nested "if's") to handle an increase in the number of options.
Not sure it will help in your situation though as you're checking multiple parms, but here's our statement anyway.
=IIF(Parameters!Business_Unit.Value = "ABC", "http://server1/reportimages/ABC_logo.gif",http://server1/reportimages/DEF_logo.gif)
Steve.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
