Answer / jahnavi

if you choose enforce to for a join type table a and table
b and you select only fields from table a even then table b
is included.

if you choose enforce from for a join type from tableA and
table B and you select only fields from table B still the
table A is included.

Answer / sajal kumar

Version 10 introduced the capability to enforce link created in report. Enforcing a link between two tables ensures that the report's respective SQL uses this link, regardless of whether fields are required from one or both the involved tables.
The default setting is unenforced links, meaning that Crystal Reports uses the link only if the report's respective SELECT statement requires it.
You can access the different enforcement option by right-clicking on a link and selecting the link Options menu item.

Answer / rajesh

can u give me any example and answered clearly

Is it possible to export crystal report with linked subreports in one excel sheet?If yes,then how?

4 Answers   IBM,

---

How to pass stored Procedure Parameters to the report?

2 Answers  

---

How can we improve the performance of a crystal report? OR What all performance improvement techniques used in crystal reports? (particularly CR XI)

9 Answers   CSC, ERS, Jupiter,

---

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?

0 Answers  

---

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 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.

1 Answers   GRV India, Patni,

---

How do you format your crystal reports so that on exporting to word doc or pdf it will not lose the orginal format

3 Answers   Target,

---

hi.. i've one crystal report. i want the report header as "employee database". i dont want to right click->insert and goto text object and insert. i've one aspx page and aspx.cs page also. now i want the "employee database" header to be printed from .cs file. i dont want to pass by parameter also.. i.e is there any option in .cs file something like ReportDocument myreport = new ReportDocument(); myreport.Load(MapPath("~/" + "emp.rpt")); myReport.Reportheader="Employee database"; i hope u have understood this. only thing is from .cs file i want to print the header as employee database. i dont want by passing parameter also... please help....

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,

---

Can we use stored procedure for creating the report?

11 Answers   Medreich,

---

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)?

0 Answers  

---

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 Answers  

---