2
Answers

how to display images from sql server to crystal report 2008

Photo of Om Mohokar

Om Mohokar

11y
3.9k
1
I am creating a I-Card Printing software on which i used crystal report in-build of VS 2008 . I have save the images path in the database .Now i want to print the images (photo,logo,signature) on the CR.But how to display is the BIG issue because i am using CR first time.
Please help me urgently... plz plzzz plzz
 In CR i used box to display images from Database.. Please tell me in brief ... thank you.. 

Answers (2)

0
Photo of Carlos Sanchez
NA 264 0 20y
Thank you jshepler. I prefer the first method, cuz is esier and cuz I dont know if the second method is possible in C#. thank you again, I appreciate your help. Regards.
0
Photo of jshepler
NA 63 0 20y
2 ways to do this: 1. Combine the two (or more) columns in your select statement: SELECT IDEmploee, Name + ' ' + LastName + ' ' + SecondLastName AS 'Employee'. You would then have 2 columns: IDEmployee and Employee. 2. Tell the datagrid not to automatically generate the columns - do them manually: Employee <%# DataBinder.Eval(Container.Dataitem, "Name") %> <%# DataBinder.Eval(Container.Dataitem, "LastName") %> <%# DataBinder.Eval(Container.Dataitem, "SecondLastName") %> The first method is the preferred way unless you need to have the columns seperate for something else. Having the database doing the work is much more efficient, not to mention easier to code.