Showing posts with label rdlc. Show all posts
Showing posts with label rdlc. Show all posts

Wednesday, March 21, 2012

Image for path returned by Query in RDLC & ReportViewer

Anyone know how to add an image to report whose path is returned by
the query?
JasonOn Mar 10, 3:05=A0pm, Jason Wilson <wils...@.ausrad.com> wrote:
> Anyone know how to add an image to report whose path is returned by
> the query?
> Jason
I figured this out, but now I would like to show a tif image. Anyone
know how to do this?sql

Image control in RDLC report page.

Using RDLC report file, How can i set the image path on image control to the image in my folder \images.

I don't see any ImageURL property in such control.

thanks,

Hi,

From your description, it seems that you want to add a image in your report, right?

You can include stored images in a report by specifying a URL to the image. When you use an external image in a report, the image source is set to External and the value for the image is the URL address to the image. For a report published to a report server configured for native mode, use a full or relative path. For example,http://<servername>/images/image1.jpg. For a report published to a report server configured in SharePoint integrated mode, use a fully qualified URL. For example,http://<SharePointservername>/<site>/Documents/images/image1.jpg.

For more information, see:

http://msdn2.microsoft.com/en-us/library/ms156482.aspx

Thanks.

Sunday, February 19, 2012

IIF expression problem

Hello all,

If anyone could give me a hand on this it would be greatly appreciated. The problem i am having is as follows: On a rdlc report I have a column which I am generating a currency value based on a nested IIF statement. What is happening is if I don't have the if statement for the column and just calculate like so : =Fields!Amount.value * 0.02 the number comes out correctly, however if I have it in the following iif statement it automatically rounds the values.

=FormatCurrency(IIF(Fields!Amount.Value = 114.00,((Fields!Amount.Value * .02)* 2),0)Or

IIF(Fields!Amount.Value = 20.00,((Fields!Amount.Value * .02) * 12),0)Or

IIF(Fields!Amount.Value = 216.00,(Fields!Amount.Value * .02),0))

Any insight would be great

Thanks

whats the datatype of Fields!Amount.value ... is it an integer or decimal