Survet 123 Summary Report Generation

[ChermaPandiyan]

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} ${/}

[abureaux]

It's kind of hard to know why the syntax error is occurring without seeing the XLSX. Any chance you can link it?

[ChermaPandiyan]

Hi,

Thanks for the reply. I have attached the xlsx. Please check it

[abureaux]

Thanks for providing this.

First observation: You have duplicate "name" entries. All name entries must be unique. Furthermore, if your "name" overlaps with a "reserved word", they you should change your "name". So long as you don't break formatting (I highly recommend when you copy-paste to paste as "text only"), duplicates are highlighted red, and reserved words have a green triangle in the upper left corner of the cell (examples below).

You should correct this issue before trying anything else as either of the above issues can result in unexpected behaviour.

EDIT: In case it was ambiguous, I did not see any reserved words being used in your XLSX. I was simply adding on that this was another thing to watch for when generating names.

As for the Feature Report, I think I understand better now. Okay, so you are using nested repeats. The parent repeat (in your case, ${Farmer_Details}) needs to be the first thing in that Feature Report table. Then, you can nest things inside that.