Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing a Graphic to a report using a ttx file. 20527 error.

Status
Not open for further replies.

BlackSneak

Programmer
Aug 13, 2000
9
NZ
I store a graphic (a bitmap) in a MS Access 97 database that I want to put on a report. If I add the database to the report as an Access database, the graphic prints.

However, I really need to use a ttx file and pass in a recordset from the front-end app, which contains a subset of the fields in the main table, graphic field included.
The subset contains the company name, and the logo. 2 fields.
The graphic is stored in the database as an Ole field, which equates to Blob in the ttx file.

I get a 20527 (SQL Server error) message when the front end app prints the report.
Is it possible to pass a graphic to a report using ttx files and passing in recordsets?

-BlackSneak

BlackSneak@Hotmail.com
 
Yes, it is possible. Which version of CR are you using? Is your front-end app VB?

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top