Had a great time digging into the reporting tool but unsure how to get the example report below made.
The trouble is I have 37 nutrients to show and they do not fit horizontally on a page so the page needs to repeat three times before it starts the next days food as I can fit a third of the 37 nutrients to a page as per above example draft.
Needs to have:
1. Date category
2. Nutrient category x 3 with nutrients 1-12 ,14-25 , 26-37 as there are too many nutrients on a page. How do I do this part????
3. Meal Category
4. Detail section/group
I have played around with crosstabs but repeats the data too many times? Might be doing it wrong.
I have successfully made a simpler version that fits on a page, see below, but if I need to add more nutrients what is the best way to do this?