Data Source column as Query Parameter

[chleroy]

Hi,

My environment specs are :

• Stimulsoft Reports.Fx for PHP2015.1
  Windows 7 - 64bit
  MySQL 5.6.15
  PHP 5.3

I've attached database and report samples.
My question is the following:

data source ds_a query:
select * from tbl_a;

data source ds_b query
select * from tbl_b where ref_a = @fk_a

fk_a is a parameter with an expression as a value: {ds_a.id_a}

the parameter only considers the first value of {ds_a.id_a}
and as a result ds_b doesn't have all the data it's supposed to.

I've already tried the 'Reconnect on Each Row' property like you suggested in this post
http://forum.stimulsoft.com/viewtopic.php?f=12&t=33819


Waiting for help PLZ

[Alex K.]

Hello,

Sorry, maybe we did not exactly understand your question. We don't understand your logic.
Can you please show us how it should look like in the report.
You can use the master-detail construction without any parameters in second datasource.

Thank you.

[chleroy]

Hope the screen caps will explain my issue.

[Alex K.]

Hello,

Please check the modified report in the attachment.

Thank you.

[chleroy]

Thank you for the reply,

I'm used to create relationships between two data source like you did in the modified sample.
The problem is when table b has for the least hundreds of thousand of records.

I still have to load all of those records before the relationship filter applies.
And it makes the report run slow.

would it be possible for data source b to take foreign key field in data source a as a parameter
and execute for each value of it then combine the results

It's the one and only issue I came along so fare in testing the product witch by the way is wonderful.

Thanks again

[Alex K.]

Hello,

Please try to use the ReconnectOnEachRow property.
Please check the modified report in the attachment.

Thank you.

[facsistemas]

Hello,
I have the same problem of the topic above , I am unable to link the parameter with the column of another data source !
Can you help me?

[facsistemas]

Hello,

I have the same problem of the topic above , I am unable to link the parameter with the column of another data source !
Can you help me?

fac_Rel_RelatorioInconsistentes.mrt

parameter

(80.3 KiB) Downloaded 300 times

[Alex K.]

Hello,

Please try to set the ReconnectOnEachRow property to true for the grau data source.

If the issue still present, please send us a test data for your report.
Thank you.

[facsistemas]

Unfortunately still did not work , I'm sending the report and a test database.