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?