Hi There,
I have a report, which has one sub report.
The data sources are stored procedures for each report(sql)
The sub report uses the same parameters as the main rpt, and passes them into the sp call. Ok
The Subreport links are all sweet, and work fine
Except that when you first open the report in the designer, and run it, a error is generated by the sub report database call, as it attempts to passin ?%? for each parameter!!! - and so the sp returns an error
If you click ok, and then refresh the data, it all works fine.
I have checked all, and re imported sub rpt etc all to no use.
Can anyone help??
ps.
I have two other reports, which use the same data sources etc, and have the same sub report, and they work fine.
(apart from one which behaves similary, but does actually run consistently live - outside the designer!)
Im trying.... will get there in the end......
I have a report, which has one sub report.
The data sources are stored procedures for each report(sql)
The sub report uses the same parameters as the main rpt, and passes them into the sp call. Ok
The Subreport links are all sweet, and work fine
Except that when you first open the report in the designer, and run it, a error is generated by the sub report database call, as it attempts to passin ?%? for each parameter!!! - and so the sp returns an error
If you click ok, and then refresh the data, it all works fine.
I have checked all, and re imported sub rpt etc all to no use.
Can anyone help??
ps.
I have two other reports, which use the same data sources etc, and have the same sub report, and they work fine.
(apart from one which behaves similary, but does actually run consistently live - outside the designer!)
Im trying.... will get there in the end......