CODEWITHSUNDEEP
reporting-servicesdatasetgroupinglookup
bo realy
bo realy

Reputation: 1

SSRS group on lookup field

I have an ssrs matrix and have a lookup to another dataset2 field (Jurisdiction)

I want to row group by this dataset2 Jurisdiction.

The problem is that the tablix will work on a non group lookup but will not allow me to group on and display the dataset jurisdiction field.

is this possible in ssrs? Thanks

Upvotes: 0

Views: 333

Answers (1)

StevenWhite
StevenWhite

Reputation: 6034

As a general rule, it's much better to join subqueries in the SQL rather than using the Lookup function. Both in terms of efficiency and also avoiding the limitation you described in the report design.

If the datasets are truly different data sources, consider using an ETL process to combine them into a single table for the report to use as its dataset.

Upvotes: 0

Related Questions