- Addition or deduction of selected columns
- Interchange the columns
- Change the size(width) of the column
> View settings
1.Go to the specific report for which a different view needs to be created and click on tools button found on the top right of the screen.
For e.g., HRMS Module> Late Arrival Report The report gets displayed on the screen and Click
2.Clickview: this will show the different views already created and available for that report. If no one has created any view this will show the only view with the standard format available in the system.
3.Select the specific view. This will display the report in HTML format on the screen. This view can be exported in CSV or PDF and saved for reference & comparison with the new view that is going to be created.
4.To create a new view for the report - Click view settings.
The lightbox opens up. The already created views are listed here.
(a)Click the Add button to create the new view.
(b) View Name: Enter the ViewName for e.g., Employee blood groups, Employeewise later arrival, depthwise late arrival, etc.
(c) Remarks: The information like the purpose of the report or the requester of the report with date etc, can be entered here.
(d) View type: Select Grid.
(e) Show Display fields: select this check box
The Grid displayed below will show all the fields in the existing view in the same order displayed.
(b) Click Deselect all: This should be done to undo the existing view settings.
(c) Name: The names of the columns at the back end.
(d) Display Name: The names of the columns displayed in the report.
(c) Now Select the checkboxes under the Display to select the columns required in the new view and change the names to be displayed if required.
(d) Other options available by selecting the checkboxes under them are.
M- Merge
G- Grouping
ST-Subtotal
GT-Grand total
(e) Click Advanced. This displays the width & format in the grid.
Width- To change the size of the column
Format - To change the order of the columns as required.
5.Click the Save button.
6. Wait till the popup appears on the screen to confirm that the view is created successfully.
Contents
Revisions
- June 15, 2021 @ 11:06:42 [Current Revision] by arul
- June 15, 2021 @ 11:06:42 by arul
- June 15, 2021 @ 11:04:51 [Autosave] by arul
- June 12, 2021 @ 11:02:43 by arul
- June 12, 2021 @ 09:41:49 by arul
- June 12, 2021 @ 09:10:20 by arul
- June 12, 2021 @ 08:39:54 by arul
- June 12, 2021 @ 07:10:16 by arul
- June 12, 2021 @ 05:34:00 by arul
- June 12, 2021 @ 05:29:13 by arul
- June 12, 2021 @ 04:46:59 by arul
- June 12, 2021 @ 00:41:24 by arul
- June 12, 2021 @ 00:32:29 by arul
- June 11, 2021 @ 23:54:14 by arul
- May 31, 2021 @ 10:37:51 by arul
Revision Differences
| June 15, 2021 @ 11:04:51 [Autosave] | Current Revision | ||
|---|---|---|---|
| Content | |||
| Deleted: <strong> | Added: <strong>Dynamic Report views creation</strong> | ||
| Unchanged: The reports are normally available in a standard format in the ERP with all relevant fields useful for the report. | Unchanged: The reports are normally available in a standard format in the ERP with all relevant fields useful for the report. | ||
| Unchanged: Depending on our requirement & purpose we can create different views of the same report. This is called Dynamic Report views creation. | Unchanged: Depending on our requirement & purpose we can create different views of the same report. This is called Dynamic Report views creation. | ||
| Unchanged: For e.g., Employee details report - The existing report will contain many columns like Empcode, EmpName, address, mob no, email I'd, father name, blood group, etc. | Unchanged: For e.g., Employee details report - The existing report will contain many columns like Empcode, EmpName, address, mob no, email I'd, father name, blood group, etc. | ||
| Unchanged: Suppose we need to provide the contact details of the employees to the nearest blood bank we will require a report with only selected fields like Empname, Blood group, Mob No. | Unchanged: Suppose we need to provide the contact details of the employees to the nearest blood bank we will require a report with only selected fields like Empname, Blood group, Mob No. | ||
| Unchanged: In such cases, the Dynamic Report views creation comes into play. | Unchanged: In such cases, the Dynamic Report views creation comes into play. | ||
| Unchanged: <strong>Benefits of Dynamic Report view creation: </strong> | Unchanged: <strong>Benefits of Dynamic Report view creation: </strong> | ||
| Unchanged: The following can be done in the new view report | Unchanged: The following can be done in the new view report | ||
| Unchanged: <ul> | Unchanged: <ul> | ||
| Unchanged: <li>Addition or deduction of selected columns</li> | Unchanged: <li>Addition or deduction of selected columns</li> | ||
| Unchanged: <li>Interchange the columns</li> | Unchanged: <li>Interchange the columns</li> | ||
| Unchanged: <li>Change the size(width) of the column</li> | Unchanged: <li>Change the size(width) of the column</li> | ||
| Unchanged: </ul> | Unchanged: </ul> | ||
| Unchanged: <strong>Steps involved:</strong> | Unchanged: <strong>Steps involved:</strong> | ||
| Unchanged: (A) Naming the new view | Unchanged: (A) Naming the new view | ||
| Unchanged: (B) Selecting the fields for the new view | Unchanged: (B) Selecting the fields for the new view | ||
| Unchanged: (C)Ordering the fields | Unchanged: (C)Ordering the fields | ||
| Unchanged: (D)Sizing the fields. | Unchanged: (D)Sizing the fields. | ||
| Unchanged: <strong>How to create the dynamic report views?</strong> | Unchanged: <strong>How to create the dynamic report views?</strong> | ||
| Unchanged: <strong>Path: Module > Reports > Select the specific report ><a href="http:// help.goodbookserp.com/wp- content/uploads/ 2015/12/settings.png"><img class="alignnone size-full wp-image-5788" src="http://help.goodbookserp.com/ wp-content/uploads/2015/12/ settings.png" alt="settings" width="41" height="20" /></a>> View settings</strong> | Unchanged: <strong>Path: Module > Reports > Select the specific report ><a href="http:// help.goodbookserp.com/wp- content/uploads/ 2015/12/settings.png"><img class="alignnone size-full wp-image-5788" src="http://help.goodbookserp.com/ wp-content/uploads/2015/12/ settings.png" alt="settings" width="41" height="20" /></a>> View settings</strong> | ||
| Unchanged: 1.Go to the specific report for which a different view needs to be created and click on tools <a href="http:// help.goodbookserp.com/wp- content/uploads/ 2015/12/settings.png"><img class="alignnone size-full wp-image-5788" src="http://help.goodbookserp.com/ wp-content/uploads/2015/12/ settings.png" alt="settings" width="41" height="20" /></a> button found on the top right of the screen. | Unchanged: 1.Go to the specific report for which a different view needs to be created and click on tools <a href="http:// help.goodbookserp.com/wp- content/uploads/ 2015/12/settings.png"><img class="alignnone size-full wp-image-5788" src="http://help.goodbookserp.com/ wp-content/uploads/2015/12/ settings.png" alt="settings" width="41" height="20" /></a> button found on the top right of the screen. | ||
| Unchanged: For e.g., HRMS Module> Late Arrival Report The report gets displayed on the screen and Click <a href="http:// help.goodbookserp.com/wp- content/uploads/ 2015/12/settings.png"><img class="alignnone size-full wp-image-5788" src="http://help.goodbookserp.com/ wp-content/uploads/2015/12/ settings.png" alt="settings" width="41" height="20" /></a> | Unchanged: For e.g., HRMS Module> Late Arrival Report The report gets displayed on the screen and Click <a href="http:// help.goodbookserp.com/wp- content/uploads/ 2015/12/settings.png"><img class="alignnone size-full wp-image-5788" src="http://help.goodbookserp.com/ wp-content/uploads/2015/12/ settings.png" alt="settings" width="41" height="20" /></a> | ||
| Unchanged: <a href="https:/ /help.goodbookserp.com/wp- content/uploads/ 2021/06/Dview_ 04-1.png"><img class="size-full wp-image-13929 aligncenter" src="https:// help.goodbookserp.com/wp- content/uploads/ 2021/06/Dview_04-1.png" alt="" width="153" height="366" /></a> | Unchanged: <a href="https:/ /help.goodbookserp.com/wp- content/uploads/ 2021/06/Dview_ 04-1.png"><img class="size-full wp-image-13929 aligncenter" src="https:// help.goodbookserp.com/wp- content/uploads/ 2021/06/Dview_04-1.png" alt="" width="153" height="366" /></a> | ||
| Unchanged: 2.Click<strong>view: this will show the different views already created and available for that report.</strong> If no one has created any view this will show the only view with the standard format available in the system. | Unchanged: 2.Click<strong>view: this will show the different views already created and available for that report.</strong> If no one has created any view this will show the only view with the standard format available in the system. | ||
| Unchanged: <a href="https:/ /help.goodbookserp.com/wp- content/uploads/ 2021/06/Dview_ 07.png"><img class="size-full wp-image-13932 aligncenter" src="https:// help.goodbookserp.com/wp- content/uploads/ 2021/06/Dview_07.png" alt="" width="386" height="412" /></a> | Unchanged: <a href="https:/ /help.goodbookserp.com/wp- content/uploads/ 2021/06/Dview_ 07.png"><img class="size-full wp-image-13932 aligncenter" src="https:// help.goodbookserp.com/wp- content/uploads/ 2021/06/Dview_07.png" alt="" width="386" height="412" /></a> | ||
| Unchanged: 3.Select the specific view. This will display the report in HTML format on the screen. This view can be exported in CSV or PDF and saved for reference & comparison with the new view that is going to be created. | Unchanged: 3.Select the specific view. This will display the report in HTML format on the screen. This view can be exported in CSV or PDF and saved for reference & comparison with the new view that is going to be created. | ||
| Unchanged: 4.To create a new view for the report - Click <strong>view settings. </strong> | Unchanged: 4.To create a new view for the report - Click <strong>view settings. </strong> | ||
| Unchanged: The lightbox opens up. The already created views are listed here. | Unchanged: The lightbox opens up. The already created views are listed here. | ||
| Unchanged: <a href="https:/ /help.goodbookserp.com/wp- content/uploads/ 2021/06/Dview_ 02-1.png"><img class="alignnone size-full wp-image-13924" src="https:// help.goodbookserp.com/wp- content/uploads/ 2021/06/Dview_02-1.png" alt="" width="1311" height="175" /></a> | Unchanged: <a href="https:/ /help.goodbookserp.com/wp- content/uploads/ 2021/06/Dview_ 02-1.png"><img class="alignnone size-full wp-image-13924" src="https:// help.goodbookserp.com/wp- content/uploads/ 2021/06/Dview_02-1.png" alt="" width="1311" height="175" /></a> | ||
| Unchanged: (a)Click the <strong>Add</strong> button to create the new view. | Unchanged: (a)Click the <strong>Add</strong> button to create the new view. | ||
| Unchanged: <a href="https:/ /help.goodbookserp.com/wp- content/uploads/ 2021/06/Dview_ 05-1.png"><img class="alignnone size-full wp-image-13949" src="https:// help.goodbookserp.com/wp- content/uploads/ 2021/06/Dview_05-1.png" alt="" width="875" height="524" /></a> | Unchanged: <a href="https:/ /help.goodbookserp.com/wp- content/uploads/ 2021/06/Dview_ 05-1.png"><img class="alignnone size-full wp-image-13949" src="https:// help.goodbookserp.com/wp- content/uploads/ 2021/06/Dview_05-1.png" alt="" width="875" height="524" /></a> | ||
| Unchanged: (b) <strong>View Name</strong>: Enter the <strong>ViewName</strong> for e.g., Employee blood groups, Employeewise later arrival, depthwise late arrival, etc. | Unchanged: (b) <strong>View Name</strong>: Enter the <strong>ViewName</strong> for e.g., Employee blood groups, Employeewise later arrival, depthwise late arrival, etc. | ||
| Unchanged: (c) <strong>Remarks: </strong>The information like the purpose of the report or the requester of the report with date etc, can be entered here. | Unchanged: (c) <strong>Remarks: </strong>The information like the purpose of the report or the requester of the report with date etc, can be entered here. | ||
| Unchanged: (d) <strong>View type:</strong> Select <strong> Grid</strong>. | Unchanged: (d) <strong>View type:</strong> Select <strong> Grid</strong>. | ||
| Unchanged: (e) <strong>Show Display fields:</strong> select this check box | Unchanged: (e) <strong>Show Display fields:</strong> select this check box | ||
| Unchanged: The Grid displayed below will show all the fields in the existing view in the same order displayed. | Unchanged: The Grid displayed below will show all the fields in the existing view in the same order displayed. | ||
| Unchanged: (b) Click <strong>Deselect all:</strong> This should be done to undo the existing view settings. | Unchanged: (b) Click <strong>Deselect all:</strong> This should be done to undo the existing view settings. | ||
| Unchanged: (c) <strong>Name:</strong> The names of the columns at the back end. | Unchanged: (c) <strong>Name:</strong> The names of the columns at the back end. | ||
| Unchanged: (d) <strong>Display Name</strong>: The names of the columns displayed in the report. | Unchanged: (d) <strong>Display Name</strong>: The names of the columns displayed in the report. | ||
| Unchanged: (c) Now Select the checkboxes under the <strong>Display</strong> to select the columns required in the new view and change the names to be displayed if required. | Unchanged: (c) Now Select the checkboxes under the <strong>Display</strong> to select the columns required in the new view and change the names to be displayed if required. | ||
| Unchanged: (d) Other options available by selecting the checkboxes under them are. | Unchanged: (d) Other options available by selecting the checkboxes under them are. | ||
| Unchanged: <strong>M</strong>- Merge | Unchanged: <strong>M</strong>- Merge | ||
| Unchanged: <strong>G</strong>- Grouping | Unchanged: <strong>G</strong>- Grouping | ||
| Unchanged: <strong>ST</strong>-Subtotal | Unchanged: <strong>ST</strong>-Subtotal | ||
| Unchanged: <strong>GT</strong>-Grand total | Unchanged: <strong>GT</strong>-Grand total | ||
| Unchanged: (e) Click <strong>Advanced. </strong>This displays the width & format in the grid. | Unchanged: (e) Click <strong>Advanced. </strong>This displays the width & format in the grid. | ||
| Unchanged: Width- To change the size of the column | Unchanged: Width- To change the size of the column | ||
| Unchanged: Format - To change the order of the columns as required. | Unchanged: Format - To change the order of the columns as required. | ||
| Unchanged: <a href="https:/ /help.goodbookserp.com/wp- content/uploads/ 2021/06/Dview_ 03-2.png"><img class="alignnone size-full wp-image-13950" src="https:// help.goodbookserp.com/wp- content/uploads/ 2021/06/Dview_03-2.png" alt="" width="844" height="315" /></a> | Unchanged: <a href="https:/ /help.goodbookserp.com/wp- content/uploads/ 2021/06/Dview_ 03-2.png"><img class="alignnone size-full wp-image-13950" src="https:// help.goodbookserp.com/wp- content/uploads/ 2021/06/Dview_03-2.png" alt="" width="844" height="315" /></a> | ||
| Unchanged: 5.Click the <strong>Save</strong> button. | Unchanged: 5.Click the <strong>Save</strong> button. | ||
| Unchanged: 6. Wait till the popup appears on the screen to confirm that the view is created successfully. | Unchanged: 6. Wait till the popup appears on the screen to confirm that the view is created successfully. | ||
| Unchanged: <a href="https:/ /help.goodbookserp.com/wp- content/uploads/ 2021/06/Dview_ 09.png"><img class="alignnone size-full wp-image-13935" src="https:// help.goodbookserp.com/wp- content/uploads/ 2021/06/Dview_09.png" alt="" width="485" height="71" /></a> | Unchanged: <a href="https:/ /help.goodbookserp.com/wp- content/uploads/ 2021/06/Dview_ 09.png"><img class="alignnone size-full wp-image-13935" src="https:// help.goodbookserp.com/wp- content/uploads/ 2021/06/Dview_09.png" alt="" width="485" height="71" /></a> | ||
| Unchanged: | Unchanged: | ||
| Unchanged: | Unchanged: | ||
| Unchanged: | Unchanged: | ||
| Unchanged: | Unchanged: | ||
| Unchanged: | Unchanged: | ||
Note: Spaces may be added to comparison text to allow better line wrapping.
