jde interview questions_part5

1.explain in report event flow?
a.initializing section :  occurs when a batch process encounters  a section for the first time,use this event to do processing immediately before a section begins.this event is useful for working with global variables

b.advance section :  occurs when each time you perform a fetch from the data base use this event if u need processing on objects before the fetch


c.do section :  occurs following an advance section, after values have been assigned to print out to a printer or an output file


d.after lost object printed : occurs after a row is printed an output file  it is used to process information after a row has been  output


e.end section : occurs after a batch process has been completed processing the last set of section values .use this event to do processing immediately after a section ends


2.what is set  selection append flag and set user selection?
set selection append flag : enables you to add, append or overwrite data selection and data sequencing for a selection


set user selection : enables you to define data selection and data sequencing for a selection


3. what is report?


a report is nothing but batch application used to represent the data in useful format or user defined format

4.what are the various types of detail sections available  with report design?


columnar, group, tabular
a. columnar section: is a fixed format we cont change the format  this is least flexible section


b. group section : is free form design capability .it is the most flexible section we cont change the format .we can drag and drop any ware variable and constant in section 

c.tabular section: it is same like columnar section and additional features are 1.drill down future 2.automatic totaling 3. subtotaling    and it is balance sheet


5.what is level break ,level break header and level break footer?
 level break:  will be occur when data will be changed and difference between the data


level break header: will be occur beginning of the header it show the information with in the detailed section 

level break footer : it will be occur in after the level break this is use in field the accumulate the total 


6.what is an aggregate object?


an aggregate object is an object that holds the result of a calculation on the values in other fields.for example the calculation could be a sum of values an average of values or a count of records


7.how do you invoke custom sections?


using the system function do_custom_section


8.how do you print text attachments in a report?

using media object system functions

9.it is possible to adapt the data selection and data sequencing from another section in the same report? if yes how?  


yes using the system function use data sel/seq from a section


10.it is possible to  do transaction processing from reports?how?


yes using the transaction processing functions begin,commit and rollback transaction business functions

11.some report system function?

Set selection append flag
Set sequence append flag
Set ube error
Set user selection
Stop batch processing
Stop event processing
Use data selection from section
Use data sequence from sequence