Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: VS ASP.net 2008 CR to display pictures dynamically Post Reply Post New Topic
Author Message
zhixuen
Newbie
Newbie
Avatar

Joined: 03 Oct 2012
Location: Singapore
Online Status: Offline
Posts: 1
Quote zhixuen Replybullet Topic: VS ASP.net 2008 CR to display pictures dynamically
    Posted: 03 Oct 2012 at 3:38pm

Dear All,

I need the solutions or suggestions to create a crystal report in VS ASP.net 2008 to display the pictures dynamically in the report.

Example, row 1 user upload 2 photos then 2 photos will be displayed at row 2. row 2 have 3 pictures then 3 pictures will be displayed.
and so on!!

Furthermore, do you think the pictures should be stored in database or directory is a better way?

Thanks in advance !~~

IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 04 Oct 2012 at 3:31am

I don't think you can do this in a single row, although you can do it in a column.  Some of this depends on how your data is set up.  If you have one record for each picture, you definitely can't do it in a row.  If you have a single record with a field for each picture (NOT good db design!) then you could.  In this case you would put a suppression formula on the image object that is something like: IsNull({field for this picture})

 
You can either store the pics in the database or put them in the file system someplace and store the path and filename in the database. 
 
If you store them in the file system, use the properties of the image object in the report to set the image based on the value in the field.
 
If you store the pics in the database, they have to be in JPEG format and you need to either use a native database connection or an OLEDB connection - I've not had much luck getting this to work with an ODBC connection.
 
-Dell
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 04 Oct 2012 at 4:33am
well, you could have a stored proc that would return multiple pictures per row, after all that would just be data manipulation, but coming straight out of the database, you would want the better design of 1 picture per row.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.