- Introduction to WorkXpress
- Building Your Application
- Examples and Best Practices
- Technical Manual
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
how:reports [2012/09/05 14:47] shyser |
how:reports [2012/09/06 15:09] shyser |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | * [[:reports:invoice|How do I create an invoice?]] | + | Here are many common questions about creating and troubleshooting reports. |
| + | |||
| + | * [[invoice|How do I create an invoice?]] | ||
| * [[:reports:repeating_subreports|Why are subreports repeating multiple times rather than just showing once?]] | * [[:reports:repeating_subreports|Why are subreports repeating multiple times rather than just showing once?]] | ||
| * [[:reports:totals_in_document_report|How can I get a total to show in a document-style report?]] | * [[:reports:totals_in_document_report|How can I get a total to show in a document-style report?]] | ||
| - | |||
| - | |||
| - | {{anchor:repeating_subreports}}\\ | ||
| - | **Why are subreports repeating multiple times rather than just showing once?** | ||
| - | |||
| - | Subreports will always repeat the number of times as records there are in the query. As such, you can't use subreports for calculating totals. You have to precalculate them into a field, then reference that field in the report. I would just put the actions to calculate these totals on the same link that runs the report so you don't have to worry about maintaining those numbers under all various circumstances. | ||
| - | |||
| - | {{anchor:totals_in_document_report}}\\ | ||
| - | **How can I get a total to show in a document-style report?** | ||
