Azhar S
May 16th, 2001, 07:11 AM
I'm using 8 tables in the report. I'm taking Id value from a text box on form which is selected from one table and the corresponding values of that particular Id from all other tables should be displayed in the report.
The problem is I wanted to suppress those fields of all the tables whose filed values are blank. If the corresponding Id doesn't exist in a particular table it should not display the field names as well of that table.
For that I inserted each field in each section and suppressing section whose field value is blank using format section-edit formula.
when the Id entered exists in the tables it is working fine by suppressing blank fields. But when the corresponding Id doen't exist in a particular table it is displaying just all the field names of that table. Which is unnecessarily increasing no. of pages.
Can u just help me out in solving my problem which is very urgent.
Give me the alternative ways to solve this problem. The 'field Names' of that particular table in which the corresponding Id doesn't exist should not be displayed.
Note: I'm using Crystal Reports 6.0 , Access Database and VB as frontend.
Thanks in Advance.
The problem is I wanted to suppress those fields of all the tables whose filed values are blank. If the corresponding Id doesn't exist in a particular table it should not display the field names as well of that table.
For that I inserted each field in each section and suppressing section whose field value is blank using format section-edit formula.
when the Id entered exists in the tables it is working fine by suppressing blank fields. But when the corresponding Id doen't exist in a particular table it is displaying just all the field names of that table. Which is unnecessarily increasing no. of pages.
Can u just help me out in solving my problem which is very urgent.
Give me the alternative ways to solve this problem. The 'field Names' of that particular table in which the corresponding Id doesn't exist should not be displayed.
Note: I'm using Crystal Reports 6.0 , Access Database and VB as frontend.
Thanks in Advance.