Azhar S
May 15th, 2001, 08:28 AM
I'm using Crystal Reports 6.0 and VB as front end.
I used 8 tables in report with Id as the primary key and relationships are established.
I'm trying to display the entire information related to that particular ID from all the detailed tables used.
The problem is when the particular ID doen't exist in any one of the table still it is displaying all the field names with blank field values which should not happen.
Whereas if the entry of particular ID exists in the tables it is working fine. i.e. suppressing the section whose field values are blank
I used Format Section to suppress sections with blank field values.
RecordSelectionFormula is from the master table.
If the ID is entered doesn't exist in any one of the table then the entire field names
related to that table should not be displayed.
How to solve this problem?
Also tell me whether
1. can we use more than one SelectionFormula? If yes How?
2. How to avoid generating report if no value is entered in the text box. (Optional)
I used 8 tables in report with Id as the primary key and relationships are established.
I'm trying to display the entire information related to that particular ID from all the detailed tables used.
The problem is when the particular ID doen't exist in any one of the table still it is displaying all the field names with blank field values which should not happen.
Whereas if the entry of particular ID exists in the tables it is working fine. i.e. suppressing the section whose field values are blank
I used Format Section to suppress sections with blank field values.
RecordSelectionFormula is from the master table.
If the ID is entered doesn't exist in any one of the table then the entire field names
related to that table should not be displayed.
How to solve this problem?
Also tell me whether
1. can we use more than one SelectionFormula? If yes How?
2. How to avoid generating report if no value is entered in the text box. (Optional)