Images Across All Reports
The link below shows how to do the images across all reports the way I wanted it, but I got lost following the instruction after statement :
"Then I create a dataset and a parameter for each logo path that I need. The parameter is populated from the dataset.
Add an image control to your report (since you will populate the URL from a parameter, you can put the image control in the header/footer as well as the body)
Set the source to External, and the Value property to an expression: =Parameters!LogoPath.Value
If you set the image control to Fit Proportional, the logo should resize automatically."
I posted a comment on the blog but I guess it has not been approved, so I have not seen my post.
Can someone please give an example on how to do this?
http://bobp1339.blogspot.com/2007/10/dynamic-images-in-reports.html
November 17th, 2010 11:09am
Ok,
thats was very claver blog,
Now you can use datasets column in header and footer, it can only be used in Body,
So if you want to use it in column create a data set, the way he said
than create a parameter, make it hidden and internal,
and then use your image set to populate that parameter.
now you can use this parameterless value anywhere in your report and that value is nothing but your Image.
Hope this help.
PS mark as ANS if helpGaurav Gupta http://sqlservermsbiblog.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
November 17th, 2010 12:35pm
I wanted to put the image in a header for a logo and body for products.
Once thing that got me confused on his instruction is that how did he get =Parameters!LogoPath.Value? When I created my dataset with the Stored Procedure GetConfigItem @ItemType, my parameter is =Parameters!ItemType.Value. Does this mean, for
example, I create two datasets to create an image for a Logo?
Also, since the Stored Procedure is GetConfigItem @ItemType and what are the values in the Report Parameters Properties?
November 17th, 2010 1:14pm
ok,
What he did he created atable and put the Logo URL in that table
Like following ,
LogoName LogoURL
ABCD http://Servername/ABCD
so create a table like above one say configLogo
So now you need to create a data set do SELECT * FROM configLogo and attech a parameter to it, just like i mention in my previous post.
once you do that go to Image property, use this image expression, go to parameter tab and select you parameter.
thats all....
Gaurav Gupta http://sqlservermsbiblog.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
November 17th, 2010 2:38pm