How to display images in crystal report from database am inserting address (image folder) of images into the database, not inserting images into the database...
View 1 Replies
I have created 1 report in my web site (EmployeeDetail.rpt) using inbuild crystal report .
Now I wanted to display image of respective employee(s) according to selection(department wise)
I tried everything but it did not work.
(I have uploaded and stored images on server in EmpImages directory empID wise)
How to achieve this ?
I want to display images in crystal reports from database. what i do?
View 1 RepliesHow can i upload image to a folder and its path to my database using stored procedure?
And similarly i want to retrieve images from database using their paths stored in database through stored procedure...
i want to display image which is stored in some folder and its path is stored in database table. i used your link [URL] for the same but i am not storing any thing like data column in my table and have passed name column to Byte[]and so its giving datatype error there. what is the way to convert it to byte?
View 1 Repliesi want to display image which is stored in some folder and its path is stored in database table. i used your link URL... for the same but i am not storing any thing like data column in my table and have passed name column to Byte[]and so its giving datatype error there.
View 1 Replieshow to read the image from excel shhet if i have foder which contain images .
so i want to dispalying image from excel shhet
.how can i do this wheather how can i assign the path of image/foder in excel shhet
Actually I am developing one web application,in that application I used a gridview to display all the database records in a page. I provide hyperlink print for every row, if I click the print option, the particular record will be print in the crystal report..
View 1 RepliesI want use flowplayer to play my flv video file. I have a datalist like below :
<asp:DataList ID="frmViedo" runat="server">
<ItemTemplate>
<div class="flowplayer"> <video>
<source type="video/flv" src='<%# Eval("Vurl" , "~/Videos/Video/{0}") %>'>
</video></div>
</ItemTemplate></asp:DataList>
In code behind :
if (Request.QueryString["vid"] != null) {
frmViedo.DataSource = video.GetVideoById(Convert.ToInt32(Request.QueryString["vid"]));
frmViedo.DataBind();
} public OleDbDataReader GetVideoById(int id) {
string strSelect = "select * from Video where VID = @VID";
return ExecuteReader(CommandType.Text, strSelect, new OleDbParameter[]{
new OleDbParameter("@VID" , id),
}); }
But it don't work and i get this error :
Adobe Flash is disabled for this page, click player area to enable. Why?
i want to display the image either from a database or through file upload control but in case of database i had seen your article but what binary data i can store as you had in data column table and when i save a file somewhere through file upload but it is not displaying the image.
View 1 RepliesI am developing audio related project for that i have stored movie names with mp3 file paths in database I am displaying movie names in grid view after clicking on movie name related mp3 file paths will be display in details view i am unable to play that files in details view how to do this ? Here i am storing original mp3 files in one folder in solution explorer and paths in database
View 1 RepliesI have two reports but i want to use the same crystal report viewer to display both reports depending on an option selected. How can I achieve this?
CrystalReportViewer.setCrystalReportSource(CrystalReportSource3) or something like this i am just not sure about the code in c#
I am working with Parametrized Crystal Reports. There are only two page called Source.aspx and Target.aspx.
[code]...
Only One text box data shows Not 2nd One.Can any one help me with this by checking my code?
When i run the application locally it works fine but when i publish it n access from it it gives the error asEither the Crystal Reports registry key permissions are insufficient or the Crystal Reports runtime is not installed correctly.
View 2 RepliesI want to display a crystal report in my vb.net application. Suppose I have tables named student details, student marks, student address, etc... Nowif I want to display all these details (fields of all tables) in one crystal report (with page breaks if necessary) then how will I achieve it. I will be providing a combo box in my application that contains list of student names.How can I link this combo box with the cystal report to dynamically display report for different student on selected index change of combo box?
View 2 RepliesI'm using Crystal Reports in a Webform inside of an MVC application. Images in the reports are not being displayed, however, on both the ASP.NET Development Server and IIS 7 (on Win7x64).
I know from a number of other questions similar to this that the CrystalImageHandler HTTP Handler is responsible for rendering the image, but I've tried all of the usual solutions to no avail.
So far, I have
Added the following to my appSettings (via http://www.mail-archive.com/bdotnet@groups.msn.com/msg26882.html)
<add key="CrystalImageCleaner-AutoStart" value="true" />
<add key="CrystalImageCleaner-Sleep" value="60000" />
<add key="CrystalImageCleaner-Age" value="120000" />
Added the following httpHandler to system.web/httpHandlers (via http://stackoverflow.com/questions/2253682/crystal-report-viewer-control-isnt-loading-the-images-inside-the-report)
<add verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
Added the following to my Global.asax.cs (via http://stackoverflow.com/questions/2006011/crystal-reports-images-and-asp-net-mvc)
routes.IgnoreRoute("{resource}.aspx/{*pathInfo}");
and
routes.IgnoreRoute("CrystalImageHandler.aspx");
why the images still 404?
i created a crystal report in my project . that is report worked fine if i run in debug mode(F5).then i created a virtual directry "myweb". if i run it from the browser like "localhost/myweb".. Data is displaying properly.but crystal report header images are not displaying. and i am not able to export & print.i have "aspnet_client" in www root folder. crystal report images and hava script files are exists in below path
C:WINDOWSMicrosoft.NETFrameworkv2.0.50727ASP.NETClientFilesCrystalReportWebFormViewer3
I have a crystal report designed in cystal report 9. The report also has a sub report. Now what I want is to show dynamic image in the sub report. My images are saved in sql server 2005 as image. Anyone has any idea how to show the images from sql server 2005 to crysatal report.
View 1 RepliesI need to link 2 stored procedure in crystal report, passing same parameter id, i tried but getting error
"Unable to connect: incorrect log on parameters."
in this way i'm creating report.
1) Create Dataset(myTable.xsd) in App_Code folder
2) Create a blank Crystal Report, Field Explorer getting Database Fields, from Database Expert (ADO.Dataset Objects), selecting the
myTable.xsd Dataset
3) Drag the fields in Crystal Report n Execute
My report does not use data from a database. It uses a code generated dataset. How do I give crystal reports the necessary logon data to avoid database logon failures.
View 1 Repliesviewer tool bar images not displayed in development?
View 8 RepliesCrystal Reports Toolbar Images not displaying in the production server.
View 3 RepliesI have been trying from the past two weeks to integrate crystal reports into my web application. The problem is "We created some reports using Crystal Reports 2008(Sp2) and we are trying to integrate those reports into webpage. Everything works fine on my local machine but when it is deployed to the production server i ran into a lot of problems..
Problem-1 : First time I load the report it comes to the screen where it prompts for DB credentials and stucks up there..I mean those are non editable and doesn't go to next screen. On my local machine the report even didn't prompt for DB credentials. Why it prompts when moved to prod'n Box? How to avoid that?
Problem-2: How about the images on parameters screen?
am using a crystal report with unparameterised stored procedure (i didn't use any parameter).
but i noticed the the report keeps the data from last "Refresh report data".
i hve crystal report which is wrking perfectly fine.. now i want to add paramter to my stored proc... but i am not able to add the same parameter on crystal report..i tried to add parameter in the parameter fields the crystal reports field explorer.. but when i verfiy database it still gives msg stored proc expects parameter which was not supplied..SQL State 42000 native error..
View 2 Replies
