Hi friends,
hope everyone had a good weekend.
I have one requirement to call the value from different datasets within the same report.But the value should be returned based on multiple column join values.
Ex: Main dataset query
SELECT * FROM table a
WHERE a.ChargeDate>=@TransactionDateFrom AND a.ChargeDate<=@TransactionDateTo AND a.DebtorID= @DebtorID
dataset 2:
SELECT * FROM table b
WHERE b.ChargeDate>=@GLStartYearDate AND b.ChargeDate<=@TransactionDateTo AND b.DebtorID= @DebtorID
here i have tried to create a calculated field by joining multiple columns to use the lookup to display the value from dataset 2
My approach:
calculated field in main dataset as Join1
=Parameters!TransactionDateFrom.Value + "||" + Parameters!TransactionDateTo.Value + "||" + Parameters!DebtorID.Value
calculated field in main dataset 2 as JoinArrears
=Parameters!GLStartYearDate.Value + "||" + Parameters!TransactionDateTo.Value + "||" + Parameters!DebtorID.Value
to display:
=LookupSet(Fields!Join1.Value, Fields!JoinArrears.Value, AllocatedAmount.Value, "dataset2")
but it is giving error..Please suggest me any solution for this.
Thanks,
sam.