how to generate multiple reports using xmlp

• burst by option helps in generating multiple reports in xmlp
• if u r report in burst mode we can't see output in query report viewer, we can see only in query report scheduler    
• we can see multiple report  output in report manager not in process monitor.

Delivered Page to Search Component Navigation.

There was several solutions to find the navigation path for component and page. There were several SQL statements for different databases. Finally Oracle as developed page this purpose.

• we can find using this sql code 

SELECT a.PORTAL_NAME,     
f.PORTAL_LABEL AS parent5_folder,                  
e.PORTAL_LABEL AS parent4_folder,
d.PORTAL_LABEL AS parent3_folder,
c.PORTAL_LABEL AS parent2_folder,   
b.PORTAL_LABEL AS parent_folder,
a.PORTAL_LABEL AS component           
FROM PSPRSMDEFN a
LEFT JOIN PSPRSMDEFN  b ON b.PORTAL_NAME = a.PORTAL_NAME
AND b.PORTAL_OBJNAME = a.PORTAL_PRNTOBJNAME
LEFT JOIN PSPRSMDEFN  c ON c.PORTAL_NAME = b.PORTAL_NAME
AND c.PORTAL_OBJNAME  = b.PORTAL_PRNTOBJNAME
LEFT JOIN PSPRSMDEFN  d ON d.PORTAL_NAME = c.PORTAL_NAME
AND d.PORTAL_OBJNAME  = c.PORTAL_PRNTOBJNAME
LEFT JOIN PSPRSMDEFN  e ON e.PORTAL_NAME = d.PORTAL_NAME
AND e.PORTAL_OBJNAME  = d.PORTAL_PRNTOBJNAME
LEFT JOIN PSPRSMDEFN  f ON f.PORTAL_NAME = e.PORTAL_NAME
AND f.PORTAL_OBJNAME = e.PORTAL_PRNTOBJNAME
WHERE a.PORTAL_REFTYPE = 'C'
AND a.PORTAL_URI_SEG2 = 'Type delivered component name'

• In the latest Ptools 8.50 and Application 9.1 application search is possible from two navigations.

1) Main Menu > Enterprise Components > Find Object Navigation
2) Setup HRMS > System Administration > Utilites > Portal Navigation Path

Search is possible with name of Component,Page,Secondary Page and Content Reference.

Search works fine with hidden components as well.

xml publisher subtempletes and logo

• create a data source using ex: ps query 
• get delivered sub template  from content library  add u r company logo and address to that and save it with u r own name
• create u r own main template  add this code

• Importing Sub-Templates to main template
  To import a sub-template file that is stored in the Content Library, place the following syntax at the top of the primary template file:
  <?import:psxmlp://sub-template_NAME?>
  where sub-template_NAME is the registered sub-template ID in the Content Library, for example:
  <?import:psxmlp://STDHEADER?>. This syntax must be in Normal text.
• Calling Sub-Templates
  Place the following syntax in the primary template file in the location where the desired text or XSL
  instructions from the sub-template file should appear:
  <?call-template:peoplesoft?>
  In the preceding sample code peoplesoft is the name of the component that you want to use in the subtemplate file  EX: <?call-template:portrait?>

• then see o/p in report viewer