Report is creating a separate sheet for each record

llheath
Participant V

I am trying to create a report that creates a sheet with all the fields in a list.
My template looks like:
“EmployeeNumber”,“COMPANY”,“EmpEmail”,“MgrEmail”,“MMI EXT #”,“EMP LOCATION”
“<<[EmployeeNumber]>>”,"<<[COMPANY]>>","<<[EmpEmail]>>","<<[MgrEmail]>>","<<[MMI EXT #]>>","<<[EMP LOCATION]>>"
and when run the spreadsheets are created …but one per record. How do I loop? is it a start in the template?

0 2 132
2 REPLIES 2

Steve
Participant V

Thanks, problem solved. I was not getting anything when “ForEntireTable” was selected.
I realized if using ‘jEach Record’ you can prefer to field names in your body/subject etc. If using “EntireTable” you have to qualify each field with the table name.
thanks

Top Labels in this Space