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.
Answers were Sorted based on User's Feedback
Answer / hemalatha
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 ? | 16 Yes | 1 No |
Answer / prathamesh.a
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 ? | 13 Yes | 1 No |
Answer / shashi
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 ? | 15 Yes | 4 No |
Answer / neeraj goud
1. yes there is a way to change the image it in the oje
format not in a one section where the old image is the ther
we will insert the new image.
2. SQl expression is in the field explorer option once go
throw that it will analze u only
3.Field expression is not there i think dat is field
explorer
Field explorer means nothing but what ever reqired for the
report field we will adding by this field explorer
EX: Data fields, Formula fields etc
| Is This Answer Correct ? | 0 Yes | 0 No |
reporter footer contents are move depend the page footer values...........
hi... i've two crystal reports one is in D: drive name employee.rpt with 5 textobject and another report is in E: drive name employee.rpt with 15 textobject... now i want to write a program to overwrite the D drives report with E drives reports i.e i want to replace the 5 textobject with 15 textobject.. overwriting the reports while it is executing .. is there any code for it please help me.. its urgent..
How to open subreport in New IE window using hyperlink button. I used target=new; in the formula field. But it overrides the main window and show the report. Can anybody answer this please....... Regards Vimal.
Kindly Help for this Below Scenario, I am going to implement Power BI into our internal software. I’m familiar with the fact that each user can pay $9.99 a month to build and view reports but what I need to know is how can we embed Power BI into our application so that any users that log into our application can see the reports without the monthly fee. I’ve researched enough that it can be done. What I am not familiar with is how to do it or the pricing of embedding it into an application. I think they do pricing on how many renders you do or something. Would you be able to look into how we could embed it into our software and the cost?
How to write a formula to change a font based upon data ?
If we create reports in Crystal Reports using the UCAR Data Warehouse database, which tables should be used?
How do we format field?
Is it possible to join more than one universe in Busniess Objects BOE XI ? If its so Please explain how is that possible ? Thanks in advance for the people posting the answers
What all performance improvement techniques used in crystal reports? (Particularly cr xi)?
How to pass stored Procedure Parameters to the report?
hi.. i've created one crystal report. and one global resource file .. in crystal report there's one text object with id Text1. and i want to take the values of resource file i've got it CrystalDecisions.CrystalReports.Engine.TextObject Dtemp1 = ((CrystalDecisions.CrystalReports.Engine.TextObject)myreport .ReportDefinition.Sections["section1"].ReportObjects["Text1" ]); Dtemp1.Text = Resources.Resource.ResourceManager.GetString("Dsec1"); it is showing the correct value want i want but when i give print it is disappearing.. how to solve this please help me..
to ensure that all of the data from a field is displayed in a report text object you should do which of the following?? a) use the format wizard b) size the text object manually c) select the auto format option for the text object d) select the can grow option for the text object e) set the can grow option to the details section of the report
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)