creating reports

[drewdaman]

hi there all..
i'm trying to create a report in design view. what i have done is put all the stuff that i want to display in a record set. now, i would like to put the stuff from the record set into a report. i do not know how to access a particular "index" in the report. so for example.. i would like to put the contents of r.fields(0).value (r is my record set) into my first column and first row of my report.
Does anyone know how to do this??

Thanks in advance,
drew

 

[dhookom]

What have you done so far? Are you using code to CreateReport()? If so, you will probably want to use code to create controls with CreateReportControl(). You can then set the new control's Control Source property.

Creating reports with code is a bit daunting. Is there a reason you don't build a few reports and then modify them with code to meet your needs on-the-fly?

Duane
MS Access MVP

 

[drewdaman]

hi.. thanks for the quick response.


yeah.. you're right.. it is a bit daunting. but the reason i thought it would better to do it this way is because my boss wants to be able to select which fields should be visible in the report. so... on a form possibly have some radio buttons, let the user select what he wants to see, and create the report accordingly. this is my first project in ms access.... and i don't know if there is a better way to do this! if you know of one, please let me know.

i did create a bunch of reports based on queries. but the wizard makes you decide what fields will be shown right at the start. i don't know if there is a better way!!

thanks for responding and hope to hear from you soon!

 

[dhookom]

I created a fairly decent query by form a few years back and stick it in most of my apps. It allows users to select any fields they want (up to 30) from your pre-defined "master" queries. They can set a sort order as well as supply criteria. When they click the report button, the results are displayed in a datasheet subform. The main form has buttons that allow the user to send the results to CSV, Word, Text, Excel, HTML, or print. They are two clicks from viewing a copy of their data in Excel where they can do what ever they want with it.

This has kept many users/customers satisfied beyond what I originally expected. I have even modified the applet to send the results to a graph where they can choose the type.

The QBF is included in the Corp Tech Demos at

http://www.invisibleinc.com/divFiles.cfm?divDivID=4

Duane
MS Access MVP