Hi to All,
I have to create a summary report for as mentiond below.
Table 1: Farmer_Details
Table 2: Sales_Details (1 to Many relationship with Farmer_Details)
I have to create a sales report.
The Farmer Name to be get from the Farmer_Details table. rest of the information from the sales_details table. All the reports properly generate from the sales_details table.
But for the Famer Name
The syntax "${Farmer_Details.Farmer_Name}" not accept and shows the below error.
"Error: An error occurred when checking the report template. Failed to parse ${Farmer_Details.Farmer_Name} since Farmer_Name cannot be found in the current parsing scope."
I tried with another option
${#Farmer_Details}
${Farmer_Name}
${/Farmer_Details}
In this scenario, the syntax accpet but report generated as blank.
And also i want to print a serial No for each record as well.
Can you please give your valuble feedback on this.
The full Syntax is
Total Sales Count: ${Sales_Details|stats:"count,OBJECTID"} Nos
Total Bag Count : ${Sales_Details|stats:"sum,Bag_No"} Nos
Total Weight : ${Sales_Details|stats:"sum,Bag_Weight” | format:"0.##"} Kgs
Date of Entry | Name of the Farmer | Date of Purchase | Number of Bags | Total Weight (KG) | Collected By |
${#Sales_Details|orderByFields:"created_date ASC"} ${created_date | format:"DD/MM/YY"} | ${Farmer_Details.Farmer_Name} | ${Sale_Date | format:"DD/MM/YY"} | ${Bag_No} | ${Bag_Weight} | ${created_user} ${/} |
It's kind of hard to know why the syntax error is occurring without seeing the XLSX. Any chance you can link it?