Wednesday, September 30, 2015

SQL BOOK


Below are the good good sql/plsql book.

Prepares By Oracle : SQL BOOK
Prepared By Oracle : SQL PRACTICES BOOK
Prepared By Manjunath BT : SQL BOOK
Prepared BY Tutorialspoint.com : SQL/PLSQL BOOK

If your new to SQL and PLSQL - Then go for this book : SQL/PLSQL


Display Grand Total

Hi All,

Some time user wanted below type of Grand Total.[Check Red Mark].
















To get above type of grand total. follow below steps.
STEP 1 - Create same kind of Report == >Edit Report == >Go to Result 
STEP 2 - Go to Selection Step Pane
STEP 3 - From list --> select column.[B]
STEP 4 - You will see two things
                1st. Start all member and 
                2nd : Then New step
Click on 2nd option and add calculated Item
STEP 5 - Select Function as SUM --> Add all PRODUCT ---> and put Heading as Grand TOTAL

--
Thanks 
Rakesh Patil
rakeshpatil002@gmail.com