I want to create tablix report in the following format:
Where Customer / Orders / Inquiries are seperate tables with customer ID as primary key. How can I create this kind of tablix report where I can display all information in single row by customer ID?
If you don't want to create one dataset that joins all the tables together you could create multiple datasets one for customer, orders, and inquiries and use the lookup and lookupset function by passing in the CustomerID to each. You would paste expressions that look similar to these in the textboxes of the table
Lookup(source_expression, destination_expression, result_expression, dataset) LookupSet(source_expression, destination_expression, result_expression, dataset)
=JOIN(LookupSet(Fields!CustomerID.Value, Fields!CustomerID.Value, Fields!OrdersthisQuarter.Value, "orders"),"")
=JOIN(LookupSet(Fields!CustomerID.Value, Fields!CustomerID.Value, Fields!InquiriesthisQuarter.Value, "inquiries"),"")
=Lookup(Fields!CustomerID.Value, Fields!CustomerID.Value, Fields!Contact.Value, "orders")
=Lookup(Fields!CustomerID.Value, Fields!CustomerID.Value, Fields!Region.Value, "inquiries")
