inserting images into a sql server

[tmashley]

hello, i have a problem;

i am using vb.net
i have a web application
and version Crystal Report.NET

I need to view a picture in a crystal report.

This picture is created at runtime by the user and is named <username>.jpeg

The picture can vary each time the user logs in but is always named after his/her login name.

I think i need to save the file to disk (done that) then load the file into a database table called "ImageTable" on a SQL server,

Then create a sqlDataAdapter and generate a dataset pulling all values out of the "ImageTable".

This dataset will then be used within the crystal report as the source and the Image data droped into the report at design time.

this doesn't work: i am getting this error:-


Query Engine Error: 'C:\WINNT\TEMP\temp_f37a6d54-cf2a-482a-8e1a-75aab21ac5bd.rpt'
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.


please help,
there must be an easy way the view a
picture in a crystal report that is generated a runtime,

anybody know of some nice code?

thanks,
tom.

[tmashley]

bump