Dynamic Reports?

[NewfieSarah]

Hey all I have no Idea about dynamic reports and I dont know if I want to go this way, I have been pushed from this solution a few times now, however I am not sure how to solve my problem. I need to give my users, the ability to create reports on the fly. I have a filtered form, and I would like my users to have the ability to use that filted information on that form to create a report. These reports have to be flexable, not all fields are going to be needed each time a report is created. Can anyone help. I am kind of new at this so all comments are great. Thanks

 

[dhookom]

There is a complete "query by form applet" at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

An all Access mail merge feature was added Mar 6, 2004. This allows users to create simple mailmerge output without using a word processing program such as MS Word.

The DH QBF is a complete query by form applet that can be easily integrated into any existing Access application. Typically, the functionality provided by DH QBF can replace many "canned" reports. The developer imports several forms, tables, a query, and a report from the DH_QBF.mdb, creates some master queries, and deploys.

The developer creates one or more master queries that join tables, alias field names, create calculated columns, etc. The users can then select a master query (datasource) from a drop-down and then select up to 30 fields from the master query. Users can define sorting and criteria as well as grouping and totaling. All of this "design" information is stored in two tables for re-use.

The results of the queries are displayed in a datasheet subform contained in a main form. The main form has options to send/export the records to print, Word table, Word merge, Excel, HTML, CSV, Merge to Report, or a graph. Most formats allow the user to automatically open the target application. The Word merge process will open a new Word document and link to the merge fields.



Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[NewfieSarah]

okay so the results are a query and they can be merged into a report, they are not in a report form already. I never said anything about a mail merge so I have no use for that information, I was just wondering if what is in my mind is possible or if it cant be done what can I do. I looked at that sample and it is very confusing all i got were beeps and the ability to not change anything. so I have no idea what to do. Thanks