Click here to Skip to main content
15,906,816 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi,
I have two datasets in my report and data is being displayed through a table. When I give expression like below:
VB
=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
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900