Hi there,
Has anyone out there had success with instantiating reports? In past, where I've tried to do it the report just closes semi-unexpectedly after changing recordset (or filter).
My current project uses reports for one type of screen because a continuous form can't be "grouped." These reports show different information and need to be open at the same time. (e.g. comparing 1 "case file" against another "case file").
I've avoided this issue in the past by simply maintaining multiple copies of the report (depending on if they are using the "local" table or the "network drive" table), but this seems messy.
My ideas for alternatives are:
1) Continue maintaining multiple copies manually
2) Have each form instance that might want to open this report create a temporary copy of the report, then close/delete the report when the form closes.
3) Find a workaround to group continuous forms? (This would be ideal actually).
Any thoughts as to how to do this better would be appreciated.