6.Working with Worksheets : Subtotal,Groupsort,grandtotal,Number Format,Line,SQL Inspector

#Subtotal:Go to  tools->Totals->Check the check box->New(Project Status Code)->Count->Insert

Select the column->Change the lable to subtotal. Here you can insert item name also , to change dynamic title ->Ok->Ok.

#Group Sort:To avoid the repetation values in particulor column,we can use this feature. We can display only single time.

Select the column name->Right Click->Group Sort.

#Grand Total: Go to tools->Total->Click on New->Select the radio button->Grand total at bottom->Ok->Ok.

#Number Format:To apply the number format we can use this feature.For every amount field we need to apply the number format.

Select the amount column->Right Click->Format data->Number Tab. Click on decimal place take 2,Check the check box of 1000 separators.

#Line:After Applying group sort we need to display one underline for every grouped results.

#SQL Inspector:In modifying the workbook we need to find out the view name.Follow below steps.

Copy the folder then go to discoverer admin edition->Business Area->Select the folder->Right Click->Properties->Copy Identifier->Go to database->find the script of it->Modify(Here we can see the query with view name).

Note: We can avoid all these steps in Desktop Edition. got to ->SQL Inspector and there we can find the view name in the from clause.