Answer / nazer mohamed

Advantages
----------

1. Secure as End user cannot modifiy the data which is
appear in the report if we use crystal report to show the
report but in HTML, user can modify the report data

2. Report layout is not transparent, so that end user will
not know about how we design the report. But in HTML,
anybody can study the report layout and can copy the
technology

3. Can export into different format like PDF, HTML, XML,
etc.,

and many more...

Disadvantages
-------------

1. End user need to have the crystal report viewer in his
PC in order to see the crystal report output. But this can
be overcome if you export the report as PDF/HTML

2. You need to buy Crystal Report license for each pc you
are used to design the crystal report.

3. Must buy the version which allows you to install run
time components in end user PC

and many more...

Answer / satish atakare

4. Crystal Report is slow as compare to Active Reports
5. If we have 100 pages report then crystal will need to
process all pages and then it shows the output.

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.

5 Answers   Barclays,

---

How many sub-reports can report can have?

4 Answers   IBM,

---

Can we add any database field once we have chosen ?Close? button?

2 Answers  

---

Can we export data of reports into other format like in world doc etc?

5 Answers  

---

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

5 Answers   Barclays,

---

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

2 Answers  

---

hi.. i've created a crystal report and one crystal report viewer in windows form. i've two form form1 and form2 in form2 i've kept one button called print. when i press this button it should print the document into .pdf format. without using the crystal report viewers print button.

0 Answers  

---

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

2 Answers  

---

What all performance improvement techniques used in crystal reports? (Particularly cr xi)?

0 Answers  

---

What does it mean when we get the error message "Invalid report version" when try to open a Crystal Report?

3 Answers  

---

How to conditionally suppress a field based on whether a page number is odd or even?

3 Answers  

---

Can we use stored procedure for creating the report?

11 Answers   Medreich,

---