Re: Relation across multiple databases with parameters
Posted: Thu Sep 13, 2012 12:54 pm
Hi,
I've now got the latest version and I've tested the Stimulsoft2.mrt report from above and there is no crash anymore, no more 'Specified cast is not valid' error, so that's good!
But, the data is not right and only one query is executed, whether I check 'Reconnect on each row' or not, while I have two rows in the test database.
I've traced SQL Server and I'm getting the following queries:
SELECT * FROM A (correct)
SELECT * FROM B WHERE Id = @IdPar, @IdPar='00000000-0000-0000-0000-000000000000' (parameter value not correct, and only executed once).
When getting two result rows, I expect the second query to execute twice and I don't expect a Guid.Empty as parameter value.
Thanks again.
I've now got the latest version and I've tested the Stimulsoft2.mrt report from above and there is no crash anymore, no more 'Specified cast is not valid' error, so that's good!
But, the data is not right and only one query is executed, whether I check 'Reconnect on each row' or not, while I have two rows in the test database.
I've traced SQL Server and I'm getting the following queries:
SELECT * FROM A (correct)
SELECT * FROM B WHERE Id = @IdPar, @IdPar='00000000-0000-0000-0000-000000000000' (parameter value not correct, and only executed once).
When getting two result rows, I expect the second query to execute twice and I don't expect a Guid.Empty as parameter value.
Thanks again.