We have added a new Intranet to our system (we already had one, but have added another for a separate company, but it uses the same server). I copied all the files from the old intranet to the new one and changed all the datasources for queries etc. I am now finding that a report with a subreport in the new intranet wants to get its data from the old intranet's datasource. (The datasources have the same names, but the new intranet datasources have _MNKU added to the name).
How can I tell the subreport to read its data from the same place as the main report - ie in the new intranet?
The report and subreport should get their data from the same table, with the subreport having two parameters to link with the main report. Having read the LiveDocs I get the impression you can't have parameters if you specify the SUBREPORT option in a cfqueryparam?
Also if I specify the query to use in the cfreport tag the sorting and grouping goes astray, but if it uses the query set within the report builder ide it sorts and groups correctly. (I have pasted the sql from the query builder in the ide to a CF form and specified it as the query in the cfreport tage, and it messes up).