Azhar S
May 16th, 2001, 01:10 AM
I'm using Crystal Reports 6.0 Access as Database 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 the sections whose field values are blank.
RecordSelectionFormula is from the master table.
If the ID entered doesn't exist in any one of the table then the entire field names related to that table should not be displayed in the report as it increasing the no. of pages.
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 the sections whose field values are blank.
RecordSelectionFormula is from the master table.
If the ID entered doesn't exist in any one of the table then the entire field names related to that table should not be displayed in the report as it increasing the no. of pages.
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)