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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error with SubReports

Status
Not open for further replies.

UNCTarheels

Programmer
Feb 5, 2002
48
US
I am using CR 8.5 in Mas 90/200. I needed to display a jpg/gif that was associated with an inventory item. If I created a standalone report, the report displayed properly, with the graphical image. However, when accessing the report through MAS, the graphical image would not display. In investigating this, I discovered that a linked subreport was required. In preview mode in CR, the graphical image displayed properly. I then saved the report and tried to preview the report in MAS. It caused a database error.

The error information is:

Messagebox:
crystal print error: error detected by database driver

The SQL Trace is: (partial trace, at the end where the problem occurred)

windx" -id=T0 - 578-55c EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 00901598
SQLHANDLE * 0x02F86CD4 ( 0x00902a18)

windx&quot; -id=T0 - 578-55c ENTER SQLExecDirect
HSTMT 00902A18
UCHAR * 0x02EE60D0 [ -3] &quot;SELECT Inventory_Image.&quot;ItemNumber&quot;, Inventory_Image.&quot;Picture&quot; FROM &quot;Inventory Image&quot; Inventory_Image WHERE Inventory_Image.&quot;ItemNumber&quot; = 'DR36S'\ 0&quot;
SDWORD -3

windx&quot; -id=T0 - 578-55c EXIT SQLExecDirect with return code -1 (SQL_ERROR)
HSTMT 00902A18
UCHAR * 0x02EE60D0 [ -3] &quot;SELECT Inventory_Image.&quot;ItemNumber&quot;, Inventory_Image.&quot;Picture&quot; FROM &quot;Inventory Image&quot; Inventory_Image WHERE Inventory_Image.&quot;ItemNumber&quot; = 'DR36S'\ 0&quot;
SDWORD -3

DIAG [S000] [Best Canada][PVX ODBC Driver][FILEIO]Table is not accesible (12)

windx&quot; -id=T0 - 578-55c ENTER SQLErrorW
HENV 00000000
HDBC 00901598
HSTMT 00902A18
WCHAR * 0x0012BC74 (NYI)
SDWORD * 0x0012BDB0
WCHAR * 0x0012B874
SWORD 242
SWORD * 0x0012BDAC


What did I do wrong? s-)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top