March 22, 2012 at 4:17 pm
Want to allow users to enable or disable logos (images) prior to running SQL report.
The reason for this is that logos (images) take up a lot of space (without it report is 3 times smaller when saving to disk). I assume user will disable logos from being displayed via a drop-down parameter in report. Can anyone assist ?
March 22, 2012 at 4:33 pm
An iif expression in the visibility property should work.
=IIF( param.Value = False, "somepic.jpg", "")
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 22, 2012 at 4:42 pm
Thanks, will give it a try. Most reports have 5 logos (images), one for each department, so if finance user selects finance parameter (department), the finance logo is displayed, if sales then sales logo is displayed.
March 22, 2012 at 4:46 pm
A switch can possibly work as well.
Example:
=SWITCH(
IsNothing(Fields!Field1.Value), 0
IsNothing(Fields!Field2.Value), 0
1=1,ToNumber((field1 / field2) * 100)
)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply