Editing a PDF Template to group by a category and split to separate pages.

[Ron_Mansolo]

Attached is the view of my current pdf template. I have tried to separate the results by Job but without success.

Could use some help with this and maybe separating the job grouping by page.

[TeeSee1]

I believe you can do this by embedding <<START: SELECT...>><<END>>

<<START: SELECT(Job[id], TRUE)>>
  <<START:SELECT(TimeSheets[Id], [Timesheet Job] = [_THISROW-1].[id])>>
  Your table
  <<END>>
  insert a page break here
<<END>>

Also incorporate your start and end dates...

References:

Back-references within nested queries ([_THISROW-n])

Add page breaks in PDF attachments

[Ron_Mansolo]

Here is what I have now. An error says there is an unmatched <<END>> now.

[TeeSee1]

Template grammar seems to have some peculiar rules and you may have to tweak the placement of <<END>> a bit to get it right. Try putting it right after <<[ID].[Number of Hours]>> without a line break. You may also need to move the inner SELECT statement inside the table like you have in your original template.

I usually have to move them around a few time to get it right myself because I have found no document that explains exactly how you should write them.