Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Auto-generation of reports with many sub reports

Auto-generation of reports with many sub reports

Auto-generation of reports with many sub reports

(Crystal Report 8.5 Proffesional, Access 2002)

I have created a 40 page report, the report is made up of about 16 sub-reports with graphs formulas etc. The report is a template for a Doctors Practice Audit. The data for the report is taken from an Access Database.

I would like to develop somtehing to automatically generate this report for each doctors practice that requires one. There are 300 practices, each are due a report every three months, a table in the database displays the practices that are due a report each day.

I looked at RDC in VB, and Access forms with vb code in the buttons and was wondering What would be the best application to use, in order to do this.

The problems that have been worrying me are: if I use RDC and VB to generate the reports will I have to pass in the selection criteria for the sub-reports each time I generate a report. Also will I have to re-enter the details for each graph?

Does anyone have any advice

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close