{{items.Count()}} in my template gives Unknown identifier 'items' error in excel output about closedxml.report HOT 8 CLOSED

Inside tables (ranges) you can use:

• the item variable to refer to the current row object
• the items variable to access the collection
• the index variable to get the serial number of the current object in the collection
  Here details

from closedxml.report.

@fingers10 Sorry for late answer.
Can you send your template?

from closedxml.report.

@fingers10 Sorry for late answer.
Can you send your template?

Here is the template
CustomerOrdersReport.xlsx

Thanks,
Abdul

from closedxml.report.

1. The range "Records" should also include the options column (Flat-tables). Now this used B7:F8, but should be A7:F8.
2. Out of the range "Records," you can reference it by name. I.e. you need to change the formula in G4 to {{Records.Count()}}

from closedxml.report.

Dear @b0bi79 ,

Thanks for the support. Point 2 worked. And for Point 1, I followed the template requirements in docs and I'm also aware of it. I thought I selected the correct range. But somehow missed it. Thanks for pointing out.

I still have on question as per point 2, if I need to change formula to {{Records.Count()}}, then where and when can I use {{items.Count()}} as shown in docs?

Also please share any info on next stable release, as I'm not able to use beta version in my production environment.

Thanks,
Abdul

from closedxml.report.

Any updates regarding the release?

from closedxml.report.

I'm waiting for the release of ClosedXML.

from closedxml.report.

Alright thanks. Let's close this issue. Thanks for the support and help.

from closedxml.report.