I'm trying to design a report is report designer that will not only give me a list of multiple skills over multiple days, but give me subtotals for each day. I've gotten so far as to program the report to list each skill's numbers for each day, and I can get a grand total for the whole thing, but I really need subtotals in the middle. Is this something that CMS can even do?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
CMS Report Designer -Subtotals
- Thread starter marcell55
- Start date
- Thread starter
- #2
How about creating eight different tables all with there own queries, one for each day and the eighth as a grand total.
A limitation would be this would only work for a fixed seven day period. (Input would be a single date with each table offset)
Have you tried ODBC as an option, you would be able to create far more complex reports in something like Access or Excel than in CenterView.
A limitation would be this would only work for a fixed seven day period. (Input would be a single date with each table offset)
Have you tried ODBC as an option, you would be able to create far more complex reports in something like Access or Excel than in CenterView.
- Status
Similar threads
- Locked
- Question
- Locked
- Question