leveetated
Programmer
Hello CR experts,
CRXI
MS SQL Server 2005
I've been going round and round on a problem over the last week and am at my wit's end! It must be a simple setting I've overlooked.
I simply want to pass a number to a SP, and use that value in a WHERE statement, followed by an INSERT. I have a main report that's passing the value to the subreport, which is using the SP as its datasource.
I know the sub is getting the correct value, but when I run the report the sub only passes NULL to the SP. (I'm using ?parameter to the sub, not the ?Pm-@parameter.) The report hits the SP, then runs the INSERT and passes NULL into the int datatype field that should store the report param's value.
I've already built a similar report so I know it can be done. I've tried switching drivers (tried OLE DB (AD0), SQL Native, ODBC RDO) and I still get NULL.
Anything else I should check, CR wise ones? Any suggestions much appreciated.
Best,
Lee.
CRXI
MS SQL Server 2005
I've been going round and round on a problem over the last week and am at my wit's end! It must be a simple setting I've overlooked.
I simply want to pass a number to a SP, and use that value in a WHERE statement, followed by an INSERT. I have a main report that's passing the value to the subreport, which is using the SP as its datasource.
I know the sub is getting the correct value, but when I run the report the sub only passes NULL to the SP. (I'm using ?parameter to the sub, not the ?Pm-@parameter.) The report hits the SP, then runs the INSERT and passes NULL into the int datatype field that should store the report param's value.
I've already built a similar report so I know it can be done. I've tried switching drivers (tried OLE DB (AD0), SQL Native, ODBC RDO) and I still get NULL.
Anything else I should check, CR wise ones? Any suggestions much appreciated.
Best,
Lee.