how to design a report with data

[asker]

hi,
I have a table with ID column, the ID column value repeated for many records and so on.

now i want to print each distinct ID records in discrete report.
how can i do this??

 

[dgillz]

Is there only one table in your report? If not, is there a many to one relationship between the 2 tables? Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[arabic]

only one table

 

[dgillz]

provided that you are using an ODBC data source for your report, click on Database, select disctinct records. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[chelseatech]

ANother method is to create a group on your id field and supress the details section. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm