Hello all...
Anyone know how and "need code example" of taking several tables and making one nice clean printed report. I have a master table and 8 child tables connected. I want to click print from the master table and a full report be generated with all the child records. I am assuming there should be a echo child tables needed, but I am not sure how to do this without screwing things up. Any help would be greatly welcomed.
Cheers!
Tony
Blending multiple tables to print one report.
Re: Blending multiple tables to print one report.
Hi,
can you make a screenshot sample of what you try to achieve.
can you make a screenshot sample of what you try to achieve.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: Blending multiple tables to print one report.
Hi utony,
from experience with MS Access - which has imho a good report editor - creating a nice, clean report with 8 subtables will be tricky
Take pbötchers suggestion and visualize (=make a drawing) of what you want to accomplish. Maybe then, when you show us your drawing we can come up with some idea for nice & clean.
Olaf
from experience with MS Access - which has imho a good report editor - creating a nice, clean report with 8 subtables will be tricky
Take pbötchers suggestion and visualize (=make a drawing) of what you want to accomplish. Maybe then, when you show us your drawing we can come up with some idea for nice & clean.
Olaf
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
Re: Blending multiple tables to print one report.
How about a way to to print the patent table--dvp and all child related tables-dvp to a pdf output?????
Can you help there
Can you help there
Re: Blending multiple tables to print one report.
Hi,
should probably work (especially Chrome can directly save as PDF) - but depending on your 8 subtables the 'nice and clean' could be a problem.
Why not just try?
Olaf
should probably work (especially Chrome can directly save as PDF) - but depending on your 8 subtables the 'nice and clean' could be a problem.
Why not just try?
Olaf
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view