Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
I have 3 Tables Sales Header , Sales Line & 1 Sample Table. I have Sales Header at Top and then belw the other 2 tables. I want to display Sales Header & Line Data in 1 Table . Sample & Sales Header data in another separate table. Sales Header XY field is linked with Document no of Sample Table
Create a Report like this:
In your layout... Filter one tablix for "IsSalesLine is true" and the secound for "IsAdditionalData is true"
First 2 are o.k but how will the data come from Third table . U have given integer Datasource. Data will be similar to Lines table. How the relation will be developed between Integer & Header table if used as u mentioned.
What will be in the DataItemLinkReference & DataItemLink of integer DataSource.
Secondly Dennis can u guide me why u set filter in Tablix properties and DataSource Properties. What is the purpose.
i choosed the integer table because i dont have your "1 sample table" ...
add your "sample table".. connect it with the header - like u have done with the lines.
after u have done this take a look at the RecordSet of the report, maybe you will understand why you filter a tablix.
Can u pls tell me where to see the recordset.