Justin,

Best way to do a report:

SELECT the data into a CURSOR or P-View exactly the way you want it in the report. This will be denormalized data. Sounds like you are already doing this from your form.

Do not put anything in the Data Environment of the report.
Make sure your CURSOR or P-View is selected. (It should be if you just ran the query.)

Refer to the controls in your report by field name only: cMyCharacterField, not Table.Field.

Any memvars or arrays current in the form will be available when the Preview or Print button is pressed.






>What is the proper way of designing the report? Should I just run the query twice, or should I make the form and report share the same data session? If sharing the data session, what is the best means of doing this? I have tried setting the form's datasession to Default (public) from Private and this did not work. Thanks for any suggestions.
>
>
>Justin Spies