Error to see images in report in C#

Question

0.00/5 (No votes)

See more:

I made a dataset which includes the table with its columns.

Then I added report new item. Then I choose the dataset and select the columns and designed it. It also has a image filed which saved in database.

Now when I want to debug it, for the rows which has images in the image column is says #ERROR. So I can't see the pictures in the report. How can I fix it?

Also the dates field shows LongDateTimeString like 5/6/2012 12.00.00 AM all of them have 12.00.00 AM in the report. I just want to show 5/6/2012 in the report nothing else.
btw i'm using Microsoft Reporting

How can I fix these 2 issues?

Thanks in advance

Posted 5-May-12 22:36pm

aliprogrammer

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Accepted Answer · 2012-05-05T22:57:00

Solution 1

You missed to mention it is SSRS. Now,

the image column is says #ERROR
This simply means that the column type defined for the image is not configured correctly to show an image. Look here for details on how to do it:
MSDN: How to: Add an Image (Reporting Services)[^]
Display Database Image in SSRS from Northwind demo database.[^]

I just want to show 5/6/2012 in the report
Try:

VB

=Format(Fields!MyDate.Value, "MM/dd/yyyy")

Quick detail here: Working with Dates in Reporting Services[^]

Posted 5-May-12 22:57pm

Sandeep Mewara

Comments

aliprogrammer 6-May-12 5:11am

Thanks.

Sandeep Mewara 6-May-12 5:16am

Welcome.

Shahin Khorshidnia 6-May-12 6:12am

+5

Sandeep Mewara 6-May-12 7:22am

Thanks.

(__Aaron__) 6-May-12 8:28am

5. Good

(__Aaron__) 6-May-12 8:28am

5

Sandeep Mewara 6-May-12 13:11pm

Thanks.