Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ingineu
Yak Posting Veteran
89 Posts |
 Posted - 2003-11-05 : 03:07:40
|
| I come up with an error -- can't set record source property after printing has started. I am running Access 2000 with SQL Server database (adp). My report has a subreport that creates a SQL stmt in the Report Open event. I'm aware that 'adp' does not support parameters in a stored procedure in a Subreport, so my work around was to set the recordsource to the SQL stmt in the subreport Open event. What can I do to solve this problem? I am trying to create a report with a subreport linked by Location. The subreport has a date parameter. |
|
|
ingineu
Yak Posting Veteran
89 Posts |
Posted - 2003-12-02 : 17:42:50
|
| Finally figured this one out. I cleared the LINK to Parent and LINK to Child properties. In the SubReport, I set the REPORT recordsource to the Stored Procedure and set the Input Parameter to reference a field on the Main Report:@LocnCode nvarchar(4) = [Report] |
 |
|
|
|
|
|
'adp' subreport problem