I would like to create a few report templates but not sure how to do it.
I tried this:
<<Start: Evac Center Personnel[Contact External Id]>>
<>
<<_ComputedName2>>
<>
but get this error:
Error: โErrorsโ: โError: Workflow rule โEvac Center Personnel Reportโ action โAction 1โ Attachment template. Found 1 unmatched โStartโ. They are: <p class=โc0โ><span class=โc2โ><<Start:Evac Center Personnel[Contact External Id]>>
โ,Ideally we want a report that is grouped by the Evac Center Location, then by role, and then lists (numbered list) the personnel assigned to that role.
Is this possible and if so does someone have a template or can you point me in the right direction?
Thank you,
@Steve - Iโve looked at that documentation many times. I just donโt get it.
I got rid of the error, but my struggle is - is it possible to do a group, then a subgroup, then an order list in a report template?
Atwater School
Position A
Booker School
and so onโฆ
Iโm afraid you canโt generate grouped lists if you need them to by dynamic. Though if your groups are fixed likeโฆ they are always the same, you can add more Start: & End lists into your template. In your case it would mean fixed locationsโฆ then fixed roles etc.
Locations and roles are static, the assigned people are dynamic. Does that work?
So in the template instead of pulling that info in via <>, Iโm writing it directly into the template and just pulling <>?? Want to make sure I understand you.
LOCATION A, Role A
<<Start: SELECT(Table[Key],AND([Location]=โLocation Aโ,[Role]=โAโ))>>
<<[People]>>
<< End >>
LOCATION A, Role B
<<Start: SELECT(Table[Key],AND([Location]=โLocation Aโ,[Role]=โBโ))>>
<<[People]>>
<< End >>
Thank you!
Youโre welcome
User | Count |
---|---|
36 | |
32 | |
30 | |
18 | |
16 |