Page 2 of 2

Re: Relation across multiple databases with parameters

Posted: Thu Sep 13, 2012 12:54 pm
by 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.

Re: Relation across multiple databases with parameters

Posted: Fri Sep 14, 2012 10:42 am
by Alex K.
Hello,

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

Thank you.

Re: Relation across multiple databases with parameters

Posted: Wed Sep 19, 2012 8:42 am
by 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?

Re: Relation across multiple databases with parameters

Posted: Wed Sep 19, 2012 10:55 am
by Alex K.
Hello,

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

Thank you.

Re: Relation across multiple databases with parameters

Posted: Fri Sep 21, 2012 11:16 am
by 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!

Re: Relation across multiple databases with parameters

Posted: Fri Sep 21, 2012 1:00 pm
by Alex K.
Hello,

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