Displaying a subset of data 1

[griffter]

I have a report where we are displaying all the fields held on a particular form, some of these fields have options which are held in a separate table.

I want to display one form at a time user driven by a parameter, on the report all the fields that form has used are displayed this uses two tables where all the records match to one and other. Two of the fields have options in them which I want to display in the same report, however because only two of the fields have elements in the option fields table as soon as I add the field to the report it only displays the two records. How do I get around this?

 

[GJParker]

sounds like you need to change your join type to an OUTER JOIN.

textual descriptions are always very confusing. You would be better served by supplying examples of your input data, table structure and expected outcome.

Also include basics such as

Crystal version
database
connection method.

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[griffter]

All this is new to me but I have looked at how the SQL queries work and I can see what you are saying as when I view the SQL Query it is an OUTER join which is not what I want. However this SQL was generated automatically by Crystal Reports presumably by the database expert dialogue. Can I change anything in the links window or will I have to write my own query?

 

[GJParker]

From your initial description then you do indeed need an OUTER JOIN, you may need to reverse the join though. This can be done in the database expert.



Gary Parker
MIS Data Analyst
Manchester, England