Hi,
I have two datasets in my report and data is being displayed through a table. When I give expression like below:
=Format(Fields!InvDt.Value, "dsRepSalesReport_tblPrintSalesReport","dd/MMMyyyy")
It says there is Syntax error. If I remove
dsRepSalesReport_tblPrintSalesReport
part, there is no error.
1) Please advise how to wite the expression in format with aggregate expression.
2) If I write expression without
dsRepSalesReport_tblPrintSalesReport
part, my table repeats data and shows for all invoice. But when I add aggregate part,
dsRepSalesReport_tblPrintSalesReport
Table just shows one value several times.
Please advise how to handel with these two issues.
Thanks