I made a spreadsheet with all the data, but I am not great at pivot tables. I tried to attach the Excel document, but it is not allowed (I need permission to download it). The report consists of 12 sub-forms to make it look like one form. A copy of the report showing the columns and rows is already in the system and attached. You can see on page 5 when we started to add more actions in week 4, where the problem arises. Since the prior weeks didn't have the information, they are not showing. Only a real crosstab will fix this. I did pull all the data into a spreadsheet, but I am not good at pivot tables. Let me know what else might help here.
Need to print a crosstab report without complete data
- Thread starter Lkwdmntr
- Start date
DHookom
Active member
- Local time
- Today, 09:22
- Joined
- Aug 7, 2024
- Messages
- 387
One of your issues is the lack of normalization. You have activities and engagements in fields across rather than creating new related records. I am attempting to normalize tblChallenges with a union query. It will take a little work.
How do you calculate Planned, Engagement, and Achievement values?
How do you calculate Planned, Engagement, and Achievement values?
Hi there! Again, thank you for all your help with this. Normalization has been a challenge. This project changed weekly, and I had to accommodate my boss's crazy way of thinking. It has been quite the road and like I said in a previous communication, I think this is more of a hobby for her. She is very sweet and want to make her happy. So...I go forward with a smile and do my best to accommodate her hopes and wishes.
To answer your question. I calculate all the values when the client fills out there reporting forms. That data is attached to the tblChallenges table. When they check the box, the calculations is gathered with an IIF statement based on whether it is a Start Time or Activity Challenge. You can find the calculations in the qlkpStandardActionPointsByLoop_Wk_01, 02, 03...
That should answer your question. Thanks
To answer your question. I calculate all the values when the client fills out there reporting forms. That data is attached to the tblChallenges table. When they check the box, the calculations is gathered with an IIF statement based on whether it is a Start Time or Activity Challenge. You can find the calculations in the qlkpStandardActionPointsByLoop_Wk_01, 02, 03...
That should answer your question. Thanks
DHookom
Active member
- Local time
- Today, 09:22
- Joined
- Aug 7, 2024
- Messages
- 387
I’m traveling out of town this week without a laptop so won’t be able to reply. Did the PDF report pages correspond with the desired output based on the data in the file you provided? If not, could you provide files that align?
