Create Two subreport on your main report.
In subreport 1 create sql query to select distinct record from Table A
In subreport 2 create sql query to select distinct record from Table B
you can handel it in your SQL also ,
in where clause just add
column_name is not null
Bob what you suggest is it good to handel this case at SQL level or Report level if its filtering large records from my data??
mfallon,
Now i got why 2nd page comming so.
in second page values for column1 and column2 are comming null
but column3 returning with some value.
you have used "_" to concanate three column but not handeled it for null values. when u concanate null with "_" it will return null (no space)
you...