Infolinks

Wednesday, 2 May 2012

Report,SQL Loader,xml Registration Steps & faqs:

Report Registration Steps:


Report Registration Steps:
-------------------
1)Develop the report (.rdf)as per client Requirement by using reports 6i Builder

2)Move the report from Local mechine into Server
    CUS_TOP\11.5.0\Reports\US\ .rdf
     PO_TOP\11.5.0\Reports\US\ .rdf
  
3)Select System Administrator and create EXECUTABLE  
      1)Executable Name
     2)ApplicationName
     3)Execution Method
     4)Report(.rdf) file Name
          
4)Create Concurrent Program and attach  1)EXECUTABLE
      2)PARAMETERS
     3)INCOMPATIBILITIES          
5)Create Request Group and attach  Concurrent Program

6)Create Responsibility    1)Request Group
       2)Data    Group
      3)Menu
7)Create user, attach Responsibility to the user.

8)User will select the Responsibility and goto SRS(Standard Request Submission) Window
  submit the Request.








Navigations:
============

Executable           = Concurrent=>Program=>Executable
Concurrent Program   = Concurrent=>Program=>Define
Request Group      = Security=>Responsibility=>Request
Responsibility       = Security=>responsibility=>Define
User       = Security=>User=>Define
SRS Window      = View Menu=>Request =>Submit New request=>Ok=>Select Program
                       =>Submit=>No=>Find=>View Outpu
=====

Registering SQL*Loader as a Concurrent Program


Registering SQL*Loader as a Concurrent Program

The following steps will describe the process to register a SQL*Loader program as a Concurrent Program in Oracle Apps.
Step 1]
Create the SQL*Loader Control and Data file and place them in Server(ex: $CUSTOM_TOP/bin). Create or check the interface table structures in the backend.
Control file: test.ctl
Data file: test.dat

1CREATE TABLE testdept
2(deptno NUMBER(2) NOT NULL,
3 dname VARCHAR2(14),
4 loc VARCHAR2(13));

Step 2]
Go to Application Developer > Concurrent > Executables. Define a Concurrent Program Executable. Choose the Execution Method as SQL*Loader and give the Execution File Name as the name of the SQL*Loader control file. Save your work.
Step 3]
Go to Application Developer > Concurrent > Program. Define the Concurrent Program. Attach the executable defined above.
Step 4]
Go to parameters of the concurrent program. Create a parameter to take the server path of the data file. You can also place the default value.
Step 5]
Attach the Concurrent program to a Responsibility through a Request Group.
Step 6]
Go to that Responsibility and Run the Concurrent Program. If successful check the output file that have all data uploading information.
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 64 rows, maximum of 256000 bytes
Continuation: none specified
Path used: Conventional
Table TESTDEPT, loaded from every logical record.
Insert option in effect for this table: INSERT
   Column Name                  Position   Len  Term Encl Datatype
—————————— ———- —– —- —- ———————
DEPTNO                               FIRST     *   ,  O(“) CHARACTER           
DNAME                                NEXT     *   ,  O(“) CHARACTER           
LOC                                     NEXT     *   ,  O(“) CHARACTER           
Table TESTDEPT:
  7 Rows successfully loaded.
  0 Rows not loaded due to data errors.
  0 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.
Space allocated for bind array:49536 bytes(64 rows)
Read   buffer bytes: 1048576
Total logical records skipped:           0
Total logical records read:               7
Total logical records rejected:          0
Total logical records discarded:        0
Run began on Thu Aug 12 09:41:55 2010
Run ended on Thu Aug 12 09:41:56 2010
Elapsed time was:      00:00:00.11
CPU time was:           00:00:00.01
Step 7]
Check in the backend whether the tables got updated or not.


The Bad and Discard files will be created in /conc/out file of the server.
 =====

STEPS TO REGISTER XML REPORT IN APPS


STEPS TO REGISTER XML REPORT IN APPS
1)Develop the .rdf file and .rtf file
2)Register both .rdf and .rtf file

  .rdf File registration :
  =========================
  1)Move the .rdf file into CUS_TOP\11.5.0\Reports\US
  2)Create Execuiteable
           Concurrent Program  Output = XML
           Request Group
           Responsibility
           User
           SRS
  3)Copy the Concurrent Program Short name
  
  .rtf File Regitration:
 =======================

1)Goto the XML Publisher Administrator Responsibility
2)Select Data Definations form
  Enter Data Defination Name = Enter Any Name 
  Code               = Concurrent Program Short Name
  Application              = Any application
  startdate       = Current Date

3)Copy the DataDefination name we have to add this to the Templete
4)Open the Templete Form
  Enter Templete Name : Any Name
  DataDefination      : enter data defination whatever we have created
  Code                : Concurrent Program Short Name
  Type                : rtf
  application         : any Application
  File                : Upload the .rtf file
  Laguage             : English
  Territory           : United States

5)Select Apply button

After register the .rtf file submit concurrent Program from SRS window system will 
automatically pick the .rtf file and generates  the Output.

If we want to customze the .rtf file we have to download by using templete , Customize then
upload the .rtf templete.
 
===========

REPORTS Interview Questions


REPORTS Interview Questions

Q: Name the report triggers.
A: 1. Before Parameter 2. After Parameter 3. Before Report 4. Between Pages 5. After Report
Q: What are bind parameter and lexical parameter used for?
A: A bind reference replaces a single value or expression.To create a bind reference in a query, prefix the parameter name with a colon (:). A lexical reference is a text string and can replace any part of a SELECT statement, such as column names, the FROM clause, the WHERE clause, or the ORDER BY clause. To create a lexical reference in a query, prefix the parameter name with an ampersand (&).
Q: How do you print barcode in the reports?
A: By installing the Barcode Font and using the Chart field in the Layout.
Q: What are the different sections in the Layout?
A: Header, Main, Trailer
Q: What is SRW package and some procedures in SRW?
A: It is the standard reports package and it has many procedures like USER_EXITS, DO_SQL, RUN_REPORT, MESSAGE,TRACE, BREAK, SET_ATTR.
Q: What are user exits in reports and name a few?
A: User exits provided a way to pass control from Reports Builder to a program you have written, which performs some function, and then returns control to Reports Builder. Ex: SRW.DO_SQL, SRW.USER_EXIT
Q: How do you display only one record on each page in a report?
A: Give Page Break in the Format trigger of the repeating frame.
Q: How do you write the report output to Excel file or text file?
A: 1.Use TEXT_IO package 2.Use SPOOL in After Report trigger 3.Use UTL Package
Q: Give an example of the implementation of "between pages trigger" in reports.
A: The total printed at the bottom of first page has to be carried to the top of the next page.
Q: How do you resolve the following layout issues in reports?
A: No answer yet!
Q: Where in reports do you set the context information (like org_id)?
A: SRW.INIT
Q: What is Anchor in reports?
A: Anchors fasten an edge of one object to an edge of another object, ensuring that they maintain their positions relative to its parent.
Q: The total printed at the bottom of first page has to be carried to the top of the next page. How do u do this technically?
A: No answer yet!
Q: What is the difference between Conditional Formatting and format trigger?
A: Both provide the same functionality, used to format the output based on particular conditions. Format triggers provide a wide variety of options when compared to conditional formatting(GUI). In format Triggers we have the option to write PL/SQL code where as conditional formatting is GUI based which provide limited options.
Q: How do you call a concurrent program or another report from a report?
A: Use FND_SUBMIT.REQUEST() to call a concurrent program or a report. Use SRW.RUN_REPORT() to run a report directly without registering it as a concurrent program.
Q: How do you mail the output of a report?
A: 1. Use UTL_SMTP (refer to Scripts tab for more details) 2. Use MAILX called in a shell script registered as a concurrent program with parameters File name and path.
Q: How can you grey out/ highlight/hide some records based on conditions in a report?
A: Use Conditional formatting
Q: What is Report Busting?
A: Reports bursting offers you to deliver a single report to multiple destinations simultaneously. It offers you to create multiple reports out of one single report model.

For example, you can create just one employee report for all your departments and send an email with a PDF-attachment containing the report to each manager. Each report would contain only the relevant department information for that particular manager. Using the reports bursting functionality will reduce the overhead since you will only have a single data fetch and report format.
Q: Is it possible to change the margins for oracle report?
A: Yes.
Q: What is the difference between "AFTER PARAMETER FORM" trigger and "BEFORE REPORT" trigger?
A: AFTER PARAMETER FORM trigger is fired immediately after the report parameter form is submitted. BEFORE REPORT trigger is fired after the report queries are parsed and data is fetched.x
Q: What are the mandatory parameters given in Reports
A: P_CONC_REQ_ID,
P_ORG_ID
============

Reports FAQs


Reports FAQs

1) What is ANCHOR?
A) These are used to determine the vertical and horizontal positioning of the child object relative to its position.
Tool which we will use in the layout to destroy the field horizontally or vertically whenever field gets null value.
When we have multiple fields in layout if any one of the field gets null value the next field should gets automatically adjusted in that place that time we will use anchor.

2) What is frame?
A) Frame is the place in the layout model where we place an object to display only once in the report output.

3) What is repeating frame?
A) It is also a place in the layout editor where we place an object to display repeatedly
In report output.

4) What are action, format and validation triggers?
A) ACTION TRIGGERS: action triggers are pl/sql procedures executed when button is selected
EX: calling a report

FORMAT TRIGGERS: format triggers are pl/sql functions which we will use to display layout object in the report.
The return type is always true or false.
EX: no data found we will write a validation trigger for this boiler plate text.

VLIDTION TRIGGERS: we will use to validate the lov values in the parameter form.

5) What are Report Triggers?
A) Report triggers are 5 types. They are
1) Before parameter form.
2) After parameter form.
3) Before report trigger.
4) Between pages.
5) After Report trigger

6) What is the difference between after parameter form and before report trigger?
A) After parameter for will fire in Parsed time.
Before report trigger will fire in the execution time.

7) What are Bind and Lexical parameters?
A Bind parameter: Bind parameter is a variable which we will use to pass the vlue.
‘:’ before any variable in a query is called as bind variable.
Lexical parameters: Lexical parameter is a parameter which we will use inside of a query. These parameters we can use any where inside of query.
EX: select, from, where, order by

8) What are system parameters?
A) There are around 78 system parameters. Some of them are
1) Background
2) Currency
3) Copies
4) Decimal
5) Desformat
6) Desname
7) Destype
8) Mode
9) Orientation
10) Destintion

9) What are formula, summary and placeholder columns?
A) Formula column: It is a pl/sql block which will calculate a value based on our logic and it will return one value.

Summary column: It is a pl/sql block which we will use to print the result of aggregate functions like sum, avg and count either at page level or at report level.

Placeholder column: It is a column which will have the data type and value. It works like global variable in reports.
If we want to return more than one value then we will use placeholder column in formula column.

10) How to run a report from a report?
A) We will place button in the repeating frame of layout editor. And in that button code we will write code as follows
Srw.run_report (‘path of .rdf file’, paramform = no, dept = “‘||:deptno||’”’);
Save the report and generate it.

11) What is user exit?
A) User exit is an program which will transfer the control from report execution to another third generation language it will the required data & it will complete the remaining report execution process.
12) What is srw.do_sql, srw.message, srw.referene.srw.program_abort?
A) srw.do_sql: used to execute DDL commands in reports.
Syntax: srw.do_sql (‘create table tname’);

Srw.message: used to display message in reports.

Srw.reference: used to refer the variables in formula columns.

Srw.program_abort: This exception stops report execution and raises the following exceptions.
Rep-1419 pl/sql program aborted

13) How to execute DDL commands in reports?
A) We will execute the DDL commands in reports by using the following user exit.
Srw.do_sql (‘create table tname ()’);

14) How to change the layout dynamically?
A) A lay out can be changed dynamically by passing the parameters.

15) How to implement lexical parameters in reports?
A) & before any parameter is called as lexical parameters. We can use these parameters in any class of the query
Ex: select, where, order by

16) What is the report global variable?
A) Place holder column is the report global variable. We can return more than one value by using place holder column.

17) What is matrix report?
A) Display information row ,column and cell format

18) The report output is 10 pages then how many times between pages report trigger will fire?
A) It will fire 8 times. Between pages report trigger will not fire for 1st and last page.

19) Report will not have any parameters then before and after parameters will fire or not?
A) yes
====

Report Questions


Report Questions

1. What is SRW Package? 
Ans: The Report builder Built in package know as SRW Package (Sql Report Writer) This package extends reports, Control report execution, output message at runtime, Initialize layout fields, Perform DDL statements used to create or Drop temporary table, Call User Exit, to format width of the columns, to page break the column, to set the colors
Ex: SRW.DO_SQL, It’s like DDL command, we can create table, views, etc,
SRW.SET_FIELD_NUM
SRW. SET_FIELD_CHAR
SRW. SET FIELD _DATE


2. What are Lexical Parameters and bind parameters?
Lexical Parameter is a Simple text string that to replace any part of a SELECT statement. Column names, the from clause, where clause or the order by clause. To create a lexical reference in a query we prefix the parameter name with an ampersand (ex. &.dname,)


3. What is User Parameters?
A parameter, which is created by user. For to restrict values with where clause in select statement.
Data type, width, input mask, initial value, validation trigger, list of values
We can use Lovs in use in user parameter with static and Dynamic Select Statement.

4. What is System Parameters: These are built-in parameters by corporation.
BACKGROUND: Is whether the report should run in the foreground or the background.
COPIES Is the number of report copies that should be made when the report is printed.
CURRENCY Is the symbol for the currency indicator (e.g., "$"). 


Ans: The Report builder Built in package know as SRW Package (Sql Report Writer) This package extends reports, Control report execution, output message at runtime, Initialize layout fields, Perform DDL statements used to create or Drop temporary table, Call User Exit, to format width of the columns, to page break the column, to set the colors
Ex: SRW.DO_SQL, It’s like DDL command, we can create table, views, etc,
SRW.SET_FIELD_NUM
SRW. SET_FIELD_CHAR
SRW. SET FIELD _DATE
2. What are Lexical Parameters and bind parameters?
Lexical Parameter is a Simple text string that to replace any part of a SELECT statement. Column names, the from clause, where clause or the order by clause. To create a lexical reference in a query we prefix the parameter name with an ampersand (ex. &.dname,)
3. What is User Parameters?
A parameter, which is created by user. For to restrict values with where clause in select statement.
Data type, width, input mask, initial value, validation trigger, list of values
We can use Lovs in use in user parameter with static and Dynamic Select Statement.
4. What is System Parameters: These are built-in parameters by corporation.
BACKGROUND: Is whether the report should run in the foreground or the background.
COPIES Is the number of report copies that should be made when the report is printed.
CURRENCY Is the symbol for the currency indicator (e.g., " $?).
DECIMAL Is the symbol for the decimal indicator (e.g., ".").
DESFORMAT Is the definition of the output device's format (e.g., landscape mode for a printer). This parameter is used when running a report in a character-mode environment, and when sending a bitmap report to a file (e.g. to create PDF or HTML output).
DESNAME Is the name of the output device (e.g., the file name, printer's name, mail userid).
DESTYPE Is the type of device to which to send the report output (screen, file, mail, printer, or
Screen using PostScript format).
MODE Is whether the report should run in character mode or bitmap.
ORIENTATION Is the print direction for the report (landscape, portrait, default).
PRINTJOB Is whether the Print Job dialog box should appear before the report is run.
THOUSANDS Is the symbol for the thousand's indicator (e.g., ",").

5. How many Types of Reports available in Reports
Tabular form-like form – letter Group left
Group above matrix Matrix with group Mailing label
Matrix Report: Simple, Group above, Nested
Simple Matrix Report required 4 groups
1. Cross Product Group
2. Row and Column Group
3. Cell Group
4. Cell column is the source of a cross product summary that becomes the cell content.
Frames: 1.Repeating frame for rows (down direction)
2. Repeating frame for columns (Across)
3. Matrix object the intersection of the two repeating frames


6. What Types of Triggers are Available in Reports.
Report level Triggers
Data Model Triggers
Layout Model Triggers
Report Level Triggers
Before parameter form: If u want take parameters passed to the report and manipulate them so that they appear differently in the parameter form., this is where modification can be done for ex: when u want pass a deptno but show the dname selected , use a before parameter form trigger.
After parameter form & Before Report: These two triggers are fired one after the other. No event occurs in between them. However the way the way that the reports product behaves when the triggers fail is quite different. If the After Parameter trigger fails the report will be put back into the parameter form. It’s useful to place code here to check whether values in your parameter form are valid. Even though the Before Report trigger is executed before the query runs, if this trigger fails it won’t fail until reports tries to display the first page of the report. This means that even if something goes wrong in the before report trigger (meaning that you may not want to run the query at all) It will run anyway
Between pages: This Trigger fires before all pages except first page one. It will not fire after the last page of a report. If a report only has one page it will not fire at all. You can use this trigger to send specific control to the change the paper orientation or to do double sided printing
After report: This trigger fires the report has printed or in the case of a screen report, after the report is closed following viewing. This trigger can be used to update a global variable if u r returning the number of pages in a report. It is also used to delete temporary table used to print the report
Data Model Triggers
Formula Column, Group Filter, Parameter values
Layout Model Triggers

7. What are Format triggers?
Format triggers enable you to modify the display of objects dynamically at run time or to suppress display altogether
For Headings, for repeating frames, for field, for boilerplate object
To format a column based on certain criteria for example
i) To format the max (Sal) for particular department.
ii) To format the Sal column with a Dollar ($) prefix.
iii) To format Date formats….etc

8. What is Data Model?
Data Model is logically group of the Report Objects through query and Data model tools. Once query is compiled report automatically generates group. The queries build the groups ant then Groups are used to populate the report. The only function of queries in report is to create the groups. The Report Editor's Data Model view enables you to define and modify the data model objects for a report. In this view, objects and their property settings are represented symbolically to highlight their types and relationships. To create the query objects for your data model, you can use the Report Wizard, Data Wizard, or the Query tools in the tool palette.


9. What is Layout model?
Layout Model is to physically arrange Data model group objects on the Report. The Report Editor's Layout Model view enables you to define and modify the layout model objects for a report. In this view, objects and their property settings are represented symbolically to highlight their types and relationships.


10 What is Live Previewer? 

Ans: The Live Previewer is a work area in which you can preview your report and manipulate the actual or live data at the same time. In the Live Previewer you can customize reports interactively, meaning that you can see the results immediately as you make each change.
To activate buttons in the Live Previewer, you must display the report output in the Runtime Previewer. In order to edit your report, such as changing column size, move columns, align columns insert page numbers, edit text, change colors, change fonts set format masks, insert field the Live Previewer must be in Flex Mode.

Access
Title
Viewing region
Rulers
Grid
Toolbar
Style bar
Tool palette
Status bar


11. What is Parameter Form 
Ans: The Live Previewer is a work area in which you can preview your report and manipulate the actual or live data at the same time. In the Live Previewer you can customize reports interactively, meaning that you can see the results immediately as you make each change.
To activate buttons in the Live Previewer, you must display the report output in the Runtime Previewer. In order to edit your report, such as changing column size, move columns, align columns insert page numbers, edit text, change colors, change fonts set format masks, insert field the Live Previewer must be in Flex Mode.

Access
Title
Viewing region
Rulers
Grid
Toolbar
Style bar
Tool palette
Status bar
11. What is Parameter Form
Ans: Parameters are variables for report that users can change at runtime immediately prior to the execution of the report. You can use system parameters to specify aspects of report execution, such as the output format, printer name, mailed or number of copies. We can also create own parameters through sql or Pl/sql at runtime.
The Parameter Form view is the work area in which you define the format of the report's Runtime Parameter Form. To do this, you define and modify parameter form objects (fields and boilerplate).
When you run a report, Report Builder uses the Parameter Form view as a template for the Runtime Parameter Form. Fields and boilerplate appear in the Runtime Parameter Form exactly as they appear in the Parameter Form view. If you do not define a Runtime Parameter Form in the Parameter Form view, Report Builder displays a default Parameter Form for you at runtime.

12. What is Query? 


The first thing in data model is the query. Through query we access database objects with sql query. Compiled query creates groups. We can create query through query builder, sql query and import query from o/s file or database.

13. What is Group? The first thing in data model is the query. Through query we access database objects with sql query. Compiled query creates groups. We can create query through query builder, sql query and import query from o/s file or database.

13. What is Group?
The first thing in data model is the query. Through query we access database objects with sql query. Compiled query creates groups. We can create query through query builder, sql query and import query from o/s file or database.

13. What is Group?

Ans: Groups are created to organize the columns in your report. When you create a query, Report Builder automatically creates a group that contains the columns selected by the query. You create additional groups to produce break levels in the report, either manually or by using the Report Wizard to create a group above or group left report.

14 What is Repeating Frame? 

Ans: Repeating frames surround all of the fields that are created for a group’s columns. Repeating frames correspond to groups in the data model. Each repeating frame must to be associated with a group of data model the repeating frame prints (is fired) once for each record of the group.

15. What is Reference Cursor? 

Ans: Repeating frames surround all of the fields that are created for a group’s columns. Repeating frames correspond to groups in the data model. Each repeating frame must to be associated with a group of data model the repeating frame prints (is fired) once for each record of the group.

15. What is Reference Cursor? 
A ref cursor query uses PL/SQL to fetch data. Each ref cursor query is associated with a PL/SQL function that returns a strongly typed ref cursor. The function must ensure that the ref cursor is opened and associated with a SELECT statement that has a SELECT list that matches the type of the ref cursor.
You base a query on a ref cursor when you want to:
n more easily administer SQL
n avoid the use of lexical parameters in your reports
n share data sources with other applications, such as Form Builder
n increase control and security
n encapsulate logic within a subprogram
Furthermore, if you use a stored program unit to implement ref cursors, you receive the added benefits that go along with storing your program units in the Oracle database.


16. What is Template? 

Ans: Templates define common characteristics and objects that you want to apply to multiple reports. For example, you can define a template that includes the company logo and sets fonts and colors for selected areas of a report. And properties of the objects also
Creation of Template: In Report editor , open a existing Template or Create a new Template and save it concerned directory. Then Edit CAGPREFS.ORA File , and Specify which type of Template are u going to develop.
Ex. Tabular, form, matrix Then give your developed template *.tdf file name.
Develop Report with Newly developed Template.


17 what is Flex mode and Confine mode?
Confine mode
On: child objects cannot be moved outside their enclosing parent objects.
Off: child objects can be moved outside their enclosing parent objects.
Flex mode:
On: parent borders "stretch" when child objects are moved against them. 

Ans: Templates define common characteristics and objects that you want to apply to multiple reports. For example, you can define a template that includes the company logo and sets fonts and colors for selected areas of a report. And properties of the objects also
Creation of Template: In Report editor , open a existing Template or Create a new Template and save it concerned directory. Then Edit CAGPREFS.ORA File , and Specify which type of Template are u going to develop.
Ex. Tabular, form, matrix Then give your developed template *.tdf file name.
Develop Report with Newly developed Template.
17 what is Flex mode and Confine mode?
Confine mode
On: child objects cannot be moved outside their enclosing parent objects.
Off: child objects can be moved outside their enclosing parent objects.
Flex mode:
On: parent borders " them.

Off: parent borders remain fixed when child objects are moved against them.

18. What is Page Break? 

Ans: To limit the records per page.

19 What is Page Protector?

Ans: The Page Protect property indicates whether to try to keep the entire object and its contents on the same logical page. Setting Page Protect to Yes means that if the contents of the object cannot fit on the current logical page, the object and all of its contents will be moved to the next logical page. Ex: if you set yes, the object information prints another page.
Print Condition

The print condition type First, All, All but first, Last, All but last refer to the frequency with which you want to appear based upon the setting of the print condition object. A print condition object of Enclosing Object is whichever object encloses the current object (could be the parent or a frame within the parent), while Anchoring Object is the parent object (unless you have explicitly anchored the object in which case it is the object to which it is anchored). The key here is that this is about the pages on which the Print Condition Object appears, not the current object. Oracle views First as the first page on which any part of the Print Condition Object is printed, likewise Last is the last page on which any part of the Print Condition Object is printed. For objects inside a repeating frame, this condition is re-evaluated for each instance of the frame.

20 What is Print Direction? 
The print condition type First, All, All but first, Last, All but last refer to the frequency with which you want to appear based upon the setting of the print condition object. A print condition object of Enclosing Object is whichever object encloses the current object (could be the parent or a frame within the parent), while Anchoring Object is the parent object (unless you have explicitly anchored the object in which case it is the object to which it is anchored). The key here is that this is about the pages on which the Print Condition Object appears, not the current object. Oracle views First as the first page on which any part of the Print Condition Object is printed, likewise Last is the last page on which any part of the Print Condition Object is printed. For objects inside a repeating frame, this condition is re-evaluated for each instance of the frame.
20 What is Print Direction?
Ans: The Print Direction property is the direction in which successive instances of the repeating frame appear.

21 What is Vertical and Horizental ElacityAns: The Horizontal Elasticity property is how the horizontal size of the object will change at runtime to accommodate the objects or data within it:

22.What is Place holder Columns? 

Ans: A placeholder is a column is an empty container at design time. The placeholder can hold a value at run time has been calculated and placed in to It by pl/sql code from anther object. You can set the value of a placeholder column is in a Before Report trigger , A report level formula column(if the place holder column is at report level) A formula column in the place holder group or a group below it
Uses of place holder columns enables u to populate multiple columns from one piece of code. U can calculate several values in one block of pl/sql code in a formula column and assign each value into a different placeholder column. U therefore create and maintain only program unit instead of many.
Store a Temporary value for future reference. EX. Store the current max salary as records are retrieved.

23 What is Formula Column?
Ans: A formula column performs a user-defined computation on another column(s) data, including placeholder columns.


24 What is Summary columns?
Ans: A summary column performs a computation on another column's data. Using the Report Wizard or Data Wizard, you can create the following summaries: sum, average, count, minimum, maximum, % total. You can also create a summary column manually in the Data Model view, and use the Property Palette to create the following additional summaries: first, last, standard deviation, variance.

25 What is Boilerplate?
Ans: Boilerplate is any text or graphics that appear in a report every time it is run. Report Builder will create one boilerplate object for each label selected in the Report Wizard (it is named B_
Column name). Also, one boilerplate object is sometimes created for each report summary. A boilerplate object is owned by the object surrounding it, unless otherwise noted.

26 What is Data Link
When we join multiple quires in a report the join condition is stored in the data link section
Data links relate the results of multiple queries. A data link (or parent-child relationship) causes the child query to be executed once for each instance of its parent group. When you create a data link in the Data Model view of your report, Report Builder constructs a clause (as specified in the link's Property Palette) that will be added to the child query's SELECT statement at runtime. You can view the SELECT statements for the individual parent and child queries in the Builder, but can not view the SELECT statement that includes the clause created by the data link you define.

27 What is filter and Group Filter
28.What is Query Builder 

Ans: A placeholder is a column is an empty container at design time. The placeholder can hold a value at run time has been calculated and placed in to It by pl/sql code from anther object. You can set the value of a placeholder column is in a Before Report trigger , A report level formula column(if the place holder column is at report level) A formula column in the place holder group or a group below it
Uses of place holder columns enables u to populate multiple columns from one piece of code. U can calculate several values in one block of pl/sql code in a formula column and assign each value into a different placeholder column. U therefore create and maintain only program unit instead of many.
Store a Temporary value for future reference. EX. Store the current max salary as records are retrieved.

23 What is Formula Column?
Ans: A formula column performs a user-defined computation on another column(s) data, including placeholder columns.
24 What is Summary columns?
Ans: A summary column performs a computation on another column's data. Using the Report Wizard or Data Wizard, you can create the following summaries: sum, average, count, minimum, maximum, % total. You can also create a summary column manually in the Data Model view, and use the Property Palette to create the following additional summaries: first, last, standard deviation, variance.
25 What is Boilerplate?
Ans: Boilerplate is any text or graphics that appear in a report every time it is run. Report Builder will create one boilerplate object for each label selected in the Report Wizard (it is named B_
Column name). Also, one boilerplate object is sometimes created for each report summary. A boilerplate object is owned by the object surrounding it, unless otherwise noted.
26 What is Data Link
When we join multiple quires in a report the join condition is stored in the data link section
Data links relate the results of multiple queries. A data link (or parent-child relationship) causes the child query to be executed once for each instance of its parent group. When you create a data link in the Data Model view of your report, Report Builder constructs a clause (as specified in the link's Property Palette) that will be added to the child query's SELECT statement at runtime. You can view the SELECT statements for the individual parent and child queries in the Builder, but can not view the SELECT statement that includes the clause created by the data link you define.
27 What is filter and Group Filter
28.What is Query Builder
Ans: it’s a gui tool to build a query in Report Wizard, Data Wizard or Data model.

29 What is Break Column? 

Ans: We can break a column through data model , it Display once for a group

30. How do u call Report from form? 
Ans: We can break a column through data model , it Display once for a group
30. How do u call Report from form? 
Ans: RUN_PRODUCT and RUN_REPORT_OBJECT

31. HOW CAN U CREATE TWO FORMATS
USING DISTRIBUTION WE CAN CREATE DIFFERENT FORMATS

32 HOW TO DISPLY ONE RECORD PER PAGE ( WHICH PROPERTY WE SHOULD SET)
Set Repeating Frame Properties : Maximum records per page=1 And it will override group filter property.
In Data model Layout , Group Property Through Filter Type & No of records to display
Property, Values are First, last, pl/sql


33. What is Header ,Body, Trailer, and Footer in Reports
Header: The header consists of one or more pages that are printed before report proper. The type of
Information you might want to print title of the page, company logo and address or chart the
Summarizes the report.
Trailer: The trailer consists of one or more pages that print after the report itself, usually used for nothing more than an end of report blank page, but also used for a report summary or chart.
Body: The body is where all the main report objects are placed
Margin: the report layout only governs the part of the pages designated for the main data portion of the report. The margins are can be used to specify page headers and page footers.

34. what are Executable file definitions in Reports
Report Builder (RWBLD60.EXE)
n Reports Runtime (RWRUN60.EXE)
n Reports Convert (RWCON60.EXE)
n Reports Background Engine (RWRBE60.EXE)
n Reports Server (RWMTS60.EXE)
n Reports Web Cartridge (RWOWS60.DLL)
n Reports CGI (RWCGI60.EXE)
n Reports Queue Manager (RWRQM60.EXE)
n Reports Launcher (RWSXC60.EXE)
n Reports ActiveX Control (RWSXA60.OCX)
35 what are the Non_query fields?
Aggregated Information, Calculated information, A string Function
Can I highlight and change all the format masks and print conditions of a bunch of fields all at once?
You can. If you highlight a bunch of objects and then right click and select "properties..", Oracle gives you a stacked set of the individual properties forms for each of the selected objects. While this may be useful for some things, it requires changing values individually for each object. However, instead you can select the group of fields and then select "Common properties" from the "Tools" menu which will allow you to set the format mask , print conditions etc. for the whole set of objects at once.

36 How do I change the printed value of a field at runtime?
Triggers are intended to simply provide a true or false return value to determine whether an object should be printed. It is generally not allowed to change any values held in the cursor, make changes to the database, or change the value of it's objects value.
That being said, there is a highly unpublicized method of doing just that using the SRW.Set_Field_Char procedure.
The syntax is SRW.Set_Field_char (0,) and the output of the object that the current trigger is attached to will be replaced by .
There are also SRW.set_fileld_num and SRW.set_field_date for numeric or date fields. While these options do work, they should only be used if a suitable NVL or DECODE statement in the original query is not possible as they are much, much slower to run. Also, note that this change of value only applies to the formatted output. It does not change the value held in the cursor and so can not be used for evaluating summary totals

Report Bursting
The capability of producing multiple copies of a given report or portion of it in different output formats is referred to as report bursting.

Additional Layout: 

Additional layout created for to different format using same query and groups without modifying default layout created by report wizard., we can use both layouts according to user requirement.

System Variables as Source Field In Layout Editor
Ans: Current date, Page Number, Panel number, Physical Page Number, Total Pages,
Total Panels, Total Physical Pages.

Link File: Is a special type of boilerplate, that doesn’t have to remain constant for each report run
The type of file contents, can be Text, Image, CGM, Oracle drawing format, or image URL
Source filename: the name of the file the u want link to the report through import Image from
===
 
 

No comments:

Post a Comment