Search

Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself While at Work and Welcome any body Needing Help!!!.*** CAUTION: Using any of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.***

Tuesday, 18 February 2014

How to Create or Modify Master/Details Report

Create two different database tables to store Master and Details data. Please don’t forget to create constraint on table as per the requirement on that table.
To Create Master Block click on File – New – Report or (+) sign directly and use to “Build Report Manually”. Then go to the Tools Menu and choose Data Wizard concept and follow the Next instruction to write the Query for Report.
To Create Detail Block follow the same instruction while using Data Wizard change the Query name (Q_2) to (Q_3).
SELECT * FROM INVOICE_DETAILS
WHERE INVOICE# BETWEEN :FR_INVOICE# AND :TO_INVOICE#
AND INV_DATE BETWEEN :FR_IN_DATE AND :TO_IN_DATE;
SELECT * FROM INVOICE_Header
WHERE INVOICE# BETWEEN :FR_INVOICE# AND :TO_INVOICE#
AND INV_DATE BETWEEN :FR_IN_DATE AND :TO_IN_DATE;

Now you’re Report Editor – Data Model look like as
Now to Create the Relation between two block select ‘data link’ from Report Editor and drag from invoice# of G_invoice_Details block to G_Invoice_Master block invoice#.
Repeat the same process for to create other links. Now you’re Report Editor – Data Model look like as:
Now use the Report Wizard to design the report for Master as well as Details block.
To modify the report just click on header button button then later edit header button
 To modify parent frame design select the ‘flex mode’ to pick the individual items.
Now you can move or change the location, size of the individual item inside the parent frame. 

0 comments:

Post a Comment