I am working with CR 9 and Access 97 as the datasource. I have a report with 4 subreports on it. Each subreport is linked to the main report by a common ID field. This part has worked fine so far but we recently revised the queries that feed each of the reports, including the main report. When I try to set a new datasource location it seems to work but the datasource remains the original query. I removed the links to each subreport, but there are references to the old query in formulas. This also happens when I try to set the datasource of the subreports to new queries.
Another problem is that I have unknown parameter fields in 3 of the 4 subreports. In the field list for each subreport I have a parameter field known only as ?[]. I must have created them by mistake, I am not sure how or when this happened. They are each marked as being used on their particular report but they are not physically placed on the report itself, so I figure they must be 'named' in a formula or expression somewhere. I haven't been able to locate where they exist and since they are marked as being in the report I can't delete them.
Are these two problems related to each other? Any help would be appreciated.
Another problem is that I have unknown parameter fields in 3 of the 4 subreports. In the field list for each subreport I have a parameter field known only as ?[]. I must have created them by mistake, I am not sure how or when this happened. They are each marked as being used on their particular report but they are not physically placed on the report itself, so I figure they must be 'named' in a formula or expression somewhere. I haven't been able to locate where they exist and since they are marked as being in the report I can't delete them.
Are these two problems related to each other? Any help would be appreciated.