Personal tools

Difference between revisions of "14 Reports"

From TrueERP wiki

Jump to: navigation, search
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<menu align="center" name="myMenu">
+
<menu name="myMenu" align="center">
 
Answers=
 
Answers=
[[1 Report Types]]
+
[[1. Report Types]]
[[2 Report Selector]]
+
[[2. Report Selector]]
[[3 SQL Writer]]
+
[[3. Update Batch]]
[[4 Radio Buttons]]
+
[[4. BOM Update]]
[[5 Date Range]]
+
[[5. Batch Reports]]
[[6 Default Date Range]]
+
[[6. Radio Buttons]]
[[7 F5 F6 and F7]]
+
[[7. Date Ranges]]
[[8 Drillable Reports]]
+
[[8. Default Date Range]]
[[9 Printable Report]]
+
[[9. Drillable Reports]]
[[10 Customisation]]
+
[[10. Customisation]]
[[11 My Reports]]
+
[[11. My Reports]]
[[12 Average, Max Etc]]
+
[[12. Printable Reports]]
[[13 Lean Report Builder]]
+
[[13. Which Columns]]
[[14 Batches]]
+
[[14. Charts]]
[[15 Update Batch]]
+
[[15. Schedule]]
[[16 Speed v Functionality]]
+
[[16. Report Writer]]
[[17 Charts]]
+
[[17. View Toolbars]]
[[18 SQL Writer]]
+
[[18. New Template]]
[[19 Easy Copy]]
+
[[19. Easy Copy]]
[[20 New SQL Report]]
+
[[20. Easy Layout]]
[[21 View Toolbars]]
+
[[21. New SQL Report]]
 
+
[[22. Learn Report Builder]]
 
+
 
+
 
</menu>
 
</menu>
  
== Overview ==
+
== Overview ==
 
+
  
+
Reports Training  
Reports Training
+
  
 +
<br>
  
 +
Company:___________________________ Signed:____________________________
  
Company:___________________________      Signed:____________________________
+
Name:___________________ Position:______________ Date: _____________
  
Name:___________________    Position:______________     Date: _____________
+
Trainee to complete: Please tick
  
Trainee to complete:  Please tick
+
1. [ ] Report Types - Do you know what the two types of reports are?
  
1. [   ] Report Types
+
2. [ ] Report Selector - Do you know what the Report Selector is and how to access it?  
Do you know what the two types of reports are?
+
  
2. [   ] Report Selector
+
3. [ ] Update Batch - Where do you run this function from?  
Do you know what the Report Selector is and how to access it?
+
  
3. [   ] SQL Writer
+
4. [ ] BOM Update - Do you fully understand the BOM update options when running a Batch Update?  
Do you know what the SQL writer is and how to access it?
+
  
4.  [  ] Radio Buttons
+
5. [ ] Batch Reports - Where can you see when the last Batch Update was run?  
Do you Understand what the labelled radio buttons on the left hand side of the Report Selector are for?
+
+
5. [   ] Date Ranges
+
Do you understand what the date ranges are for on the main Report Selector?
+
  
6. [   ] Default Date Range
+
6. [ ] Radio Buttons - Do you Understand what the labelled radio buttons on the left hand side of the Report Selector are for?  
Do you understand where to set the default date range?
+
  
7. [   ] F5, F6 and F7
+
7. [ ] Date Ranges - Do you understand what the date ranges are for on the main Report Selector?
Do you know how to use the F5,F6,F7 searching features? Also how to use the search box on the  
+
main screen.
+
  
8. [   ] Drillable Reports
+
8. [ ] Default Date Range - Do you understand where to set the default date range?  
Can you drill into the transactions on these types of reports and lists?
+
  
9. [   ] Printable Reports
+
9. [ ] Drillable Reports - Can you drill into the non summarised transactions on these types of reports and lists?  
Do you know how to get an average, max, min or sum of a column in a printable report?
+
  
10.[   ] Customisation
+
10.[ ] Customisation - Can you customise the appearance of drillable/printable reports generated from the lists eg. Invoice List?
Can you customise the appearance of drillable/printable reports generated from the lists.  
+
Sales Order List, Invoice List, Purchase Orders List, etc?
+
  
11.[   ] My Reports
+
11.[ ] My Reports - Do you know how to create a report in the "My Reports" area from this customised report?  
Do you know how to create a report in the "My Reports" area from this customised report?  
+
  
12.[   ] Average, Max etc
+
12.[ ] Printable Reports - Do you know how to get an average, max, min or sum of a column in a printable report?  
Can you adust the total from "Sum" to "Average"?  
+
  
13.[   ] Learn Report Builder
+
13.[ ] Which Columns - Can you select which columns are sent to print?  
Can you find the Report builder manual?  
+
  
14.[   ] Batches
+
14.[ ] Charts - Do you know how to create a chart from any report?  
Why do we recommend that you have this function turned on?  
+
  
15.[   ] Update Batch
+
15.[ ] Schedule - Do you know how to Schedule a report to automatically email on a set date or dates?
Where do run this function from?  
+
  
16.[   ] Speed v Functionality
+
16.[ ] Report Writer - Do you know how to use the SQL writer to customise templates?  
Why do you lose speed when you gain functionality?  
+
  
17.[   ] Charts
+
17.[ ] View Toolbars - Have you turned on all of the tool bars for the Template design screen?  
Do you know how to create a chart from any report?
+
  
18.[   ] SQL Writer
+
18.[ ] New Template - Can you create a new report?  
Do you know how to use the SQL writer to create custom templates?
+
  
19.[   ] Easy Copy
+
19.[ ] Easy Copy - Where do you copy ready made SQL strings?  
Where do you copy ready made SQL strings?  
+
  
20.[   ] New SQL Report
+
20.[ ] Easy Layout - How do you load an existing layout design over a new template?
Can you use the SQL wizard to create a report?  
+
  
21.[   ] View Toolbars
+
21.[ ] New SQL Report - Can you use the SQL Helper to create a report?  
Have you turned on all of the tool bars for the SQL design screen?  
+
  
Notes:
+
22.[ ] Learn Report Builder - Can you find the Report Builder manual?  
Are there any aspects in this area that more training would be useful?
+
  
_____________________________________________
+
<br>
_____________________________________________
+
_____________________________________________
+
_____________________________________________
+
_____________________________________________
+
_____________________________________________
+
_____________________________________________
+

Latest revision as of 18:49, 9 January 2015

Overview

Reports Training


Company:___________________________ Signed:____________________________

Name:___________________ Position:______________ Date: _____________

Trainee to complete: Please tick

1. [ ] Report Types - Do you know what the two types of reports are?

2. [ ] Report Selector - Do you know what the Report Selector is and how to access it?

3. [ ] Update Batch - Where do you run this function from?

4. [ ] BOM Update - Do you fully understand the BOM update options when running a Batch Update?

5. [ ] Batch Reports - Where can you see when the last Batch Update was run?

6. [ ] Radio Buttons - Do you Understand what the labelled radio buttons on the left hand side of the Report Selector are for?

7. [ ] Date Ranges - Do you understand what the date ranges are for on the main Report Selector?

8. [ ] Default Date Range - Do you understand where to set the default date range?

9. [ ] Drillable Reports - Can you drill into the non summarised transactions on these types of reports and lists?

10.[ ] Customisation - Can you customise the appearance of drillable/printable reports generated from the lists eg. Invoice List?

11.[ ] My Reports - Do you know how to create a report in the "My Reports" area from this customised report?

12.[ ] Printable Reports - Do you know how to get an average, max, min or sum of a column in a printable report?

13.[ ] Which Columns - Can you select which columns are sent to print?

14.[ ] Charts - Do you know how to create a chart from any report?

15.[ ] Schedule - Do you know how to Schedule a report to automatically email on a set date or dates?

16.[ ] Report Writer - Do you know how to use the SQL writer to customise templates?

17.[ ] View Toolbars - Have you turned on all of the tool bars for the Template design screen?

18.[ ] New Template - Can you create a new report?

19.[ ] Easy Copy - Where do you copy ready made SQL strings?

20.[ ] Easy Layout - How do you load an existing layout design over a new template?

21.[ ] New SQL Report - Can you use the SQL Helper to create a report?

22.[ ] Learn Report Builder - Can you find the Report Builder manual?