I need to generate a report that is based on a calculated recordset. The calculated recordset is not based on a table or query. Thus when I set the recordsource of the report to the recordset source, the report opens empty eventhough the recordset contains data. I am using the following code.
Report.Recordsource = Recordset.Source.
This seems to work with recordsets that are based on a table or query. How am I able to pass the data in my recordset to the report for display. Please help.