How to use multiple dataset fields in one table.
Example:
I have one table --Table1.
Two DataSets --DataSet1,DataSet2
Table1 refers DataSet1.I want to use DataSet2 field in Table1.It is taking SUM if did this but I don't need sum.
A table can only be associated with 1 dataset.|||thanx Adam.
Can you give me the solution
|||It depends on the data and what else you are doing in the report. What I've done in the past is either
combine the data into 1 dataset in the query or|||if you only want to use a SUM-Value from your second dataset,
this shouldnt be a problem
go to the field in your table where you want the SUM-Value
-> Expression -> Datasets -> <Dataset2> -> Sum(<yourValueToSum>)
this inserts a Sum-Function for your value over the scope of dataset 2
greets
|||you could do something like this
=Sum(Fields!fieldnam.Value, "Dataset Name")
and it would get the value from the specified dataset
