Can we use our own SQL for creating a report?

5 Answers  

---

If we create reports in Crystal Reports using the UCAR Data Warehouse database, which tables should be used?

0 Answers   IBM,

---

How many .rpt files are be there in a main report having 2 sub reports?

17 Answers   Accenture, Cap Gemini, CTS,

---

Explain basic steps required to display a simple report in crystal?

0 Answers  

---

How many Sub Reports added in One MainReport?

4 Answers   Amadeus, Aviva, CTS, Patni, Welkin,

---

---

How many sections are there in the report

6 Answers  

---

Why is Excel Report preferred over crystal reports?

3 Answers   Atos Origin, Collabera, Lighthouse Technologies,

---

How to access crystal reports in .net?

0 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,

---

How to pass stored Procedure Parameters to the report?

2 Answers  

---

How do we connect to the database?

6 Answers  

---

Explain reporter footer contents are move depend the page footer values?

0 Answers  

---