PDF Template triple nesting error…maybe - Page 2

tomcollins945 · 04-18-2025 05:44 AM

I'm trying to add a "Catagories" heading to my equipment list in my quotes.

There are lots of other articles with similar questions but I can't get any of those solutions to work, and I think it's because I need 3 Start expressions, or 2 start expressions and 1 If expression, and that seems to exceed some limit.

I keep getting a silly error, "2 mismatched Starts and 2 mismatched Ends". 4 odd socks is just 2 pairs of socks!

There are Gigs, each gig has rooms, each room then has equipment. Each piece of equipment has a category, I want to clump the categories together, and put a heading at the top of each one:

Audio:

Speakers

Sounddesk

Lighting:

Stage light (each line also has QTY, Price, Days, Amount, Quote_notes, internal_notes...but I've removed all of that until i can get this to work)

Here's a piece of code that returns a list of the equipment:

<<Start: [GigID].[Related GigRooms]>>

<<[Room]>>

<<Start: OrderBy([Related GigEquipments], [Sort Order], FALSE)>>

<<[Name]>>

<<end>>

Sort Order is a legacy which I'll get rid of once I can get this grouping/heading thing to work

Here’s my latest attempt:

<<Start:[GigID].[Related GigRooms]>>

<<[Room]>>

<<Start: OrderBy([Related GigEquipments], [Category], FALSE, [Sort Order], FALSE)>>

<<If([_THISROW].[Category] <> [_PREVROW].[Category])>>

<<[Category]>>

<<Endif>>

<<[Name]>>

<<End>>

This throws this error:Error encountered in step with name [Step: Create Quote A]: Error: Task 'Step: Create Quote A' Body template. Found 2 unmatched 'Start', 2 unmatched 'End', 1 unmatched 'EndIf'. They are: <<Start:[GigID].[Related GigRooms]>>', '<<Start: OrderBy([Related GigEquipments], [Category], FALSE, [Sort Order], FALSE)>> ', '<<Endif>>', '<<End>>', '<<End>> Error: The document body is empty

Gemini and I have been going around in circles for some time, would love some help!