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 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.
 Question Submitted By :: Novice123
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 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.
Answer
# 1
SQL Expression is one Feature in Crystal report,by SQL 
commands we pull the data from data base server to crystal 
report. 

Advantage:it's reduce the load on the server. bz we are not 
loading all the table into Crystal reports, just we are 
loading what we want using SQL.

 
Is This Answer Correct ?    2 Yes 2 No
Shashi
 
  Re: 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.
Answer
# 2
Answer 1:
Yes,there is a way.User may create a word document,embed 
the required image as a picture object in it and then embed 
this word document inturn into Crystal reports(as a linked 
OLE object).

Any change in the word document would reflect in all he 
reports using this word doc.

Answer 2:
The following article would explain about this:
https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.s
ap.km.cm.docs/oss_notes_boj/sdn_oss_boj_erq/sap
(bD1lbiZjPTAwMQ==)/bc/bsp/spn/scn_bosap/notes%
7B6163636573733d36393736354636443646363436353344333933393338
323636393736354637333631373036453646373436353733354636453735
364436323635373233443330333033303331333233313337333833373331
%7D.do

Answer 3:
This was to confuse you further.There are formula 
fields,database fields,sql expression fields,paramter 
fileds etc and nothing like expression fields.
 
Is This Answer Correct ?    3 Yes 0 No
Prathamesh.a
 
 
 
  Re: 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.
Answer
# 3
One feature is there in crystal report xi.First To insert 
an image we are doing Insert->click Picture -> we select a 
picture from a directory that you have access to and click 
on open and insert the picture where in report header 
section.
To make the above object dynamic we can follow below steps:
1.Right-click the static OLE object that you inserted, and 
choose Format
Graphic from the shortcut menu.
2. In the Format Editor, click the Picture tab, and then 
click the Conditional
Formula button adjacent to the Graphic Location label.
3. In the Formula Workshop, create the path
For example, if your path is stored in a database field, 
add that field to the
formula.
4. Click Save and close to return to the Format Editor.
5. Click OK to return to your report.
6. Click Refresh to update the reference link
 
Is This Answer Correct ?    0 Yes 0 No
Hemalatha
 

 
 
 
Other Crystal Reports Interview Questions
 
  Question Asked @ Answers
 
How many sections are there in the report  4
How to conditionally suppress a field based on whether a page number is odd or even?  3
What are Crystal Reports and Crystal Reports Explorer?  1
How to pass stored Procedure Parameters to the report?  1
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 to create crystal reports in .net CTS2
Can we create report using more than one database? Target3
What are the advantages or disadvantages of using Crystal Reports in a Windows Forms application as opposed to say rolling our own reports as HTML and displaying them in the Internet Explorer control?  2
Can we export data of reports into other format like in world doc etc?  5
How do we format field?  3
Where can we find the log file genertaed when we run a crystal report? Microsoft1
HOW TO USE 5 CRYSTAL REPORT OR SUBREPORT ON DIFFERENT CONDITIONS IN ONE VB PROGRAM  1
Can we use Crystal report as a stand-alone application? Covansys4
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
Is there a way to export the report formulas, like totals to excel?  2
Can we add any database field once we have chosen ?Close? button?  2
Is there any feature like summing total in crystal report? Sonata9
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 many types of reports can be generated in crystal reports? winfoware5
How do you format your crystal reports so that on exporting to word doc or pdf it will not lose the orginal format Target3
 
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