Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
For huge data report
- Thread starter suha
- Start date
Hi!
First of all, define which table will be main (root). This means a table that will be processed for detail records, table used as current alias just before REPORT FORM command.
Than define all realtions from this root table. You will see, that the main problem - define root table
How to do this - very depended on the data model your tables have and what you need to show in report. If you will have difficulties, ask more qustion with providing more information, such as tables, reports etc.
Vlad Grynchyshyn
vgryn@softserve.lviv.ua
The professional level of programmer could be determined by level of stupidity of his/her bugs
First of all, define which table will be main (root). This means a table that will be processed for detail records, table used as current alias just before REPORT FORM command.
Than define all realtions from this root table. You will see, that the main problem - define root table
How to do this - very depended on the data model your tables have and what you need to show in report. If you will have difficulties, ask more qustion with providing more information, such as tables, reports etc.Vlad Grynchyshyn
vgryn@softserve.lviv.ua
The professional level of programmer could be determined by level of stupidity of his/her bugs
You might also try using SQL to build a cursor that contains all of the fields from all of the records that you need in your report, even if you end up duplicating some information in subsequent records. If you have all of the information in one file you'll eat up some time collecting the info, but the actual printing / viewing of the report will go much faster than if it has to maintain relationships to numerous tables.
- Status
