Relation across multiple databases with parameters

[jcc_colin]

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.

[Alex K.]

Hello,

Sorry, maybe we did not exactly understand your question. Could you explain your issue in more details?

Thank you.

[jcc_colin]

So you've changed nothing in Stimulsoft2.mrt and you see that? Because I open it here with the same data and I see in the left column two empty Guid's. While your output is exactly what I need.

I'm using version 2012.08.24.

Only difference I see is that your version is either not the WPF version or it is just not using the ribbon interface?

[Alex K.]

Hello,

Please check the Stimulsoft2_modified.mrt which we sent the several post ago.

Thank you.

[jcc_colin]

OK, thanks, working now for us. This might be what we're looking for. And will try with the new 2012.2 release too, nice timing!

[Alex K.]

Hello,

We are always glad to help you!
Let us know if you need any additional help.