Menu
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?
541
At the top-right, from the list, select Join Dataset. In the Data Set Name box, type a name for the Join data set. In the Query box, enter a SQL query that combines fields from both data sets.
Make a new report that will become your main report. Then, in the body of the main report instead of inserting a table or a textbox you can insert a subreport. Insert three subreports and then go into the properties of each to link them to each report you want to include in the main report.
To merge a block of cells, merge the cells horizontally first. After all cells have been merged into a single cell in each row, select adjacent cells (you can select all adjacent cells in a column) and merge them. In the tablix body area, cells can only be merged horizontally.
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:
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.
126
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
