Solved

crystal report blob field rendering twice

Posted on 2015-02-11
4
505 Views
Last Modified: 2015-02-17
We recently upgraded our C# web app from .net 1.1 to 4.0. We use Crystal Reports for VS 2010 for invoices, and within the invoices, we load a blob image of a copy of order via a SQL database.

In our previous version, everything worked fine.

Since the upgrades, the blob image loads, but there is a tiny version of the image on top of the top left corner of the image.

I've verified the database. I've removed the blob and added it back.  I've loaded the latest CR Service Pack.

The problem persists.
0
Comment
Question by:YPU
  • 3
4 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 40604186
Does it happen if you create a new report with just the blob field?

Have you saved and run the report after deleting the blob?

mlmcc
0
 

Author Comment

by:YPU
ID: 40605522
Yes.

Yes.

I appreciate your help. I've never seen anything like this in the 10+ years we've been using this set up.
0
 

Accepted Solution

by:
YPU earned 0 total points
ID: 40605944
Problem solved. Here's how I did it:

I deleted the Blob that was inserted into the report via drag and drop from the field explorer.

Then I:

1. Insert OLE Object > From File
2. Found a random image and clicked ok.
3. Right click > Format Object
4. On the Picture tab, clicked the formula icon for the graphic location
5. Selected the column from my datasource.
6. Crossed fingers and ran the report
7. Problem solved.

Hope this can help someone else!
0
 

Author Closing Comment

by:YPU
ID: 40613825
See my comment above for the solution.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS SQL with ODBC 5 34
TSQL - How to declare table name 26 28
.NET 2008 VB and C# 6 27
what are the unique tables in SQL master database 5 57
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now