Joining two datasets to create a single tablix in report builder 3
mushcraft
I am attempting to join two datasets in to one tablix for a report. The second dataset requires a personID from the first dataset as its parameter.
If i preview this report only the first dataset is shown. but for my final result what i would like to happen is for each row of a student there is a rowgrouping (?) of that one students modules with their month to month attendance. Can this be done in report builder? 
Frank Goortani
The best practice here is to do the join within one dataset (i.e. joining in SQL)
But in cases that you need data from two separate cubes(SSAS) the only way is the following:
- Select the main dataset for the Tablix
Use the lookup function to lookup values from the second dataset like this:
=Lookup(Fields!ProductID.Value, Fields!ID.Value, Fields!Name.Value, "Product")Note: The granularity of the second dataset must match the first one.
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
Related
Related Related
- 1
Adding fields of two DataSets in a Tablix rdlc
- 2
Find average by joining two datasets
- 3
Joining two large datasets in RxJava
- 4
Joining two datasets with different classes
- 5
SSRS tablix split report into two sets of columns
- 6
SSRS tablix split report into two sets of columns
- 7
Alternative way of joining two datasets in SAS
- 8
Best strategy for joining two large datasets
- 9
Alternative way of joining two datasets in SAS
- 10
Best strategy for joining two large datasets
- 11
Joining two datasets on comma-delimited column
- 12
Joining multiple tables for a single report in Django
- 13
How to create a footer row for Tablix and repeat it in every page of report?
- 14
How to create a footer row for Tablix and repeat it in every page of report?
- 15
Create table report from joining table in MySQL
- 16
Why could joining two Datasets and saving it to text file fail with NullPointerException?
- 17
Report Builder 3 Date format
- 18
Joining two tables on the nearest single date
- 19
create files through terminal and joining two files in script python3
- 20
Joining datasets in SSRS
- 21
Joining two tables in Microsoft Report Viewer (SSRS 2012)
- 22
Create Expression in Report Builder 3.0 Report to sum a column
- 23
Adding subtotals to SSRS report tablix
- 24
Creating nested tablix in rdlc report
- 25
Merging two datasets conditional on 3 variables in SAS
- 26
linq SQL statements for joining two id with single list
- 27
Joining two tables, multiple rows into a single row different columns
- 28
SQL Inner joining a column from two tables with a single user id
- 29
joining two .xls file into a single .xls file with 2 sheets
Comments