Personal tools

Difference between revisions of "14 Reports"

From TrueERP wiki

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