Posts

My First Automated Post

Image
Here is the beautiful sportswoman Leryn Franco is a former Miss Paraguay runner-up as well as a world class javelin competitor

Last page will become first page ,if report is only one page.

Image
hello sir

Different Page header and footer

Image
problem stated : Need different page header and footers for FIRST , rest of page and LAST page. 1. first page 2. other pages 3. last page. Sample is here 1.Create a new template, click on the header, and select the different first page in the header setting. 2.insert a page-break, add the header what ever you want on the other pages header, it can be ?call:subtemplate:? instead of "Other header" text. 3.if you need a last page header and footer to be different.add a break again, add the code 4.Delete the 2nd page-break once you have done. the template has to look like this :) Need explanation i guess..

Can't find template builder in Word

Image
BI Publisher menu is missing, in the Ms word. How to resolve it. 1. To word options 2. Select add-ons 3. Enabled the templatebuilder.dot Have a look at this

How to put group element on the header/footer?

Image
Ex: there are four departments, each department have some employees. Requirement: 1)Each department is on the header and the employees correspond that department is on the detail. 2)Each page display page number of the report on the footer.

How to convert Char into Date format

If you have the date format in the canonical format, then using the functions over them , will give the expected output.. otherwise it wont't sample for this in here Problem stated :convert char format into date format using xdofx:to_char(substr('2008/02/28 00:00:00',1,10),'DD-MON-YYYY') but the conversion is not happening. if the data in the xml for the date field is good For ex: format-date:’2007-07-01T00:00:00.000-06:00’;’DD-MON-YYYY’ you get 01-Jul-2007 as output. Date should be proper format with timestamp. in this format YYYY-MM-DDThh:mm:ss+HH:MM. Even, If you dont want to change the xml data, still you can manipulate things xdofx:to_date(replace(substr('2008/02/28 00:00:00',1,10),’/’,’-’)||’T00:00:00.000-06:00’,'DD-MON-YYYY') Hope this helped Madhuri to get what she was expecting :).

Sum rows in RTF Template

Image
Grouping and transforming is fun, One more question on forum Asking for Grouping differently.. This is normal grouping Output Product Name |Sales ------------------------|-------- Product A |50 ------------------------|-------- Product B |100 ------------------------|--------- Product B1 |100 ------------------------|--------- Product B2 |25 ------------------------|--------- Product C |75 But I would like a table like : Product Name |Sales ------------------------|-------- Product A |50 ------------------------|-------- Product B |100 ------------------------|--------- Others Prd B |125 ------------------------|--------- Product C |75 ------------------------|--------- Here is sol'n