Calculations on a report (2 Viewers)
- Thread starter thebigman
- Start date
DHookom
Active member
- Local time
- Today, 02:44
- Joined
- Aug 7, 2024
- Messages
- 558
I'm not sure how we can help without seeing the complete expressions in you text boxes. Are the totals adding the names of text boxes from the detail section?
The use of many DSum()s doesn't look efficient to me. Your table structures or other may dictate this.
Also, the alignment (or lack of) and spacing is difficult for us suffering from OCD.
The use of many DSum()s doesn't look efficient to me. Your table structures or other may dictate this.
Also, the alignment (or lack of) and spacing is difficult for us suffering from OCD.
I've got the right help, but not help you are going to want to hear--I think you have set up your database tables incorrectly.
The little we have to go on raises a lot of red flags. The Detail section doesn't use any data from the report. It uses DSums which have their own data source. Further, DSums don't just retrieve data, they aggregate it which is odd for the Details section. Lastly, you've hard coded your categories into the report (e.g. Equipment, Vehicles, etc). That information should be stored in a table itself, not hard coded and extracted with a series of DSums.
The ultimate report you create should use neither Dsums nor hard coded labels in the Details section--it should pull of its data from the reports datasource.
Can you post a screenshot of your tables Relationships so we can see the structure of your tables?
The little we have to go on raises a lot of red flags. The Detail section doesn't use any data from the report. It uses DSums which have their own data source. Further, DSums don't just retrieve data, they aggregate it which is odd for the Details section. Lastly, you've hard coded your categories into the report (e.g. Equipment, Vehicles, etc). That information should be stored in a table itself, not hard coded and extracted with a series of DSums.
The ultimate report you create should use neither Dsums nor hard coded labels in the Details section--it should pull of its data from the reports datasource.
Can you post a screenshot of your tables Relationships so we can see the structure of your tables?
Similar threads
