I don't understand need to break the SYSDATE in the YYYY and MM-DD format because if you say "want to take from year before today and take from three months before that date" means 15 months before today's date? Can we directly try add_months(sysdate,-15)

May I know which environment you are using to produce jpeg output?

Request you to open different thread if issue is different

Hi, I can see full text from item6 is not getting printed in the report in Microsof environment where as in unix environment full text is getting printed and moving into next column that is causing the overlapping of text. . So you can use wrap-option="wrap" to wrap the text to new line Output will appear as below.

Did you attached your template to report? what is the output type? This error comes when Bursting program is not able to find desired output file to send

Could you please clear me on below points? 1. You want to print footer only after detail records end. Means if report is printing in 3 pages then first two pages should not show any footer and in third page you want to show footer? 2. In the same step-1 example you want to print different footer for first two pages and for…

Hi, For the best practice, always develop your template layout using table(please hide the table boarder, in example i have put to demonstrate)

Thank you...could you please upload the Sample XML data as well. You can choose-when condition so its difficult to find out with table row is getting printed for line 2.

Hi, I ran the xsl with the xml data provided...output looks good for me. Number 2 is appearing in same font size? Also I have seen all the attribute set declare on the top of xsl almost all the places font size is 9pt

Sorry my mistake...I ran as pdf...you have already mentioned its working fine with PDF

Hi, Can I understand? whenever we are printing image we print item0 as well. That always print before the image...but the example which you shared image is appearing first than number. So are we using same xsl which you shared? <xsl:value-of select=".//item0" xdofo:field-name="item0"/> <fo:instream-foreign-object…

Here seems to be issue Case 1 : XSL which you shared before Here image and text both are under <fo:inline and attribute set is ="Ex1_101771" which is 9 pt <fo:inline height="9.0pt" white-space-collapse="false" xsl:use-attribute-sets="Ex1_101771"> <xsl:value-of select=".//item0" xdofo:field-name="item0"/>…

Are you facing issue in Both Case-1 and Case-2? In Case-1 : Image and text both are inside <fo:inline> where attribute set is applied. In Case-2: Image is outside of <fo:inline> so there is no attribute set . Attribute sets are responsible for passion, fonts etc.

Share your sample XML....just with 10-15 rows

I took your XML and create two group and added XDO_SHEET_NAME_? as well in XDO METADATA. It worked for me , created two worksheet XDO_SHEET_NAME_?Brajesh

Hi , I was talking about the event triggers in BI Publisher. Using the trigger you can register the database package. and in the database package you can select data from different data sources and populate one singe global temporary table and use that table to show the data in report. Hope I am clear now?…

Can you upload your XSL file? It may calling some template for look and size

I mean you need group by. Follow the below link to create two group within same dataset. Our aim is to group the data in the set of 65000 in each group. https://docs.oracle.com/middleware/12211/bip/BIPDM/GUID-E8BD22BB-9CC7-462C-99F6-D3FEF55BB7BE.htm#BIPDM259 So your group from current group by from data set will be…

Can you give me Screen shot of your Group and Data Set?

Hi, Please define your data template as below. And put the below XML Code <?xml version = '1.0' encoding = 'UTF-8'?> <dataTemplate name="XXXX" version="1.0"> <properties> <property name="debug_mode" value="on" /> </properties> <dataQuery> <sqlStatement name="Q_ITEM_LOC"> <![CDATA[select item ,stock_on_hand ,loc…