By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,968 Members | 1,180 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,968 IT Pros & Developers. It's quick & easy.

Creating Reports from a Template

P: 2
Hello all,

I have a report that is currently being used to generate monthly statistics. We wanted to enhance this report by including a form with specific selection criteria before the report is generated. So I tried using the CreateReport method with the existing report as the template. I then created a new parameterized query that I added as the RecordSource for this templated report created by the CreateReport method.

When I execute this code, I am not prompted for the new values for my query. Instead, I am shown a blank new report template.

Am I approaching this in the appropriate manner? At runtime, is it possible to have a form that allows a user to select what items should be within a report before it is generated?
Feb 4 '08 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 10K+
P: 14,534
Have a look at this tutorial on Dynamic Reporting.

Dynamic Reporting
Feb 5 '08 #2

P: 2
Thanks, but this solution still does not answer my question. I am trying to use an existing report, but with a new form that will allow users to enter in specific parameters so this report can be more dynamic. So I was trying to use this report as a template within VB code, but it doesnt seem to be working.

i.e. Report A already exists... The user is displayed a form where they select a bunch of options. They click a button called generate. The VB code creates or copies Report A, changes the RecordSource to a new specific query and displays the new report.

Is this possible? Or do I need to dynamically create this report as described by the solution above?

Feb 7 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.