ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Microsoft Related  >>  Crystal Reports
 
 


 

 
 Visual Basic interview questions  Visual Basic Interview Questions
 C Sharp interview questions  C Sharp Interview Questions
 ASP.NET interview questions  ASP.NET Interview Questions
 VB.NET interview questions  VB.NET Interview Questions
 COM+ interview questions  COM+ Interview Questions
 ADO.NET interview questions  ADO.NET Interview Questions
 IIS interview questions  IIS Interview Questions
 MTS interview questions  MTS Interview Questions
 Crystal Reports interview questions  Crystal Reports Interview Questions
 BizTalk interview questions  BizTalk Interview Questions
 Dot Net interview questions  Dot Net Interview Questions
 Exchange Server interview questions  Exchange Server Interview Questions
 SharePoint interview questions  SharePoint Interview Questions
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions
Question
I am not able to see any image on Crystal Report at Run time.
So how can I load any image which is saved in local disk so
that it can be viewed at Runtime in Crystal reports?
 Question Submitted By :: Rekha47
I also faced this Question!!     Rank Answer Posted By  
 
  Re: I am not able to see any image on Crystal Report at Run time. So how can I load any image which is saved in local disk so that it can be viewed at Runtime in Crystal reports?
Answer
# 1
You may have used Link Image at design time (while 
inseerting OLE object) therefore report requires it on 
machine on whihc report will be run. One can solve this 
problem by embeding image in report rather than linking it 
(by unchecking Link opetion while selecting image).
 
Is This Answer Correct ?    10 Yes 3 No
Peerzada
 
  Re: I am not able to see any image on Crystal Report at Run time. So how can I load any image which is saved in local disk so that it can be viewed at Runtime in Crystal reports?
Answer
# 2
try { 
        // here i have define a simple datatable inwhich 
image will recide 
        DataTable dt = new DataTable(); 
        // object of data row 
        DataRow drow; 
        // add the column in table to store the image of 
Byte array type 
        dt.Columns.Add("Image", System.Type.GetType
("System.Byte[]")); 
        drow = dt.NewRow; 
        // define the filestream object to read the image 
        FileStream fs; 
        // define te binary reader to read the bytes of 
image 
        BinaryReader br; 
        // check the existance of image 
        if (File.Exists
(AppDomain.CurrentDomain.BaseDirectory + "10157.Jpg")) { 
            // open image in file stream 
            fs = new FileStream
(AppDomain.CurrentDomain.BaseDirectory + "10157.Jpg", 
FileMode.Open); 
        } 
        else { 
            // if phot does not exist show the nophoto.jpg 
file 
            fs = new FileStream
(AppDomain.CurrentDomain.BaseDirectory + "NoPhoto.jpg", 
FileMode.Open); 
        } 
        // initialise the binary reader from file 
streamobject 
        br = new BinaryReader(fs); 
        // define the byte array of filelength 
        byte[] imgbyte = new byte[fs.Length + 1]; 
        // read the bytes from the binary reader 
        imgbyte = br.ReadBytes(Convert.ToInt32
((fs.Length))); 
        drow(0) = imgbyte; 
        // add the image in bytearray 
        dt.Rows.Add(drow); 
        // add row into the datatable 
        br.Close(); 
        // close the binary reader 
        fs.Close(); 
        // close the file stream 
        CrystalReport1 rptobj = new CrystalReport1(); 
        // object of crystal report 
        rptobj.SetDataSource(dt); 
        // set the datasource of crystalreport object 
        CrystalReportViewer1.ReportSource = rptobj; 
        //set the report source 
    } 
    catch (Exception ex) { 
        // error handling 
        Interaction.MsgBox("Missing 10157.jpg or 
nophoto.jpg in application folder"); 
    }
 
Is This Answer Correct ?    5 Yes 2 No
Vishu
 
 
 
  Re: I am not able to see any image on Crystal Report at Run time. So how can I load any image which is saved in local disk so that it can be viewed at Runtime in Crystal reports?
Answer
# 3
write the column of Byte array Type
And pass Tha byte data into this column 
and drag the column to the crystal report.
 
Is This Answer Correct ?    3 Yes 0 No
Deepak Kumar
 
  Re: I am not able to see any image on Crystal Report at Run time. So how can I load any image which is saved in local disk so that it can be viewed at Runtime in Crystal reports?
Answer
# 4
If you are working with version 11 , then drag and drop an 
ole object rt click on format graphic --> go to picture tab
--> Graphic Location -->enter your path in the formula.
 
Is This Answer Correct ?    5 Yes 0 No
Rajavivekvarma
 

 
 
 
Other Crystal Reports Interview Questions
 
  Question Asked @ Answers
 
Does Crystal Report support all the functions that we have in Oracle? MPS-Techologies2
Can we create report using more than one database? Target3
Can we export data of reports into other format like in world doc etc?  5
I have a crystal report with a linked subreport as well. is there any way not to print the current record on the main report if no records are returned from the subreport? thanks you email - stanlte@yahoo.com  2
How do you format your crystal reports so that on exporting to word doc or pdf it will not lose the orginal format Target3
Can we use our own SQL for creating a report?  5
what is the "refresh" button suppose to do on the crystal report viewer?  1
How many types of reports can be generated in crystal reports? winfoware5
How many .rpt files are be there in a main report having 2 sub reports? Accenture16
Can anyone help me with an answer to this question? Where is the image located, after you've placed it on the report?  2
HOW TO USE 5 CRYSTAL REPORT OR SUBREPORT ON DIFFERENT CONDITIONS IN ONE VB PROGRAM  1
How to "Print" in Crystal Reports while using ASP DOT NET Platform?  3
How to present data from Crystal Reports on to form?  3
Reports can be optimized for web viewing using which of the following strategies: a. Using subreports instead of linking tables b. Avoiding maps c. Using the Page N of M special field to help users understand how many pages are in the report d. Saving reports as version 10 e. Avoiding reports with drill-down capabilities  1
How do we format field?  3
Are there any limitations in crystal reports?  14
I had an Interview yesterday for a Crystal Reports Developer position. Some of these I have not done in my reporting experience and I had just a half day's notice for the interview, hence no prep time :-( 1) Is there a way to be able to change an image(company logo) dynamically in a report? Example if you have 100 reports, and with the market uncertainity if you anticipate that the company logo might change, how can you change the image just in one place and have this reflected in all teh reports at run time? 2) What is a SQL expression? 3) What are field expressions and what are the diff types? (I looked this up in the internet and never found anything with regards to types of field expressions) The interviewer really got me confused as I felt he was not clearly setting forth his questions but it could be that I was unable to understand his wording of the questions. I expect a big zero from his feedback but I am hoping this is an experience for future interviews that I face in crystal reports when I do get some more lined up. Thanks in advance! Anita New Jersey, USA. Barclays3
One more interview question If I have the data where some columns have multiple values in a given row of data returned from the database. The stored procedure returns data as it is that is blanks values and non blank values. However, I need to suppress the blank values not by showing 0 values but by shifting the cells up. Is there a way using a formula to shift the blank cell one row up based on a selection critieria? In the example below, I want to get rid of the blank values under Exposure column without replacing with 0. example: Company Margin Exposure AB 500 3 10 7 8 ABC 200 4 2 5 10 Thanks Anita Barclays2
Can we add any database field once we have chosen ?Close? button?  2
How to pass stored Procedure Parameters to the report?  1
 
For more Crystal Reports Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com