Display Images in Crystal Report From Folder based on ImagePath From Database | Swift Learn

[Music] welcome to my channel swiftland this tutorial i will show you how to display image in crystal report in visual 2015 using asp.net c-sharp [Music] if you don't subscribe my channel yet please subscribe and press the bell icon for upcoming videos this is the server catalog hyphen sbr i expand the database my database name is my task db and table name is user info underscore tab select the records these are the records in the database table uh id name address xmas file you can see d files folder 101.jpg the location only image location stored in the sql database table and the physical image is in the d drive uh files folder 1012 and t dot jfg okay now start visual studio 2015 files new website okay i'm going to create an application to load image in crystal report in visual studio 2015 using c sharp okay location c sharp tutorial folder and name the project for the backslash and my project name is [Music] display me in crystal report okay now click on okay yes this is default uh text default tag okay now i just removed this is completely blank page now i'm gonna design this uh page with button control and a crystalline viewer control okay text is load report and i just added a crystal report viewer okay the buttons font sizes xlrs and the color of this button is green [Music] okay [Music] now for color is white onboard true okay now go to the solution explorer right click on the solution our application add new item i'm gonna add a crystal report yes yes crystal reports name the crystal report i just named it user info underscore report add uh using report wizard okay now where do we explain the word adb select overlay provider for sql server next server name my sql server name is catalog hyphen sbr user id is sa and password is exclusive authentication password database name is in my task db next finish okay now action on my task db x-men the dbu and just select user info and click on arrow finish okay now i'll design this button i'll add this field from the field explorer first of all i'm gonna add a text object to for the title of this report user info report center and font size is 15 okay [Music] research this text object [Music] okay now go to the field explorer expand the database field user info underscore tab now just to drag this uh column uh drag this field and drop it in uh into the username for report id name address sex image file you can see uh image file is only text by uh image location stored in the sql database table what you see in the user info tab only image location but not physical mesh so [Music] change the font size okay now design this uh report so that it looks like a table or a horizontal line draw horizontal and copy the line and paste in each column [Music] okay it's done now [Music] double click on the button click event now connect to the sql server database sql connection chronicle to new sql connection i should add namespace using system.sql client okay the namespace is added [Music] now in the double creation i will add the connection listing to get the connection listing to the server explorer right click add connection server name is my catalog hyphen sbr authentication is called server authentication username essay and password is exclusive authentication password and the database name is my task db select my task db click on ok yes now it's connected with the askwell server database uh expand the table either in four tab i did name sex mess file okay now go to the property and copy the connection listing paste it in sql connection you can see your id is so okay but password is look like a star you should put your password i just put my password and connection is open the connection to from the connection conduct open now sql command mysql command is to select all the records from user info underscore tab so sql command sequel to new sql command select start from my table name is user info underscore tab so select start from user info underscore tab okay call the connection con now sql data adapter sql data adapter d equal to new sql data adapter see see the is command data set ds okay data set ds equal to new data set to use data set you should add namespace using system.data yes it's added the namespace is added now d dot fill ds okay now report [Music] refer document are equal to new report document to use report document you should use the name space using this crystal report engine distribution dot crystal recorded engine okay now r dot load server dot map path i mean crystal report physical crystal report path server map path yes my report name is user info underscore report dot rpt okay user info underscore report dot rpt now r dot set data source ds dsm dataset ds dot tables table finally crystalline viewer one dot report source [Music] uh report source is uh our okay crystal viewer one this is the uh this control i added in the default.spx this is the name of this crystal report viewer one [Music] okay r dot export to http response export format type to use export format type uh you should add namespace using crystaldecisions.shared just click ok it's added using crystaldecisions.share okay now portable dock format then response then attachment attachment is and the attachment name will be user info i mean crystal reporter name will be user info uh attachment false okay adjustment is false now right click and go to the view in browser load report yes the report loaded successfully but image is not showing it's a displaying only image location instead of image physical image okay now i'm gonna work for displaying the image file okay now right click insert fixer any pixel add any fixer from your desktop i just adding a picture yes i uh just place this picture in this column image column resize and place here then if you can select choose any fixer but now just add heading heading is image file [Music] okay now right click on format object picture select the graphics location just click yes extend the catalog as we are already add your connection expand the user info tab image file okay i just set graphics location as image file okay now it's saved click on ok yes now save right click view in browser load report yes i can see all the image displaying part image sizes it's the images original size which is very big so just uncheck the can grow okay save and reload the space load report yes now the images you can see sex male female now i'm gonna add higher clause i are sex equal to men now it will uh display that records only mail reload this space load report yes sex is mel if i uh for female it will display only female okay reload load report yes you can see it displaying only female you

Channel: Swift Learn

Views: 17,816

Keywords: swift learn, display image in crystal report using physical path, display image in crystal report from database in asp.net c#, display image from database in crystal report in asp.net using c#, display image in crystal report using physical path c#, display image in crystal report from folder in c#, how to display image in crystal report dynamically in c#, load picture dynamically to the crystal report in asp.net, crystal report in asp.net using c#

Id: MvbxpvUcxdU

Length: 12min 37sec (757 seconds)

Published: Mon Sep 28 2020