Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Miscellaneous
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new

Search Courses

I am pleased to introduce to you Mr Darshan Bhavsar. Darshan is a Senior Technical Oracle Applications Consultant and amongst many things, he specializes in XML Publisher.

In this article, he will explain the steps to implement XML Publisher reports for Pre-Printed Stationary in Oracle eBusiness Suite.
Many thanks to Darshan for sharing this knowledge.
This article from Darshan will help a lot of technical consultants in implementing similar solutions for their respective clients.




The article below is from Mr Darshan Bhavsar.

The Sample Template and Data file can be downloaded from the end of this article.

Abstract

I was inspired to come up with this because I feel that lots of people want this solution and they are struggling to implement this.

In this whitepaper, I am going to explain the approach which I used for developing pre-printed stationary reports by XML publisher’s RTF method. This approach I used for 2 customers and it works absolutely fine. They are very happy. Example Pre-Printed stationary reports which I worked on are following ‘AP Check Printing(Bank)’ ,’AR invoice Printing’,’PO purchase Order Printing’ …. etc….



Background

I have a customer who wants to convert their 40+ Oracle Apps reports to ‘XML publisher’ Reports. These reports are fall in categories of AR invoice report, check printing report and PO print report which they are printing on pre-printed (pre-defined) stationary.

Just a little background of pre-printed stationary report’s layout where there is a fix Header section and fix Detail Section Table. Detail section table should always have fix table height, in the sense it should always have fix number of rows in the table no matter how many rows returned by actual report run. For example Invoice stationary has fix 30 rows in line detail table, and Actual report run is returning only 5 rows then rest 25 blank rows should be generatedprogrammatically.

 


So far there are solutions available which are talking about fixing table height for the 1st pages onwards not for the first page itself, i.e. where actual report run is returning lines which are less than lines_fixed_per_page.
For example Invoice run is returning only 5 rows where as pre-printed stationary has fixed 30 lines per page.I struggled a lot to get this solution and now I got this and sharing it in this whitepaper.

 

So far it has not been discovered because of the limitation of for-loop in XSL-FO (XML Technology).Limitation I mean is ,we can not write loop like ‘ for (i=10;i<15;i++)’ in XML. In XML ‘for’ loop will always iterate till it gets data, if we want to go beyond that then we can not go. I mean we can write for loop based on data value.

To overcome this problem, I have used Sub-template concept which I am calling recursively.

 


Detail Solution

 I am giving this solution for Standard Check Printing Report. Tree structure of data (Sample XML data is as follow).

<LIST_G_CHECKS>

    <G_CHECKS>  -- Top Most root -- Header

      <C_CHECK_NUMBER>21897</C_CHECK_NUMBER>

      <C_VENDOR_NUMBER>2205</C_VENDOR_NUMBER>

      <LIST_G_INVOICES>

        <G_INVOICES> -- Inner loop - Line Section

          <C_PAYMENT_NUMBER>1</C_PAYMENT_NUMBER>

          <C_INVOICE_NUMBER>ERS-20-SEP-06-243</C_INVOICE_NUMBER>

        </G_INVOICES>

        <G_INVOICES> -- Inner loop - Line Section

          <C_PAYMENT_NUMBER>2</C_PAYMENT_NUMBER>

          <C_INVOICE_NUMBER>ERS-20-SEP-06-244</C_INVOICE_NUMBER>

        </G_INVOICES>

      </LIST_G_INVOICES>

    </G_CHECKS>

</LIST_G_CHECKS>

 

Below is the step-step guide which I follow.

 

1) Open the Outermost for loop --  G_CHECKS

<?for-each@section:G_CHECKS?>

 

2) Declare Global Variable called ‘no_of_lines_per_page’  -- In this case I have fixed 40 lines per page.

<xsl:variable name="no_of_lines_per_page" select="number(40)"/>

 

3) Declare incontext variable for inner group (G_INVOICES), variable is called ‘inner_group’

<xsl:variable xdofo:ctx="incontext" name="inner_group” select=".//G_INVOICES"/>

 

4) Open the Inner Loop

   <?for-each:$inner_group?>

 

5) Before putting any elements with the help of current record pointer 'position()’, I am checking if the current position is modulizing with the no_of_lines_per_page equals zero or not. If it reaches the first record after modulizing then I will create local variable 'first_rec' and initialize it with '0'.

<?if:(position()-1) mod $no_of_lines_per_page=0?><xsl:variable name="first_rec" xdofo:ctx="incontext" select="position()"/>

 

Note : -- Above 3 steps ( 3,4,5) are created under ‘V_inner_group_And_V_First_rec’ form-field. Here there is limitation of Microsoft-word. We can enter upto 138 characters only in ‘Status’ field of ‘Add help text’ button.If you want to add more , you can do this by clicking on ‘Help Key’  which is adjacent to ‘Status’ tab.

 

6) If above condition holds true then we will iterate the inner loop.

<?for-each:$inner_group?>

 

7) I will check with the help of current record pointer 'position()' that the current record position is either greater than 'first_rec' i.e. the first record or less the 'no_of_lines_per_page' value set up earlier. If it is then show the record otherwise not otherwise it will not go in loop.

   <?if:position()>=$first_rec and position()<$first_rec+$no_of_lines_per_page?>

 

8) Here I am closing the inner for loop and if condition

   <?end if?><?end for-each?>

 

9) Here I am checking if no_of_lines of invoice is modulizing with the no_of_lines_per_page equals to zero or not ,and the same time I am checking if $first_rec+$no_of_lines_per_page is greater than no_of_lines of invoice or not. This is important step for filling the blank rows.

<?if:not(count($inner_group) mod $no_of_lines_per_page=0) and ($first_rec+$no_of_lines_per_page>count($inner_group))?>

 

 

10) Now I am calling sub-template recursively for filling the blank rows. While calling this template I am passing one parameter which is having value of no_of_rows to fill. Sub-template will have just one row table.

<xsl:call-template xdofo:ctx="inline" name="countdown"><xsl:with-param name="countdown" select="$no_of_lines_per_page - (count($inner_group) mod $no_of_lines_per_page)"/></xsl:call-template>

 

11) Sub-template declaration

   <xsl:template name="countdown">

   <xsl:param name="countdown"/><xsl:if test="$countdown"><xsl:call-template   

   name="countdown"><xsl:with-param name="countdown" select="$countdown - 1"/>  

   </xsl:call-template></xsl:if>

   </xsl:template>

 

12) I have created page break after the fixed number of rows have been displayed.

   <xsl:if xdofo:ctx="inblock" test="$first_rec+$no_of_lines_per_page<=count($inner_group)">

      <xsl:attribute name="break-before">page</xsl:attribute>

   </xsl:if>

 

13) Finally closing outer if and inner for loop and outer for loop.

   <?end if?><?end for-each?><?end for-each?>

 

If you want more information then please contact me on This email address is being protected from spambots. You need JavaScript enabled to view it.

 

Thanks

Darshan

 


Samples available for Download
Sample XML Data File
Sample Payables Check Printing RTF File


Anil Passi

Comments   

0 #1 pandit 2007-06-09 00:00
hi Darshan/anil

Thanks for sharing the knowledge
i am learning apps your site really helps
with respect to this article i would like to know the basics of XML programming , if you can provide some basic exaples or link for that
regards
Quote
0 #2 Dhaval Rathod 2007-06-09 00:00
Darshanbhai....

Great Job...
I am pleased to work with you.
This document is wonderful.... it will really help to all of us.

Regards,
Dhaval Rathod
Quote
+1 #3 Anil Passi 2007-06-15 00:00
Hi Mitra

To learn XML visit www.w3schools.com

I learnt my XML from that site.

Thanks
Anil Passi
Quote
0 #4 uma 2007-06-18 00:00
Hi Darshan,
Thank s for your Information. We need to develop same thing for my client. very nice...
Thanks tonn..
Quote
0 #5 Baji 2007-06-25 00:00
Hi Darshan/Anil,

i am new to XML Publisher, can u tell me the steps that r to be followed when create a report using XML Publisher.

R egards
Baji
Quote
0 #6 Anil Passi 2007-06-25 00:00
Please visit this link
http://www.google.com/search?q=site:apps2fusion.com+xml-publisher-concurrent-program-xmlp

thanks
anil
Quote
0 #7 Jay 2007-06-27 00:00
Anil,

Can i put reference of your articles on my page?

Thanks ,
Jay
Quote
0 #8 Anil Passi 2007-06-27 00:00
Dear Jay

Of course you can give links onto here
Its all about sharing the knowledge

ch eers
anil
Quote
0 #9 Anil Passi 2007-07-02 00:00
Hi Raj

Possibly Oracle thinks that you are still running your report via XMLP.

Assuming all that you need is new XML Output, I suggest you do this:-
1. Query the concurrent program
2. Use copy concurrent program into xx temp xmlp, with parameters
3. Include this in record group
4. Run this cocurrent program
5. Pick XML
6. Modify template and attach that to EBS
7. Disable xx temp xmlp
8. re-enable your template
9. run your original program

Than ks
Anil Passi
Quote
0 #10 cma 2007-07-03 09:03
Hi,
My requirement almost similar.But the output should be in RTF format.When I am trying with this.I am getting blank pages in the middle of the report.Can you please help me.

Regards,
c ma
Quote
0 #11 Anil Passi 2007-07-03 21:33
Hi CMA

It appears that the issue is most certainly with your RTF Template.
In the RTF Template, go to "Page Setup" option and within Layout tab see if "Different first page" checkbox is checked? If so, try to uncheck this and try again

Thanks,
Anil Passi
Quote
0 #12 cma 2007-07-04 10:02
Hi Anil Passi,
Different first page is unchecked.But still I am facing this problem.Pdf layout is coming but its creating problem when the output type is RTF.Also added to this,when I run this in oracle the request is ending in completed warning.When I checked the OPP log the following is the log
[7/3/07 10:50:25 AM] [UNEXPECTED] [1131929:RT1885 7336] java.lang.refle ct.InvocationTa rgetException

at sun.reflect.Nat iveMethodAccess orImpl.invoke0( Native Method)

at sun.reflect.Nat iveMethodAccess orImpl.invoke(N ativeMethodAcce ssorImpl.java:3 9)

at sun.reflect.Del egatingMethodAc cessorImpl.invo ke(DelegatingMe thodAccessorImp l.java:25)

at java.lang.refle ct.Method.invok e(Method.java:5 85)

at oracle.apps.xdo .common.xml.XSL T10gR1.invokePr ocessXSL(XSLT10 gR1.java:580)

at oracle.apps.xdo .common.xml.XSL T10gR1.transfor m(XSLT10gR1.jav a:378)

at oracle.apps.xdo .common.xml.XSL T10gR1.transfor m(XSLT10gR1.jav a:197)

at oracle.apps.xdo .common.xml.XSL TWrapper.transf orm(XSLTWrapper .java:156)

at oracle.apps.xdo .template.fo.ut il.FOUtility.ge nerateFO(FOUtil ity.java:916)

at oracle.apps.xdo .template.fo.ut il.FOUtility.ge nerateFO(FOUtil ity.java:869)

at oracle.apps.xdo .template.fo.ut il.FOUtility.ge nerateFO(FOUtil ity.java:204)

at oracle.apps.xdo .template.FOPro cessor.createFO (FOProcessor.ja va:1535)

at oracle.apps.xdo .template.FOPro cessor.generate (FOProcessor.ja va:925)

at oracle.apps.xdo .oa.schema.serv er.TemplateHelp er.runProcessTe mplate(Template Helper.java:210 8)

at oracle.apps.xdo .oa.schema.serv er.TemplateHelp er.processTempl ate(TemplateHel per.java:1368)

at oracle.apps.fnd .cp.opp.XMLPubl isherProcessor. process(XMLPubl isherProcessor. java:245)

at oracle.apps.fnd .cp.opp.OPPRequ estThread.run(O PPRequestThread .java:153)

Cau sed by: oracle.xdo.pars er.v2.XPathExce ption: Variable not defined: 'inner_group'.

at oracle.xdo.pars er.v2.XSLStyles heet.flushError s(XSLStylesheet .java:1526)

at oracle.xdo.pars er.v2.XSLStyles heet.execute(XS LStylesheet.jav a:517)

at oracle.xdo.pars er.v2.XSLStyles heet.execute(XS LStylesheet.jav a:485)

at oracle.xdo.pars er.v2.XSLProces sor.processXSL( XSLProcessor.ja va:264)

at oracle.xdo.pars er.v2.XSLProces sor.processXSL( XSLProcessor.ja va:150)

at oracle.xdo.pars er.v2.XSLProces sor.processXSL( XSLProcessor.ja va:187)

... 17 more

Regards,
CMA
Quote
0 #13 Anil Passi 2007-07-04 10:10
Hi CMA
The error below is an internal XMLP error.
oracle.x do.parser.v2.XP athException: Variable not defined

Please raise SR with Oracle, as I think you might be hitting some bug in XMLP.

Thanks
A nil
Quote
0 #14 narain 2007-07-10 02:06
Hi Anil,

I have a very basic question about generating xml output for Check printing. In the check print setup i found we are using executable APXPBFEG. Now I have made a copy if this program and set the output to xml. I will assign it to the format payment program. I am not clear after this step. Can you please suggest something?
Than ks
narain
Quote
0 #15 APassi 2007-07-10 06:41
Hi Narain

I think to begin with you need to get familiar with basics of XMLP.

This can be found on link http://www.google.com/search?q=site:apps2fusion.com+xml-publisher-concurrent-program-xmlp

Thanks,
Anil
Quote
0 #16 narain 2007-07-10 21:03
Hi Anil,
Sorry i dint phrase that question correctly. I was running the format program directly from sysadmin to get the XML output. I just realised I have to submit the check(from payables) and then the XML gets generated. Thanks for you patience

Narain
Quote
0 #17 kishore Ryali 2007-07-11 10:04
Hi Darshan
thnx a lot for a very useful article.
i will try to run the template with sample data and try some variations in it.

but presently i couldnt get the preview from XML Template Builder, which used to work prefectly before. I tried re-installing it, but in vain. When i press Preview from the menu, nothing happens.

Regar ds
Kishore
Quote
0 #18 kishore Ryali 2007-07-11 11:52
Hi Darshan
Preview is working after i installed the latest version of XML Template Builder from http://edelivery.oracle.com

Regards
Kisho re
Quote
0 #19 Joy 2007-08-02 23:54
Darshan/Anil
I think a simpler approach would be to use hidden tables in the rtf template
Quote
0 #20 pp 2007-08-07 11:17
Above 3 steps ( 3,4,5) are created under ‘V_inner_ group_And_V_Fir st_rec’ form-field. Here there is limitation of Microsoft-word. We can enter upto 138 characters only in ‘Statusâ €™ field of ‘Add help text’ button.If you want to add more , you can do this by clicking on ‘Help Key’ which is adjacent to ‘Statusâ €™ tab.
thats whats written in the above article please tell me what if the code does'nt even fit there?????????? where can i add more code????
Quote
0 #21 madhavi 2007-08-10 10:57
hi anil,
i am a technical consultant working on r12 xml publisher.
crea ted xml file and rtf template.
my issue is have to create concurrent program to register & run a report.how to do that can u pls help me out if permits with necessary screenshots.
th ax in advance.struggl ing alot.
thx
madha vi
Quote
0 #22 Ashi0407 2007-08-13 05:09
Hi,

I need the sql used to generate the Xml availbale here for download. If it is .rdf then please provide me the same as well
Quote
0 #23 Yuvaraj 2007-08-13 14:45
Thanks for sharing the knowledge
i am learning apps from your site and your site really helps

with respect to this article i would like to know the basics of XML programming , if you can provide some basic examples or link for that
Quote
0 #24 vsrao 2007-08-13 22:43
Hi,
I am unable to display the barcodes.Initia lly I am able to display the barcode using Code128 font but I am trying to encoding the barcode by using the blog http://blogs.oracle.com/xmlpublisher/discuss/msgReader$281 , even barcodes are also not displaying. So please help in this regard.

Thanks ,
SubbaRao
Quote
0 #25 NaveenK 2007-08-14 17:17
Anil,
This article is awsome. Really helped me a lot. I need little more on this template.
Could you please tell me how to add page totals, and if there are more than one page I want to print check on every page with "VOID ON THAT" and print signature only on last check page.

I appriciate you response

Thank s
Naveen
Quote
0 #26 NaveenK 2007-08-17 13:40
Anil/Dharsan

N ice artilce,
I want the subsequent copies of the check to print VOID on them. How can I do this?

Thanks in Advance
Naveen
Quote
0 #27 Anupama C 2007-08-21 20:55
Hi Anil,

I am writing the RTF template for XMLP Report. And i have a situation that i am displaying the total of Adjustment and payment made on each invoice and lines level.

And like this i may have several invoices under one Customer. So when i am running the total for Invoice level payment and Invlice level adjustment on the customer level. It is not showing me the proper total.

I wants to use the Variable in my RTF template. Can u tell me how to do that.
Quote
0 #28 Madhukar 2007-08-27 12:56
Hi Anil,

I am workin gon Print Po Report, i have a requirement that i have to display the Buyer signature (sign.gif) file based on the buyer parameter at run time. for this im using url:{conca t('${OA_ME DIA}','/', IMAGE_FILE) 5; method here sign.gif
Quote
0 #29 Madhukar 2007-08-27 13:37
Hi Anil,

I am workin gon Print Po Report, i have a requirement that i have to display the Buyer signature (sign.gif) file based on the buyer parameter at run time. for this im using url:{conca t('${OA_ME DIA}','/', IMAGE_FILE) 5; method here sign.gif
Quote
0 #30 krishna kishore 2007-08-27 18:13
Hi Anil,
I am working on the AP check print report using xml publisher.I am using standrd report Format Payments (Everygreen,for m feed)-APXPBFEF for printing the checks and I am running the report from the payment->entry> payment btaches.My probelm is when we submit the request the from the payment btaches,its printing only the xml tags ,it did not bring the xml templates?Can you help me out how to bting xml layouts from the payment batches?

thank s in advance
krishna kishore
kumar
Quote
0 #31 shank 2007-08-28 12:33
hi Darshan/Anil,
I am trying to convert Invoice report to XML. I find an article 'Converting Reports from Oracle Reports to Oracle BI Publisher' using BIPBatchConvers ion, in download.oracle .com where they have given steps for converting reports to XML. You have any opinion on it. Have you tried it?
Quote
0 #32 Madhukar 2007-08-30 20:10
Hi Darshan/Anil,

Its a Great article, helping to many people.i learned many things from this.I have some issues in my Print PO Report could you pls clarify, i appriciate u r response..thank u.
My client was using Oracle Apps reports and Optio Reports (for Printing the Layouts), now my client wants to convert Oracle Apps reports to ‘XML publisherâ€⠄¢ Reports .Now i am working on "Print PO report" my reuirement are :

1. Dispalying the Image (james.gif) signature file dynamically based on the 'Buyer' (parameter), im getting the buyer (james) name and buyer email address() in XML file and in the $OA_MEDIA directory the related file is james.gif
how to get the james.gif file from the $OA_MEDIA directory in to Oracle Reports (in to RDF) or if this is possible in the RTF Templates how to handle this in RTF templates?

2.f or the above report i hve to email/fax to perticular supplier based on email address/fax number.

3. running the Batch Reports: for the above report im getting the pDF output for perticular PO number = 1001, where as in the Batch processing (running the Ten PO's in a batch) how to handle all the Po's output in the same/different RTF Template ? and after getting the OutPut i have to email/fax to different suppliers based on the PO NUMBER ( for suppose out of PO#1001 to PO#1010 PO's i have to semail/fax PO#1001 to supplier A, and PO#1002 to supplier B .Where as previously this was handling by Optio Reports im not sure abt Optio reports but as per my KT i came to know this.

4.Suppos e in the report if i have 10 lines, 8 lines printed on the first page and 2 on the second page.. immediately im displaying the total with some NOTE, and email ddress..
here my requirement is, In the second page if i get the less number of lines in the second page i have to display the TOTAL and EMAIL ADDRESS and NOTE at the bottom of the page.

5. How to develop multilanguage RDF Templates and how to set the Multilanguage Templates (different templates) at run time based on the OPER.UNIT and SUPPLIER COUNTRY my requirement is ..based on the oper.unit and supplier country i have to select the RTF template (English,spanis h and Portuguese languages)at run time and email/fax/print the report?

I Appriciate your response.

Than ks in Advance.
Madhu
Quote
0 #33 shank 2007-08-31 10:19
Hi Everybody,
I am converting invoice rdf report to XML. Do anyone have any idea on how we can use format triggers in XML report?

Thanks in advance,
Shanka r
Quote
0 #34 raj naik 2007-09-02 21:28
Hi Anil,

I am having issue with the Invoice on pre-printed stationary....

I have used darshans template, but mine is bit complex i am having two sub groups below Main group.. Isssue is, i am able to fix the length for the first sub group but for second sub group i am unable to do so. Besides that my second group resets it self and start from the first record.Uploadin g the rtf template and xml file.Appriciate your help..

--Raj
Quote
0 #35 Amitav 2007-09-10 05:53
hi,
Currently the description field is limited to 30 char only. When the description exceeds 30 chars and we have to show the full description, then the template seems to be not working, the count($inner_gr oup) only counts the printed no. of rows for the group.It does not take into account the extra lines due to wrapped up data.
Can anyone suggest how to handle such situations?

Th anx
Amitav
Quote
0 #36 Diane 2007-09-12 23:29
Dear Anil/Darshan

T his is the best site that I have found to get help with XML Publisher. Your example in this article is exactly what I needed to create our check forms with XML publisher. I could have never figured this out on my own without this article.

I am having on minor problem with my template and I was wondering if you had any advice. The layout of our check forms has the check portion at the bottom of the page. The top of the page is the stub with the repeating lines. I'm finding that the more lines of output that I have on the stub, the farther down the page the end of the stub box floats. I'm using courier new font and it should be fixed width and height, but something is causing the repeating area to grow and this is pushing the check portion of the layout off the end of the page. Any suggestions would be greatly appreciated!!

Thanks,

Diane
Quote
0 #37 Madhukar 2007-09-13 13:00
Hi Anil/Darshan,

pls answer this issue.
How can I retrieve additional data from tables using the XML Publisher. We are using XML Publisher 5.6.2 v. What we are trying to do is to display additional data that is not a part of the standard oracle seeded report output.
We have seeded reports in Oracle apps. Lets take an example of a purchase order report. Say the seeded out-of-the-box report has the following information:
PO number, PO details

I can go ahead and use the template builder and create a nice looking report with that information.

Now, lets say that I want to display the supplier name in my purchase order report. Since the seeeded purchase order report does not have the supplier name (it is not there in the xml generated by the standard out-of-the-box report), the only way I can display the supplier name on the report is by querying up the supplier table and getting that information. I know that I can go ahead and modify the existing out-of-the-box report, but I do not want to do that. I do not have control over the XML that is generated since the XML is generated when the report is run. Is there any way to retrieve the extra information (the supplier name in this example) AFTER the xml has been generated and BEFORE the template is applied ?
I really appriciate your response.

Than ks,
Madhu
Quote
0 #38 Geetha24 2007-09-14 01:01
Hi Darshan,
I'm working on R12. Can you tell me which the standard report that I need to use for the check printing in R12?

Thanks
Ge etha
Quote
0 #39 we 2007-09-24 21:02
Hi all,
This site is doing great. Thanks for all your work.

Thanks,
Sd
Quote
0 #40 Akhilesh Agrawal 2007-09-24 21:05
Hi Darshan/Anil

I am having issues with the consolidated Invoice on pre-printed stationary...
I need to fix the number of lines in the first page. I am using the Invoice template we have in the current system. But Here i am having two sub groups below the main group and i couldn't able to fix the number of lines. I couldn't able to attch my template here, let me know how can i sent that to you.

Thanks in advance,
Kumar
Quote
0 #41 Mohammad Rafi.Shaik 2007-11-07 08:13
Hi,
I have a requirement as Multiple Layouts in a single RTF and each layout in the RTF opening in a new or Seperate PDF or EXCEL
Can you eloborate on the solution
Thanx In advance
Mohamma d Rafi.Shaik
Quote
0 #42 Mayank Jain 2007-11-08 05:39
Hi Anil,

I have been working on XML Publisher since past few months and couls successfully implement XML Publisher functionality called "Bursting Engine". I have prepared a white paper on this and would like to share with all through the medium of this site. Please let me know how would you like me to go ahead with this task.

Thanks and regards,
Kalyan i
Quote
0 #43 punit 2007-11-12 15:46
I have a requiremnt where we have abt 8-9 differnt layouts for ame report, Based on few parameters we want to dynamically choose a specific layout, we do not want the user to choose any specific layout.
Request you to pls guide me how to go abt this.
Quote
0 #44 JaxDan 2007-11-13 00:06
Hi Anil,
I have few problems in page breaks in the XML publisher
1) I have two detail blocks for a master. How to do the page break if the information is not fitting in one page.
2) How to check the page number and do the page break accoringly, say if the output is having 2 pages, I would like to move certain information to the second page.

Thanks
Quote
0 #45 Veena Shetty 2007-11-15 13:43
Anil
I am working on the AP check print report using xml publisher.I am using standrd report Format Payments (Everygreen,for m feed)-APXPBFEF for printing the checks and I am running the report from the payment->entry> payment btaches.My probelm is when we submit therequest the from the payment btaches,its printing only the xml tags ,it did not bring the xml templates?Can you help me out how to bting xml layouts from the payment batches?

i am planning to use the solution to call FND_REQUEST.SET _PRINT_OPTIONS)
and calling template using fnd_submit (FND_REQUEST.SU BMIT_REQUEST) XDOREPPB. is this a practical solution.
Please advice
Quote
0 #46 prabu 2007-11-22 05:29
Hi,

I am new to XMLP and developing RTF for AR Invoice Report.
When i try to view the output in pdf format.In the Invoice lines details there is more gap between the lines,For e.g if i have five lines for single invoice, many gaps between the lines and also for each line it shows in indiviual rows.

please help on this where to correct to get the line details one after another.

with regards
prabu
Quote
0 #47 Santhosh Kumar S 2007-11-22 06:43
Hi Darshan/Anil,

I ma writing you first time and hoping for good solution!

I have developed number of reports in XML publisher but all were based on
XML output file from RDF.
Now my requirement is to make Data template to make XML report,We dont have RDF for the report.
Please suggets me the steps!

Regards,
Sumit Mittal
Quote
0 #48 jagadish 2007-11-28 08:47
Hi Darshan,
i am working on invoice report, on the top i have customer details, and on below i have invoice totals etc, in between these two my invoice lines will start, i have created table in RTF template for invoice lines, my problem is Suppose in the report have 10 lines, 6 lines printed on the first page and 3 goes to the second page, i am not getting table end line on first page, its printing only after end of all the records.
one more thing is i dont want line in between each record.
Please suggest me.

Regards,
J agadish
Quote
0 #49 Mark 2007-11-30 04:17
Hi,
I would like to print page totals in my a xml report
please tellme the steps i shou;ld follow to get the page totals.
Quote
0 #50 Wazid 2007-12-04 05:58
This is great site.I have two queries
1. How to handle blank pages .Iam getting blank page after main details.For eg you have project which have assembly details.After printing the first assembly details it is printing blank page then starting with second assembly details.

2. How do we handle duplicate rows in XMLP?
Iam giving the eg of xml data.It consists of 4 groups.Lets say
G1-project-11
G2- main assembly-22
G3- shortages-Purch ase Order
G4- Po Number-44
G1- It will have project details
G2- will have main assebly details for that project
G3- Shortages for the main assembly
G4- Shortages details such as purchase order details

When you run the template you will have duplicate rows ie above group data repeating two times ie.
1st receord
project -11
main assembly-22
shortages-Purch ase Order
Po Number-44
2nd record
project- 11
main assembly-22
shortages-Purch ase Order
Po Number-44
Can you help in this how do i restrict single record.
Quote
0 #51 Swechhya 2007-12-23 05:33
hi anil
hi i want XML reports tutorial notes from scrach onwords
ok
than ks
Quote
0 #52 Mani 2007-12-28 03:22
Hi Anil,

This site is very informative and simple to understand. Need your help...

I'm trying to convert the Oracle Reports to XML Publisher. The Steps I have followed are,

1) Open the report in Report Designer and convert to .xml using file conversion menu.
2) Transfered the .xml file into $JAVA_TOP
3) using RTFTemplateGene rator class, created the .RTF file. During this process another logfile which holds the Format trigger information also created.
4) Created the datadefinition using XML Publisher Responsibility and the code I have given the same as the short name of the concurrent program.
5) Created the Template and attached the datadefinition created in step 4.
6) Attached the .RTF file created in step 3 with the template.
7) Open the concurrent program definition using System administrator responsibility and the output type as 'XML'.


When I executed the program, the lexical parameters used in the .RDF and the format triggers are not handled in the conversion.

Co uld you please advice how to handle the lexical parameters and the format triggers used in the .RDF files. If possible, please give me an example.

Thank s in advance for your help.

Regards,
Mani
Quote
0 #53 Navneet 2008-01-14 17:49
Hi Anil/Darshan,

I am working on same thing.I need to print void on checks if the number of invoices overflow to the second page.I tried using ur steps but was not able to get the same.Can u help me out.

Thanks,
N avneet
Quote
0 #54 Navneet 2008-01-14 19:24
Hi Anil/Darshan,

I am working on same thing.I need to print void on checks if the number of invoices overflow to the second page.I tried using ur steps but was not able to get the same.Can u help me out.

Thanks,
N avneet
Quote
0 #55 SureshV 2008-02-06 20:24
Hi Darshan,
I am working on one of the pre printed stationary report. They have comments column in the report. This comment can take maximum of 4 lines in the stationary. But the column which stores the data is of 4000 chars and hence user can enter good amount of data.
The requirement is that when column has data that is not fitting in 4 lines.. the row expands until it displays all the data. This causes all tables and rows below that to move down. I have set the row property to 2 inches exactly but this is not helping. The catch here is that by doing this if we manually key in the value for the row in the .rtf file only first 4 lines are visible and rest are not displayed as the row does not expand, but the same behaviour is not with the actual data when previewed with xml.
Please let us know if there is a way to tackle this.

Thanks,
Suresh
Quote
0 #56 navneet 2008-02-13 06:23
Hi Anil,

I Am facing an issue.In my report,the length of aline is not fixed,it varies with data.so the no of lines per page cannot be fixed.Is there some other method by which i can keep the lentgth of table constant??

Its urgent.Please hep me out.

Thanks,
N avneet
Quote
0 #57 Sultan 2008-02-15 16:46
Hi Darshan ,

Great work.. I have tried similar implementation in our office and works real great ..
I have used PDF template for preprinted sttionary thou..

I am having problems with routing to printers when submitting a report from Applications.We wanted to automate the process of invoice printing .. but he hurdle is to route to a printer..

Any thoughts or an article..

Thanks
Quote
0 #58 Manuami 2008-02-18 19:37
Hi Anil,
I need few drops from your sea of knowledge..

Du tch and US have diffrent requirements for layout. I've created two RTF and attached them to single Template(Create d one and than Add File). But when I submit the program , asyou know it submits it for Multiple LAnguage and than in turn the invoice print program. But it always picks US layout(Default language AMERICA).
Could you please throw some light on it or anyone.
Thanks
Manu -
Quote
0 #59 Manuami 2008-02-18 19:44
Just to clarify-- I submit program from Dutch responsibility, I also change the layout to the one for Dutch. But when the programs runs it picks up US layout.

I would highly appreciate any direction on this, can't ignore to mention ur's is a Great website.

Thank s
Manu
Quote
0 #60 Jesus Castillo 2008-02-20 17:35
Hi all,

I am creating a template to print AR Invoices in which I need to print a detachable part of it at the last page of each invoice. I am following the steps that Anil recommended using sub-templates, but for some reason it is not working. Below you will find the error I am getting.

Font Dir: C:\Program Files\Oracle\XM L Publisher Desktop\Templat e Builder for Word onts
Run XDO Start
RTFProces sor setLocale: en-us
FOProcess or setData: U:\XMLP Reports\Receiva bles\Open AR Invoices.xml
FO Processor setLocale: en-us
java.lang .reflect.Invoca tionTargetExcep tion
at sun.reflect.Nat iveMethodAccess orImpl.invoke0( Native Method)
at sun.reflect.Nat iveMethodAccess orImpl.invoke(U nknown Source)
at sun.reflect.Del egatingMethodAc cessorImpl.invo ke(Unknown Source)
at java.lang.refle ct.Method.invok e(Unknown Source)
at oracle.apps.xdo .common.xml.XSL T10gR1.invokePr ocessXSL(XSLT10 gR1.java:586)
a t oracle.apps.xdo .common.xml.XSL T10gR1.transfor m(XSLT10gR1.jav a:383)
at oracle.apps.xdo .common.xml.XSL T10gR1.transfor m(XSLT10gR1.jav a:201)
at oracle.apps.xdo .common.xml.XSL TWrapper.transf orm(XSLTWrapper .java:161)
at oracle.apps.xdo .template.fo.ut il.FOUtility.ge nerateFO(FOUtil ity.java:1015)
at oracle.apps.xdo .template.fo.ut il.FOUtility.ge nerateFO(FOUtil ity.java:968)
a t oracle.apps.xdo .template.fo.ut il.FOUtility.ge nerateFO(FOUtil ity.java:209)
a t oracle.apps.xdo .template.FOPro cessor.createFO (FOProcessor.ja va:1561)
at oracle.apps.xdo .template.FOPro cessor.generate (FOProcessor.ja va:951)
at RTF2PDF.runRTFt o(RTF2PDF.java: 626)
at RTF2PDF.runXDO( RTF2PDF.java:46 0)
at RTF2PDF.main(RT F2PDF.java:251)
Caused by: oracle.xdo.pars er.v2.XPathExce ption: Variable not defined: '_MR'.
at oracle.xdo.pars er.v2.XSLStyles heet.flushError s(XSLStylesheet .java:1526)
at oracle.xdo.pars er.v2.XSLStyles heet.execute(XS LStylesheet.jav a:517)
at oracle.xdo.pars er.v2.XSLStyles heet.execute(XS LStylesheet.jav a:485)
at oracle.xdo.pars er.v2.XSLProces sor.processXSL( XSLProcessor.ja va:264)
at oracle.xdo.pars er.v2.XSLProces sor.processXSL( XSLProcessor.ja va:150)
at oracle.xdo.pars er.v2.XSLProces sor.processXSL( XSLProcessor.ja va:187)

Any help you can provide me would be greatly appreciated.

T hanks in advance,
Quote
0 #61 Peter 2008-03-03 13:35
Hello Anil,

I am using XML Publisher version 5.6. I have build a template the same way you did yours using the template builder. I loaded a data source and than test the template. Everything looks good. I am getting correct page number. Than i created a data definition and upload my template in oracle Apps R11 XML publisher Module. After running the request, i am getting wrong ouptut for the page numbering .( in my template, i am using to reset the page number for every customer
sateme nt). Now if a customer have multiple invoices that needs to be print on 4 pages, i am getting the error - for example on the last page : page 4 of 1 when i run it from apps.

Please i need to know why i am getting a false output for the page number when running
the template from oracle apps requests.

Plea se Anil i need you to reply ASAP... because it is urgent.

Thanks for you support!
Quote
0 #62 Ramkumar 2008-03-12 10:25
Hi,
how to design template as the above example you are provided.

rega rds
ram
Quote
0 #63 vandsuri 2008-04-16 12:09
Hi,

I did understand that we can get the XML is generated by Oracle Application Concurrent Program (for Oracle Reports).

My question is what if we want to develop a new (custom report) report from scratch in XML Publisher? I mean developing a RDF, converting data in XML format and then using the XML Publisher is a two way process right. How do we develop a new custom report in XML Publisher from scratch? (with all those features, formula columns, summary columns..etc we use in reports 6i for developing an RDF. How do we do the same using XML Publisher)

Tha nks
Suri
Quote
0 #64 Valeria 2008-05-13 17:27
Hello Darshan,
How do I send a output type of RTF from XML Publisher to the printer? We are currently send the out put of the check as PDF Publisher but I want to to send it to the printer (Troy Printer) and let the printer use its format to print.
Quote
+1 #65 Gudipudi 2008-06-29 12:01
Hi Anil / Experts on XML.

I have a situation in One PO template. I am creating a Template in RTF mode and when I am looking in Preview in pdf the detailed section of the lines are moving to next page. I am not sure how can I fit to page wise. Also if the no of lines is more than a page then Immediate page should start with Header and it is not coming. I Defined Heder loop too but still it is not coming. Any Ideas ? Any customized word RTF template please share.

Thanks,
Quote
0 #66 siddhartha doshi 2008-07-28 02:48
Hi,

I am working on check printing report but not able to set page numbering can u tell me.

This is rtf report and i have done follwing things go to insert--> Page numbers -- > It is setting the page number but it gets reset at each every change record check group.

Is there is any way to see all pages with count 1,2,3..


Thank s in advance

Regards,
Sidd hartha
Quote
0 #67 anuradha 2008-08-28 07:43
Hi,

In the RTF template I should print a section on the last page that to at the end of the page. I've tried using tags but its not working.


Can you please let me know how can this be chieved?

Regar ds,
Anuradha
Quote
0 #68 Ram 2009-04-17 02:27
Hi Darshan,
I need your help.
I have similar requirement that you mentioned in your demo, but check needs to printed only in the first page. Not on every page.

Problem description Points
1. User selects multiple invoices for payment and pay them using a single check.
2. Till #17 invoices, my template work properly.. but when it exceeds no. records as 17, then the record data is printing in check area(Stationary ).
3. So to avoid this, I need to reserve the area as it is.. no records should come into that area..
4. User idea is.. if there are more invoices to print, he feed printed stationary(chec k attached at the bottom of this page) as a first page and rest of the papers are blank ones(no check).

Please help.
Quote
0 #69 Paresh 2009-07-17 13:21
Hi Darshan,

I'm stuck at one point and would appreciate any help/suggestion /pointer

I'm trying to preivew a report from BI Desktop Publisher, I've imported the same data xml file, but on trying to preview I get the following error:
ConfFile : D:\Siebel\BI Publisher Desktop\Templat e Builder for Word\config\xdo config.xml
Font Dir: D:\Siebel\BI Publisher Desktop\Templat e Builder for Word onts
Run XDO Start
Template: D:\Siebel\BI_DE MO\aclist.rtf
R TFProcessor setLocale: en-us
FOProcess or setData: D:\Siebel\BI_DE MO\BIP Accounts - Current Query.xml
FOPro cessor setLocale: en-us
java.lang .reflect.Invoca tionTargetExcep tion
at sun.reflect.Nat iveMethodAccess orImpl.invoke0( Native Method)
at sun.reflect.Nat iveMethodAccess orImpl.invoke(U nknown Source)
at sun.reflect.Del egatingMethodAc cessorImpl.invo ke(Unknown Source)
at java.lang.refle ct.Method.invok e(Unknown Source)
at oracle.apps.xdo .common.xml.XSL T10gR1.invokePr ocessXSL(Unknow n Source)
at oracle.apps.xdo .common.xml.XSL T10gR1.transfor m(Unknown Source)
at oracle.apps.xdo .common.xml.XSL T10gR1.transfor m(Unknown Source)
at oracle.apps.xdo .common.xml.XSL TWrapper.transf orm(Unknown Source)
at oracle.apps.xdo .template.fo.ut il.FOUtility.ge nerateFO(Unknow n Source)
at oracle.apps.xdo .template.fo.ut il.FOUtility.ge nerateFO(Unknow n Source)
at oracle.apps.xdo .template.FOPro cessor.createFO (Unknown Source)
at oracle.apps.xdo .template.FOPro cessor.generate (Unknown Source)
at RTF2PDF.runRTFt o(RTF2PDF.java: 629)
at RTF2PDF.runXDO( RTF2PDF.java:45 4)
at RTF2PDF.main(RT F2PDF.java:289)
Caused by: oracle.xdo.pars er.v2.XPathExce ption: Extension function error: Class not found 'com.siebel.xml publisher.repor ts.XSLFunctions '
at oracle.xdo.pars er.v2.XSLStyles heet.flushError s(XSLStylesheet .java:1534)
at oracle.xdo.pars er.v2.XSLStyles heet.execute(XS LStylesheet.jav a:521)
at oracle.xdo.pars er.v2.XSLStyles heet.execute(XS LStylesheet.jav a:489)
at oracle.xdo.pars er.v2.XSLProces sor.processXSL( XSLProcessor.ja va:271)
at oracle.xdo.pars er.v2.XSLProces sor.processXSL( XSLProcessor.ja va:155)
at oracle.xdo.pars er.v2.XSLProces sor.processXSL( XSLProcessor.ja va:192)
... 15 more

I've placed the XSLFunctions.ja r file in the BI_Publisher\oc 4j_bi\j2ee\home \applications\x mlpserver\xmlps erver\WEB-INF\l ib folder.

Do you have any idea how to get around this issue?

Thanks
Paresh
Quote
0 #70 Chithambaram Perumal 2009-08-03 08:37
Hello Sir,

I am having problem with : Last Page only Content with Section Break 'Continuous'... It doesn't work properly...
In thatIi have designed seperatly for last page and I have added the XML tag ""
and before that I have added 'Section break as Continuous' It shows 4 pages instead of 2 pages...It creates double of required
pages..plz help to solve this problem....urge nt

Thanx in Advance
Chitham baram Perumal
Quote
0 #71 Abdulrahman Mohammed 2009-09-06 20:53
Dear Mr. Anil passi /Mr Darshan Bhavsar,

i m a huge fan of Apps2fusion. i m proud to say our team implemented many solutions successfully after going through your site Namely
Bursting Solution From Prasad , we implemented for pay slip
WEBADI Solution for inventory Receipts.
Oracl e Collections for custom requirement.

t hanks for the wonderful article, you guys are doing great service, May Almighty increase your tribe.

i have a silly issue with an RDF report for Pay Slip, the report output goes to Dot Matrix Printer for Pre Printed Stationary.

no w i am not a great fan of RDF( after xml publisher came) so i want to change my template to xml publisher.

Que stion is whether i should use ETEXT (b'cos it is going to Dot Matrix Printer)

or should i use the above solution for pre pre printed stationary , please comment .

Many thanks and god bless

your happy Fan

Abdulrahma n
Quote
0 #72 Neelima82 2009-10-06 18:21
Hi,

I have an issue with my XML Publisher report.
My template has 5 pages. The 5th page has the following condition:
Fini shed Printing for Batch

Now there are two scenarios:
1. If the batch passed is not null, the 5th page prints "Finished Printing for Batch"
2. If the batch passed is null, Do not print anything.

Now, for the second scenario, when the batch passed is null, I am getting a blank page. But I do not want this page to be printed at all for the second scenario.

Plea se let me know how I can get around this.
Quote
0 #73 Neelima82 2009-10-06 18:23
The condtion is
Finished Printing for Batch
Quote
0 #74 Neelima82 2009-10-06 18:24
The condition is
if:BATCH_PAS SED!='X' Finished Printing for batch End-if
Quote
0 #75 Nasser Sharief 2009-12-04 18:09
hi Darshan/anil

Thanks for sharing the knowledge

I have a question
I am working with 11.5.10

I am wondering if I can add code to my template to allow the pdf output to print at ‘UP100’ printer and tray number 3 by default is going to tray 2. Is something can be done at the template level? I am this code in AfterReport trigger but is not working.

funct ion AfterReport return boolean is
v_success := fnd_request.set _print_options( 'UP100', l_print_style,1 ,TRUE,'N','SKIP ');

BEGIN
srw.set_printer _tray('Tray 2');
srw.message(999 9, 'Set Printer Tray Tray 2' );
END;

l_req_id := fnd_request.sub mit_request('XD O','XDOREPPB',N ULL,NULL,FALSE, :p_conc_request _id, l_app_id, l_progran_name, 'en-US', 'N','RTF','PDF' )

Can you help?

Thanks
N asser
Quote
0 #76 ike 2010-04-13 13:30
The template shared in this forum is indeed very helpful for a lot of us. I have been tasked to develop the check printing template for our R12 upgrade using XML Publisher. My main problem now is how to make the "repeating frame" for the invoices fixed. I want to limit 15 invoices per each pre-printed check stock with a fixed number of characters (70 chars) for the description field and a limit of two lines. I have tried using the sample template but everytime I modify the horizontal length of the table to accomodate the two lines, the repeating frame becomes a variable lenght and the check is no longer fixed at the bottom of the page. Any suggestions on fixing the lenght of the invoice "repeating frame" and thus fixing the check location at the end of the page?
Quote
0 #77 Prajakta 2010-10-21 01:14
Hi Anil/Darshan,

I've created new check format for check printing in R12, registered its concurrent, data definition & template in XML. Also created payment format & profile in Payments. When I use this new check format in payments its giving me error "This file cannot be opened because it has no pages", where as when I run query in data definition through back end, it fetches data. I am not getting what is wrong in my template.

Can you plz help me.
Quote
0 #78 nagendra 2010-11-17 08:27
hi Guys,
THANKS for sharing

I am new to this forum

I would like to share with u about no of lines per page restriction in XML

here giving a example to print 10 lines per page

declare a variable


start the loop in which it has to work(for loop)


Declare a variable inside the loop which will handle the position of the record in the loop


At the end of the row checking for page break

page


if the code is not enough in addtext place remaining in help

close the for loop


its working fine
if any mistakes please ignore guys
Quote
0 #79 nagendra 2010-11-17 08:32
hi Guys,
THANKS for sharing

I am new to this forum

I would like to share with u about no of lines per page restriction in XML

here giving a example to print 10 lines per page

declare a variable

 Â


start the loop in which it has to work(for loop)
 Â

Declare a variable inside the loop which will handle the position of the record in the loop
 page


Â

At the end of the row checking for page break
 Â



if the code is not enough in addtext place remaining in help

close the for loop
 Â

its working fine
if any mistakes please ignore guys
Quote
+1 #80 Srikanth99 2011-01-05 18:05
Hi,

we have used the check printing template provided in this site for pre printed stationary. Specified to print 30 invoices per page. It prints fine if the invoice lines are more or less then 30. If the invoice lines is exatly 30 the MIRC font is printing in the next page. Any help would be greatly appriceated.

T hanks,
Sri
Quote
0 #81 judid 2011-05-11 17:46
If you experience the problem of the table not remaining static for the remittance then your problem is the table. Remove both the remittance variables and the recursive variable from tables and presto this example works great. Best of luck
Quote
0 #82 Vijay 2011-05-13 07:18
Hi,

This is Vijay kumar. This is very good solution on how to print invoice lines and check info from BI publisher. Recently we got a project to work on BI publisher reports.Since we do not have enough knowledge on BI Publisher reports we started developing small reports got some exposure.We have one requirement specific to AP Pay check report and When I am searching the forums found the rtf template you have been using with XML source attached.

I am able to modify the template with minor alignment and field changes with respect to our XML source. The only problem I had with the requirement is client want to print the check information details for the Vendor only on the FIRST PAGE.

The rtf template taken from here is printing the check details after all the detail lines are printed.
For example if I have 60 detail lines, 40(number fixed in the code) lines are printing in the first page. The next 20 lines are printing on the second page along with details. The check number 4738 is the reference.

It should print first 40 lines with check details in the FIRST PAGE and rest 20 lines in the second page or third and fourth page if we have more number of detail lines.

Can any one help with this requirement.

V ijay Vattiprolu
Quote
0 #83 Vijay 2011-05-13 07:44
I missed the subject above.
Quote
0 #84 Prahallad Mohanty 2011-06-08 16:27
Hi,

The sample template and the XML file are no longer valid in R12.1.3 . The XML Document that is generated has the repeating groups like OutboundPayment , DocumentPayable etc. Do you have any sample templates for R12.1.3?

Pleas e let me know.

Thanks,

- Prahallad
Quote
0 #85 alekha 2011-07-15 05:54
Hi Darshan,

i am new in xml publisher reports i have a requirement i got po_num:xxx it is haven 18 records i restrict the each page is 10 records my requiremnt is xxx po_num first will be have 1page and remaining 8 records are 2 page and all page numbers start with 1 page how could u help to me.....
Quote
0 #86 Prabhu Barathi 2011-11-03 10:41
Right now the check amount is printed in US format. How can we customize to display the Indian format(eleven lakhs twenty three thousand one hundred and twelve rupees and fifteen paise).
Quote
0 #87 Kara 2011-11-16 02:38
I did not understand wat your code is doing exactly so just trying to give it a simple looks ...please correct it if it is wrong and if possible please answer the question as well


for G_Checks --- ( lets say we have only 1 check then ..this loop will run for only 1 time )
for G_Invoices ---- ( lets say we have 100 invoices in one check ..will this loop run 100 times ??? )
if position()-1mod 40 =0 then
first_rec=psiti on(); ----( at first time it will be =1, )
for G_invoices ---- ( again will this loop run 100 times as we have 100 invoices in one check
----- ??.... looks like it will run 100* number of times ( position()-1 mod 40=0)
---- holds true )
---- ( if it is the case , then it will have too many iteration in case of limit per page is
---- even less than 40 ..lets say it if it is 7 per page ..then ther would be around
----- 14*100 iteration ...which is bad )

if position()>=fir st_rec AND position()
Quote
0 #88 Priya_ambo 2011-12-15 09:08
Hi,

I have a template to be build as like below:

Page1




-- If the content of Body 1 goes beyond first page, I have to repeat the and . Once that is completed




- - If the content of body 2 goes beyond that page, I have to repeat the and . Once that is completed. go further



/(in case body 3 goes beyond this page)

RTF template:

-> Repeat as row checked





On next page
, I need to print another header, but which is not to be printed on my last page. My last page header should be same as first one.
also if first page data goes on next page, it should show me header 1 only.


Please advise
Quote
0 #89 J. Lim 2012-02-07 02:48
Hello Anil,

I would like to ask for some insight regarding this. I would like to apply this code but this time for a matrix report.
I am trying to create a Purchase Order report that shows the distribution of the items in different branches and I need it to go into page break for every 10 items in the report.
I have followed the code stated in this entry: http://apps2fusion.com/at/64-kr/345-matrix-cross-tab-report-bi-publisher to create a matrix report.
I need the header to be copied in as well since the header has the branches where the items will be distributed (this is dynamic)
I have tried to incorporate the code from this entry, but so far, I have not been able to make it work. I hope you can give me some insights regarding this.
Quote
0 #90 Satya Draksharapu 2012-08-27 13:42
Hi Darshan,

I am currently converting 11i xml check print report to R12. I have noticed that the xml output is not sorted by Check Numbers by Oracle. I have tried to sort it out in XML Template, but not sucess. I tried many ways like below:

The current grouping in 12i is like below:

V_inner_group_ And_V_First_rec







I tried sort options like below:







P lease advise,
Thx,
Sa tya
Quote
0 #91 Satya Draksharapu 2012-08-27 13:46
Hi Darshan,

It looks like the coding part was missing on my earlier post.

The current grouping in 12i is like below:

V_inner_group_ And_V_First_rec







I tried sort options like below. But nothing worked.








Please advise,
Thx,
Sa tya
Quote
0 #92 Satya Draksharapu 2012-08-27 14:47
Hi Darshan,
For some reason the coding part is missing on the post when I tried last 2 times. Let me try one last time. I have typed everything this time (and not copied and pasted here).

We are in the process of upgrading to R12. I have converted 11i AP Check Payment template from 11i to R12. The process seems to be working, however the checks are not sorted by check number on the final pdf output. So I have tried using "sort" option, but not success.

The XML temlate grouping in 12i is like below:

v_inner _group_and_v_Fi rst_rec







I tried sort options like below, bot nothing worked:







Please advise,
Thx,
Sa tya
Quote
0 #93 Mathumitha 2012-12-07 05:43
Hi,

I have a similar requirement. I am generating invoice using XML Publisher- rtf template. The output format is pdf. The invoice details are printed in tabular column. The last row of the table holds the total. Irrespective of the number of rows the total must be displayed at the end of the page.
I cant use psoition() in my requirement because a single line/row from the table(database) ll hold more than one line in the template. So i tried counting the number of characters, even then there is an issue. The number of characters that a particular column can hold in a line varies with the characters displayed. Can you please suggest on how to display the total at the end of the page.

Thanks,
Mathumitha
Quote
0 #94 Karen 2014-10-14 14:55
Hello Anil, New using BI. Have an issue that no one I know seems to have an answer.
Hoping you can help. Working in Word. Have a semi-blank check. The bottom check portion, is framed. The MICR string must be located on the second line from the bottom of the page outside the framed portion. My template places the micro font below the framing and pulls another blank page. If I pull it up one line, it is in the framed area of the form, which is unacceptable. I am using "Cart" for the Default text and end with "Page break;End Group: OutboundPayment s" Any suggestions?
Quote
0 #95 anubhav 2015-08-13 05:53
How to remove repeated rows in e text template?
Quote
0 #96 바카라사이트 2021-06-25 09:01
Greetings! Very helpful advice within this article! It is the little changes that make the most important changes.
Thanks a lot for sharing!
Quote
0 #97 카지노 2021-06-29 07:55
Amazing things here. I'm very happy to see your article.
Thank you so much and I am taking a look forward to contact you.
Will you please drop me a mail?
Quote
0 #98 카지노사이트 2021-06-29 20:16
Thanks for your marvelous posting! I seriously enjoyed
reading it, you happen to be a great author.I will make certain to bookmark your blog and may come back from now on.
I want to encourage you to continue your great posts, have a nice day!
Quote
0 #99 카지노사이트 2021-07-08 10:28
I?m not that much of a online reader to be honest but your
blogs really nice, keep it up! I'll go ahead and bookmark
your site to come back down the road. Many thanks
Quote
0 #100 เบทฟิก 2021-07-14 01:33
สมัครสมาชิก betfilk เว็ปพนัน และการเดิมพันเจ นใหม่ บริการผ่านเทคโน โลยีทันสมัยฝากเ ครดิต –
ถอนเงิน AUTO ค่ายเกมส์Slot Onlineและกาสิโนแบรนด์ดังกองให้ในเว็บเดียว

เพื่อความสะดวกของสมาชิก เพียงกดสมัคร betflik สมัครรับยูสเดีย ว ท่านสามารถเข้าเ ล่นสล็อต เกมยิงปลา และคาสิโน จากหลากหลายค่าย คาสิโนดัง จากบริษัทเกมโดย ตรงกว่า
33 เกมสล็อตผ่านทาง เข้าเล่น betflik ทางเข้าเล่นได้ไ ม่ต้องดาวโหลดแอ พลิเคชั่น
ยกตัวอย่าง เช่น
PG Slot, Joker123, NETENT, PlayStar, PP PragmaticPlay, BPG BluePrint และนี่คือส่วนหนึ่งจากค่ายเกมส์ชื่อดังทั้งหมดในประเทศไทยและเทศ

betflik. slot ยังเปิดให้เล่นพ นันคาสิโนออนไลน ์ถ่ายทอดสด บาคาราออนไลน์ เสือ มังกร เกมคาสิโนเดิมพั นแนวต่าง จากค่ายดัง เช่น SA Gaming, AESexy, WM
คาสิโน, DG คาสิโน โดยเว็บได้รวบรว มทั้งหมดนี้ มาไว้ที่เดียวที ่ เบทฟลิกซ์ มีระบบฝาก-ถอนออ โต้ที่รวดเร็ว
ระบบสมาชิกใช้งา นง่าย และรองรับกับทุก อุปกรณ์ ไม่ว่าจะเป็น PC, iOS, Android อีกด้วย
Quote
0 #101 바카라사이트 2021-07-18 10:40
Remarkable things here. I'm very glad to peer
your post. Thank you so much and I'm looking ahead to contact you.
Will you please drop me a e-mail?
Quote
0 #102 바카라사이트 2021-07-18 11:25
Hello it's me, I am also visiting this web site on a regular basis, this site
is genuinely nice and the people are genuinely sharing
nice thoughts.
Quote
0 #103 Old School RS Guides 2021-08-06 04:16
Thanks for one's marvelous posting! I really enjoyed reading it, you will
be a great author. I wiull always bookmark your blog and will often come back very soon. I
want to encourage continue your great work, have a nice afternoon!
Quote
0 #104 pgslotboom 2021-08-11 15:35
Just sort the title of the category into the search box to discover the most recent video games out
there for PGSLOT. In one of these sport, the gamers are capable of adopt
their characters into their actual life so that they are going to be capable of perform higher
of their each day lives. Moreover, by just registering a new user account and taking part in PG slot games, you
will get some advantages like bonuses, particular
provides and free gifts as well. This fashion Master
will keep all wal files needed in the course of the
backup. 2. keep your "reject everyone else" as your last entry.

Be that as it may, the best aspect of this game is you possibly can win 1 of four
Jackpots which are the Mini, Minor, Major and Maxi Jackpot - with the last contribution players the chance to win a mind
boggling eight Million dollars! PG Slot supports major units akin to iOS, Android and internet.
Pihak daftar judi slot Pgsoft juga selalu menerapkan peraturan lainnya yaitu dengan memberikan berbagai macam promo, cashback, hadiah
menarik kepada setiap calon pemain atau yang telah bermain.

Here is my site: pgslotboom: https://Pgslotboom.xyz/
Quote
0 #105 pgslot 2021-08-12 11:09
Are you interested by trying out the PGSLOT: https://Pgslotbet99.xyz/ the computer program on the IOS or
Windows working system? However, these bonuses and gifts are only provided as soon as the
registration has been made on time. Include the forms of
payment, and the bonuses that they admit and also offer off With their constant usage,
the extensive selection and list of their very most advocated video games, the advantages of
preferring to pg slot, along with even the deposit and withdrawal systems they pose to mobilize the capital in accordance with
the user taste. Setiap kemenangan pasti diproses dan dikirim
langsung ke rekening sesuai terdaftar di consumer ID kamu.
Tips terbaik yang dapat sobat bettor siapkan pada setiap babak bertaruh judi PG Soft on-line resmi adalah bagaimana sobat bettor dapat membuat prediksi cepat
terkait seluruh hasil yang akan dikeluarkan oleh mesin judi slot PG
Soft. Di sebagian besar slot yang dikembangkan oleh PG Soft,
penggemar akan dapat melihat penggambaran tema yang luar biasa.

Tentu untuk bermain pg gentle leprechaun dengan nyaman dan aman anda harus
memilih satu tempat yang dapat menyediakan layanan terbaik dan berkualitas.
Raih peluang untuk melipatgandakan kemenangan Anda hingga 5.000x ketika
1 atau lebih simbol Stacked Wild muncul sepenuhnya di gulungan mana pun.
Quote
0 #106 pg slot 2021-08-12 12:10
Are you interested by attempting out the PGSLOT the computer program
on the IOS or Windows working system? However, these bonuses and
gifts are solely offered as soon as the registration has
been made on time. Include the kinds of cost,
and the bonuses that they admit and in addition provide off With their constant
usage, the large variety and checklist of their very most advocated video games, the advantages of preferring to pg slot: https://Pgslot77.xyz/, together with
even the deposit and withdrawal systems they pose
to mobilize the capital in accordance with
the consumer style. Setiap kemenangan pasti diproses dan dikirim langsung ke rekening sesuai terdaftar di person ID kamu.
Tips terbaik yang dapat sobat bettor siapkan pada setiap babak
bertaruh judi PG Soft online resmi adalah
bagaimana sobat bettor dapat membuat prediksi cepat terkait seluruh hasil yang
akan dikeluarkan oleh mesin judi slot PG Soft.

Di sebagian besar slot yang dikembangkan oleh PG Soft, penggemar
akan dapat melihat penggambaran tema yang luar biasa.
Tentu untuk bermain pg tender leprechaun dengan nyaman dan aman anda harus memilih
satu tempat yang dapat menyediakan layanan terbaik dan berkualitas.
Raih peluang untuk melipatgandakan kemenangan Anda hingga 5.000x
ketika 1 atau lebih simbol Stacked Wild muncul sepenuhnya
di gulungan mana pun.
Quote
0 #107 카지노사이트 2022-01-24 08:15
It's not my first time to visit this web site, i am visiting this web page dailly and get good facts
from here daily.

Feel free to surf to my website ... 카지노사이트: https://casinolos.xyz
Quote
0 #108 카지노사이트 2022-01-25 04:20
I'm not sure where you're getting your info, but good topic.
I needs to spend some time learning much more or understanding more.
Thanks for great information I was looking for this information for my mission.

Also visit my homepage; 카지노사이트: https://ourcasinoii.xyz
Quote
0 #109 คาสิโน ออนไลน์ 2022-02-08 10:40
คาสิโน คาสิโน ออนไลน์: https://ruay666.com/ ออนไลน์ คนไหนกันแน่ที่เ หมาะสมกับการ เล่นเกมพนันคาสิโน
มองเห็นผู้คนจำนวนไม่ใช้น้อยเลือกที่จะ เล่นเกม คาสิโนออนไลน์ บนเว็บไซต์ เนื่องจากเป็นกร ะบวนการ หารายได้ที่ง่าย
ได้เงินไว เล่นแล้ว ได้เงินมาก ได้เงินจริง รวมทั้งยังได้
ความสนุกสนานร่า เริง อีกด้วย มีเกมพนัน นานาประการ ให้เลือกเล่น มีเพียงแค่โทรศั พท์ เครื่องเดียว ก็สามารถเข้า เล่นได้เลย ใครกันแน่ก็สามา รถเข้าถึง แม้กระนั้นเกมพน ันจะเหมาะสมกับผ ู้ใดกันบ้าง คนใดกันที่เล่นไ ด้ มาติดตาม ในเนื้อหานี้

ผู้ที่ไม่ค่อยมี เวลาว่าง หรือมีเวลาน้อยก ็สามารถเล่น คาสิโนออนไลน์ ได้
จำพวกแรก ของผู้ที่ เหมาะสมกับการเล ่น เกมพนัน ในเว็บไซต์ คาสิโนออนไลน์ ก็คือผู้ที่ไม่ค ่อยมีเวลา หรือมีเวลาน้อย เนื่องจากว่าเกม พนันแบบ ออนไลน์ ไม่จำเป็นที่จะต ้องตั้งเวลา สำหรับเพื่อการเ ล่น เสมือนการทำงาน แม้ว่างตอนไหน หรือสบายเวลาไหน ก็สามรถยนต์เล่น ได้ เพราะว่า เว็บไซต์คาสิโน ออนไลน์ เปิดให้บริการตล อด 1 วัน ทั้งยังเล่น เกมพนันได้ ฝาก – ถอนได้ แล้วก็มีแอดไม่น รอดูแล ให้คำแนะนำ รวมทั้งให้คำปรึ กษา กับทุกคน



ผู้ที่ จะต้องเดินทางบ่ อยครั้ง มิได้ดำเนินงานคงที่



ถัดมา คนชนิด ที่ไม่อยู่กับที ่ จำเป็นต้องเดินท างหลายครั้ง
เหมาะสมมากที่จะ เล่นเกมพนัน บน คาสิโนออนไลน์ ไม่ว่าจะเล่นเพื ่อ ความเพลิดเพลิน เล่นเพื่อบรรเทา หรือเล่นเพื่อหา รายได้ ก็ทำเป็น อย่างเดียวกัน เพราะว่าในเว็บไ ซต์จะมีนานาประก าร หนทางให้เลือกเล ่น ส่วนมากที่ คนนิยมก็ เป็นโทรศัพท์เคล ื่อนที่ ด้วยเหตุว่าเล่น ง่าย
เล่นสบาย อยู่ไหน ก็เล่นได้ เพียงแค่มีอินเทอร์เน็ตเพียงแค่นั้น



ผู้ที่ ทุนน้อย ไม่กล้าลงทุนมาก มาย ไม่ต้องการเสี่ยง



ถัดมาเป็นคนจำพวก ทุนน้อย หรือผู้ที่ ไม่ต้องการลงทุน มากมาย กลัวการเสี่ยง เนื่องจากว่า เกมพนันใน เว็บไซต์คาสิโน
ลงทุนเพียงแค่ หลักร้อย ถึงหลักพัน ก็สามารถเล่นได้ บางเกมพนัน อย่างเช่น
เกมสล็อต ออนไลน์
พนันเพียงแค่ทีล ะ 5 บาท 10 บาท ต่อการหมุนสปินก ็มี ด้วยเหตุผลดังกล ่าว ทุนน้อย ไม่ใช่ปัญหา สำหรับการเล่น เกมพนันเลย แม้กระนั้นผู้ใด กันแน่ที่ ทุนมากมาย
ต้องการเล่นทีละ 1000 – 100000 บาท ก็เล่นได้ในเว็บ ไซต์ ruay666.com

ผู้ที่ ต้องการมั่งมีไว มั่งมีง่าย นอนอยู่บ้านก็มั ่งคั่ง
เล่นเกมที่ เว็บไซต์ใหม่มาแ รง
ในที่สุดก็ เป็นผู้ที่ ต้องการร่ำรวย โดยจำพวก นี้พบว่า แทบหมดทุกคนเลย ก็ว่าพอดี ต้องการมั่งคั่ง เนื่องจากว่าเงิ นเป็น สิ่งที่จำเป็นใน ชีวิต บางบุคคลเทียบเค ียงเงิน พอๆกับ ความสำราญ
ด้วยเหตุว่าเกมพ นันเล่นแล้ว ได้เงินมาก ร่ำรวยได้อย่างง ่ายๆถ้าเกิดยากม ั่งคั่ง ให้ประพฤติตามนี้

สมัครเป็นสมาชิก
ruay666.com เว็บไซต์ใหม่มาแ รง
กรอกข้อมูล การันตีเบอร์
รอคอยรับยูสเซอร์เนม รวมทั้งรหัสผ่าน เพื่อใช้ล็อกอิน เพื่อเข้าระบบ
ล็อกอินเข้าระบบ เลือกเกมที่อยากได้ได้เลย


สรุป คาสิโน ออนไลน์ คนไหนกันแน่ก็เล ่นได้ เพียงแค่สมัคร สมาชิก ก็เข้าเล่นได้โด ยทันที เป็นกระบวนการหา รายได้ ที่ง่าย และก็เร็ว ว่างตอนไหน ก็เข้าเล่นได้ แถมยังเล่นได้
นานาประการวิถีท าง เว็บไซต์ใหม่มาแ รง เล่นได้ทุกหนทุก แห่ง
ทุกเมื่อ ไม่ต้องลงทุนมาก มาย ก็สามารถเล่นได้ หรือใครกันแน่พอ ใจ ที่จะเล่นลุ้นร่ ำรวย ต้องการเป็นคนมั ่งคั่ง เลวทรามข้ามคืน ก็จำต้องเล่นเกม พนัน ร่ำรวยทางลัด รับประกันว่า มั่งคั่งได้จริง ถ้าคุณเป็นเลิศใ น คนสี่จำพวกนี้ เป็นผู้ที่เหมาะ สมกับ การเล่นเกมคาสิโ น สมัครเลยตรงนี้
ruay666.com
Quote
0 #110 คาสิโนออนไลน์77 2022-02-10 01:44
เว็บไซต์พนันออน ไลน์เว็บไซต์ตรง ruay666.com คาสิโนออนไลน์ คาสิโนออนไลน์77 : https://ruay666.com/%e0%b8%84%e0%b8%b2%e0%b8%aa%e0%b8%b4%e0%b9%82%e0%b8%99%e0%b8%aa%e0%b8%94-20220120/ ระบบเสถียรทุกการใช้แรงงาน
ruay666.com เว็บไซต์พนันออน ไลน์เว็บไซต์ตรง ที่เหมาะสมที่สุ ด รองรับทุกการเข้ าใช้งานได้สบายเ ร็วทันใจ ไม่ว่าคุณจะอยู่ ที่ในก็สามารถเข ้ามาเล่นเกมพนัน ผ่านทางเว็บได้ต ลอดระยะเวลาเพื่ อความสนุกสนานตื ่นเต้นตื่นเต้นด ้วยระบบออนไลน์ท ี่นำสมัยและก็ มีระบบระเบียบที ่เสถียรประสิทธิ ภาพในเกมของพวกเ ราระดับ Full HD ชัดไม่มีกระตุกแ น่ๆเหมือนคุณได้ เข้าไปเล่นที่บ่ อนจริงๆเว็บไซต์ ของพวกเราคัดสรร เกมที่เล่นง่าย ได้เงินเร็วที่คุณไม่สมควรพลาด

ทดสอบ เว็บไซต์พนันออน ไลน์เว็บไซต์ตรง คาสิโนออนไลน์ ศูนย์รวมเกมพนัน
เกมพนันของพวกเร า เป็น เว็บไซต์พนันออน ไลน์เว็บไซต์ตรง ให้ท่านได้เลือก เล่น มากยิ่งกว่า 2000 เกม แบบจุใจ เอาให้นักการพนั นทุกคน
เพื่อความสบายสบ าย สำหรับในการเล่น พนัน คุณไม่ต้องเดินท างไปเล่นที่ไกลๆ แค่เพียงมีโทรศั พท์เคลื่อนที่ ก็สามารถเล่นได้ ตลอดเวลา ที่คุณอยากได้ อย่ามัวโอ้เอ้ รีบมาเล่นกับพวกเราในเวลานี้สิ่งดีๆกำลังคอยคุณอยู่



คาสิโนออนไลน์เว็บไซต์พนันที่ตามมาตรฐานสุดยอด



สำหรับคนใดกันที่กำลังตื่นตระหนก
ว่าเว็บไซต์พนัน ของพวกเราน่าไว้ ใจได้ หรือ ไม่ ขอบอกไว้นี้ เลยว่า
น่าไว้ใจได้จริง เนื่องจากระบบขอ งพวกเรา คัดสรรแม้กระนั้ นสิ่งดีๆให้กับล ูกค้า ดูแลระดับ
VIP ตลอด 1 วัน แถมยังเป็น เว็บไซต์ที่ได้ร ับมาตรฐานสุดยอด อีกด้วย เป็น คาสิโนออนไลน์ ที่น่าไว้วางใจท ี่สุดเวลานี้ มีอีกทั้งการบริ การที่พร้อม คัดสรรเกมนานาปร ะการแนวที่แปลกใ หม่ พร้อมลุ้นรับโบน ัสอีกเยอะแยะที่ ruay666.com พวกเราขอเสนอแนะ ค่ายเกม ดังต่อไปนี้

1. AG ASIA GAMING

2.SUNBET

3.AMEBA ENTERTAINMENT

4.RED TIGER

5.SIMPLEPLAY

6.MICROGAMING

7.JDB

8.SA GAMING

9.SEXY BACCARAT

10.CQ9 GAMING



สมัครเป็นสมาชิกใหม่ คาสิโนออนไลน์ ลุ้นรับแจ็คพอตใ หญ่ โดยทันที



สำหรับสมาชิกใหม่ ที่เข้ามาเล่นกั บพวกเราช่วงนี้ คุณจะได้รับสิทธ ิประโยชน์ล้นหลา ม ตั้งแต่ทีแรก
ที่คุณเริ่มเล่น เกม ในระบบของพวกเรา สมัครในเวลานี้
รับเครดิตฟรี โบนัส 100 เปอร์เซ็นต์ เพื่อเป็นทุนสำห รับในการพนัน คุณไม่ต้องไปเสี ยเวล่ำเวลา ไปฝาก – เบิกเงิน สามารถเริ่มเล่น เกมพนันได้ในทัน ที
ไม่ว่าคุณจะอยู่ ที่ใหน ก็สามารถเข้ามา เล่นเกมพนันผ่าน ทางเว็บ
ได้ตลอดระยะเวลา เพื่อความสนุกสน านร่าเริง ตื่นเต้น ตื่นเต้น
ด้วยระบบออนไลน์ ที่ล้ำยุค รวมทั้งมีระบบระ เบียบที่เสถียรป ระสิทธิภาพ
เพื่อความสบาย เร็วทันใจ
สำหรับในการเล่น เกมพนันของพวกเร า ใช้เวลาเล่นไม่น าน ก็สามารถทราบผลช นะในเกม ได้รวดเร็วทันใจ ทันใจ ไม่ต้องรอนาน



เว็บไซต์พนันออนไลน์ เป็นหนทางหลัก ปากทางเข้า คาสิโนออนไลน์ วิถีทางเดียว ที่นักการพนัน
สนใจอย่างมาก เนื่องจากว่าเป็ นวิถีทาง ที่สบาย เร็วทันใจ ต่อการเข้าใช้งา น ระบบมีเกม ให้เลือกเล่นแบบ จุใจ สามารถสร้างราย ได้แค่เพียงไม่ก ี่นาที เป็นวิถีทาง
ที่ใช้เงินที่ใช ้ในการเดิมพันน้ อยมาก แม้กระนั้นได้เง ิน คืนที่สูงมากมาย ๆเหมาะกับผู้ที่ ร้อนเงิน หรืออยากใช้เงิน แบบเร่งด่วน พวกเรามีระบบระเ บียบ ฝาก – ถอนที่รวดเร็วทั นใจ
ต่อการใช้แรงงานของลูกค้าอีกด้วย

คาสิโนออนไลน์ ปากทางเข้าคาสิโ นออนไลน์ ที่สนุกสนานเร็ว น่าเล่น
สรุป จำต้องบอกไว้ก่อ นเลยว่า ruay666.com ปากทางเข้าคาสิโ นออนไลน์ เว็บไซต์พนัน
ที่ได้เก็บรวบรว มเกมพนัน
ที่เยี่ยมที่สุด ในทุกวันนี้ ให้ลูกค้าได้เลื อกเล่น
ตามความพอใจที่ค รบถ้วนเยอะที่สุ ด ระบบเกมของพวกเร า ลื่นไหล
ต่อการเข้าใช้งา นเป็นอันมาก
เกมเล่นง่าย ได้เงินไว เชื่อถือได้ เพราะเหตุว่าระบ บของพวกเรา ได้รับมาตรฐานสุ ดยอด ไม่ว่าคุณจะอยู่ ที่แห่งไหน ก็สามารถเข้ามาเ ล่นกับพวกเราได้ ตลอด 1 วัน มีงบประมาณน้อย ก็ลุ้นรับรางวัล ใหญ่ได้ ไม่ต้องขอคืนดีโ ชค พร้อมรับโปรโมชั ่น อีกเพียบเลย ที่กำลังรอคอยคุ ณอยู่ มีแต่ว่าสิ่งดีๆ อย่างงี้ไม่ต้อง สงสัย ว่าเพราะเหตุไรถ ึงเป็นเว็บไซต์พ นันที่เยี่ยมที่ สุด
Quote
0 #111 온라인카지노 2022-02-15 12:36
Hiya! Quick question that's entirely off topic.
Do you know how to make your site mobile friendly? My blog
looks weird when viewing from my iphone 4. I'm trying to find a template or plugin that
might be able to correct this problem. If you have any recommendations , please share.
Many thanks!

my website ... 온라인카지노: https://ourcasinorr.xyz
Quote
0 #112 sm카지노 2022-02-15 19:46
Wonderful blog you have here but I was wanting to know if you knew of any discussion boards that cover the same topics
discussed in this article? I'd really like to be a part of community where I can get comments from other experienced individuals
that share the same interest. If you have any suggestions,
please let me know. Many thanks!

Also visit my web site sm카지노: https://crazyslot.xyz
Quote
0 #113 온라인카지노 2022-02-15 22:52
Good response in return of this difficulty with firm arguments and explaining the whole thing on the
topic of that.

my website: 온라인카지노: https://ourcasinowhat.xyz
Quote
0 #114 카지노사이트 2022-02-16 00:17
Somebody essentially lend a hand to make critically posts I'd state.
That is the first time I frequented your web page and to this point?
I amazed with the research you made to make this particular submit incredible.
Magnificent job!

my web page ... 카지노사이트: https://ourcasinozz.xyz
Quote
0 #115 온라인카지노 2022-02-16 06:07
I must thank you for the efforts you've put in writing this blog.
I am hoping to view the same high-grade blog posts by you
in the future as well. In truth, your creative writing abilities
has encouraged me to get my own, personal website now ;)

Also visit my homepage 온라인카지노: https://ourcasinoxx.xyz
Quote
0 #116 카지노사이트 2022-02-16 06:52
What's up it's me, I am also visiting this web site daily,
this web site is truly good and the people are really sharing good thoughts.


Also visit my web page ... 카지노사이트: https://ourcasinowhat.xyz
Quote
0 #117 온라인카지노 2022-02-16 14:53
I used to be able to find good advice from your blog posts.



Look at my web page 온라인카지노: https://ourcasinolyy.xyz
Quote
0 #118 카지노사이트 2022-02-16 17:53
I was suggested this website by my cousin. I am not sure
whether this post is written by him as no one else know such detailed about my difficulty.
You are amazing! Thanks!

Feel free to surf to my web site: 카지노사이트: https://ourcasinolyy.xyz
Quote
0 #119 온라인카지노 2022-02-17 06:31
I think that everything said was actually very reasonable.
However, what about this? suppose you were to create
a killer headline? I am not suggesting your content is not good.,
however what if you added something that grabbed folk's attention? I mean XML Publisher - Developing reports printed on Pre-Printed Stationary is kinda plain. You should peek at Yahoo's front page and see how they create news titles
to get viewers interested. You might add a video
or a related pic or two to grab people excited about
everything've written. Just my opinion, it might bring your blog a little bit more
interesting.

Here is my page :: 온라인카지노: https://ourcasinoll.xyz
Quote
0 #120 온라인카지노 2022-02-17 18:39
I am not sure where you are getting your info, but great topic.
I needs to spend some time learning more or understanding more.
Thanks for great information I was looking for this info for my mission.

My web page ... 온라인카지노: https://ourcasinowat.xyz
Quote
0 #121 카지노사이트 2022-02-18 03:26
This is really attention-grabb ing, You are an overly professional blogger.
I have joined your rss feed and stay up for seeking more of your fantastic post.
Also, I have shared your web site in my social networks

my web blog; 카지노사이트: https://ourcasinowat.xyz
Quote
0 #122 카지노사이트 2022-02-18 19:57
Its not my first time to pay a visit this site,
i am visiting this web page dailly and obtain fastidious information from here everyday.



Also visit my web site; 카지노사이트: https://ourcasinoly.xyz
Quote
0 #123 에그벳카지노 2022-02-18 20:46
I was able to find good info from your content.


Look at my page ... 에그벳카지노: https://eggbet.xyz
Quote
0 #124 온라인카지노 2022-02-19 20:48
Simply want to say your article is as astonishing. The clarity to your publish is just nice and i could suppose you're knowledgeable on this subject.
Well along with your permission allow me to grab
your RSS feed to keep updated with approaching post.
Thanks 1,000,000 and please carry on the enjoyable work.


Here is my blog post; 온라인카지노: https://ourcasinoly.xyz
Quote
0 #125 온라인카지노 2022-02-22 17:15
It's going to be end of mine day, but before finish I am reading this enormous post
to improve my experience.

Visit my homepage; 온라인카지노: https://ourcasinoll.xyz
Quote
0 #126 카지노사이트 2022-03-12 19:18
WOW just what I was searching for. Came here by searching for XML Publisher

Also visit my web blog :: 카지노사이트: https://ourcasinoxx.xyz
Quote
0 #127 sm카지노 2022-03-12 23:07
My family members always say that I am wasting my time
here at net, except I know I am getting familiarity daily by reading thes pleasant posts.


Also visit my homepage sm카지노: https://crazyslot.xyz
Quote
0 #128 카지노사이트 2022-03-13 04:23
I am not sure where you're getting your information, but
great topic. I needs to spend some time learning more or understanding more.
Thanks for great info I was looking for this information for my mission.

Here is my web page ... 카지노사이트: https://ourcasinowat.xyz
Quote
0 #129 온라인카지노 2022-03-13 07:02
Very nice post. I simply stumbled upon your weblog and wanted to say that I
have really loved surfing around your blog posts. In any case I'll be subscribing for your rss feed and I am hoping
you write again soon!

My page: 온라인카지노: https://ourcasinolok.xyz
Quote
0 #130 ยิงปลา 2022-03-25 06:13
เกมยิงปลา ยิงปลาออนไลน์บน มือถือ ยากมั้ย ?
เกมยิงปลาบนมือถือ มาในรูปแบบที่เรียบง่าย ไม่ยากเหมาะ
สำหรับนักเดิมพั นมือใหม่ หรือผู้ชำนาญ ก็สามารถเล่นได้ เป็นเกมที่เล่นแ ล้วได้เงินจริง แต่การที่จะได้เ งินนั้นก็ไม่ได้ ง่ายนัก
วันนี้เราก็จะมา แนะนำวิธีการเล่ น เกมยิงปลาออนไลน ์ แบบง่ายๆเพื่อให้ท่านเอาไปลองใช้ได้

มีระบบออโต้ล็อก : ล็อกปลาที่ต้องก ารยิงได้เลยโดยไ ม่ต้องกด หรือ จิ้มจอให้เมื่อย มือ ยิงแบบรัวๆ

ในการยิงปลานั้น ผู้เล่นควรเลือก ยิงปลาที่มีคนอื ่นยิงมาแล้วบ้าง และปลาตัวนั้นก็ ต้องมีทิศทางการ ว่ายมาหาตำแหน่ง ที่ปืนเรา เพราะจะทำให้ยิง ปลาตายได้ง่ายกว ่า อีกทั้งปลาที่กำ ลังว่ายน้ำหลุดอ อกจากนอกจอไม่จำ เป็นต้องยิงก็ได ้ เพราะจะทำให้เปลืองกระสุนและโอกาสที่ปลาจะตายก็มีน้อย

ท่านสามารถเข้าไปเดิมพันเกมยิงปลาผ่าน

สำหรับนักพนัน ที่ชอบยิงปลาใหญ ่ แนะนำให้ยิงช้า ๆ อย่ารัวกระสุน ยิงเน้น ๆ
ที่ปลาใหญ่ จะช่วยทำให้ประห ยัดกระสุนได้มาก ขึ้น ซึ่งไม่จำเป็นต้ องหมดกระสุน ไปกับปลาเล็กปลา น้อย หรือ ปลาพิเศษ ให้เน้นปลาใหญ่ไ ปเลย ยิ่งหากได้ยิงพร ้อมกับผู้เล่นหล ายคน
ก็จะทำให้ปลาใหญ ่ตายไวขึ้น ก็จะทำให้ได้โบน ัสพิเศษมากกว่า ปกติหลายเท่าเยอ ะว่า เกมยิงออนไลน์ทั ่วไป หลักการทำเงินจากเกมยิงปลาออนไลน

สัญลักษณ์ i คือ รายละเอียดของเก ม ที่คุณสามารถ เข้ามาดูฟังก์ชั ่น
การใช้งานก่อนการเริ่มต้นเล่น

เกมยิงปลาออนไลน ์ เป็นเกมที่จ่ายผ ลตอบแทนสูง เหมาะกับผู้เล่น ทุกระดับตั้งแต่ มือใหม่ไปจนถึงร ะดับมืออาชีพ มีเครื่องมือให้ เลือกเล่นหลายรู ปแบบ ผู้เล่นก็จะได้ร ับเงินรางวัลสูง สุด ผู้เล่นต้องดูว่ า ตัวปลามีระดับคว ามต่างของความยา กของปลา ไม่ต้องกังวลเรื ่องว่าจะเล่นไม่ เป็น รับรองว่าอ่านแล ้วเข้าใจง่ายและ เล่นเป็นทันที คุณสมบัติ เพื่อเพิ่มโอกาส ในการยิงปลาให้ไ ด้คะแนนสูง ปรับ-ลด อัตราเดิมพัน

เกมยิงปลา ยิงปลาออนไลน์บน มือถือ ยากมั้ย
7XBET มีคำตอบให้

หน้าแรก โปรโมชั่น เดิมพัน
เกม สูตร

เว็บ สล็อต เราคือเว็บตรงสำ หรับ เกม คาสิโน
ไม่ผ่านเอเย่นต์ สมัครง่าย
ฝากถอนไว สุด ๆ ไปเลย

ฝันเห็นงูเผือก เลขเด็ด การงาน การเงิน ครอบครัว โชคลาภ ความรัก

เกมยิงปลา หรือ เกมยิงปลาออนไลน ์ เป็นเกมที่หลายคนอาจจะรู้จักกันเป็นอย่างดีในโลกออนไลน์ เป็นเกมที่เล่นแ ล้วได้เงินจริง โดยไม่ต้องออกไป ทำงานนอกบ้าน ซึ่งก็เป็นอีกหน ึ่งเกมพนันออนไล น์ ที่ได้รับความนิ ยมในหมู่นักพนัน ออนไลน์เป็นอย่า งมาก เป็นเกมที่เล่นง ่าย และ สนุกสนานสามารถผ่อนคลายได้

สล็อต ยืนยัน otp รับเครดิตฟรี ไม่มี เงื่อนไข

เพราะนี่คือ ระบบ ที่สามารถตอบโจท ย์ ให้กับท่าน ได้เป็นอย่างดี ระบบอัตโนมัติ กับการทำรายการ ที่แสนสะดวกสบาย

The entry guidelines of a site outline which visits are authorized.

Your present-day take a look at will not be authorized Based on All those guidelines.
Quote
0 #131 pragmatic play 2022-03-25 17:03
Hi to every body, it's my first pay a quick visit of this website;
this blog carries amazing and in fact excellent stuff
in favor of readers.
Quote
0 #132 joker123 2022-03-27 01:10
I know this web page presents quality dependent articles and other stuff, is
there any other website which presents such data in quality?
Quote
0 #133 카지노사이트 2022-03-27 22:55
whoah this blog is great i really like reading your articles.
Keep up the great work! You realize, lots of individuals are searching around for
this information, you can help them greatly.

my webpage; 카지노사이트: https://ourcasinowat.xyz
Quote
0 #134 joker 123 2022-03-29 02:41
Hello there! This blog post could not be written much better!

Going through this article reminds me of my previous roommate!
He continually kept talking about this. I am going to send this information to
him. Pretty sure he will have a great read.
I appreciate you for sharing!
Quote
0 #135 สมัครสมาชิกสล็อต pg 2022-04-04 18:33
I've been browsing online more than three hours today, yet I never found
any interesting article like yours. It is pretty worth enough for me.
In my opinion, if all web owners and bloggers made
good content as you did, the web will be a lot more useful than ever before.
Quote
0 #136 slot1234 2022-04-11 18:46
Excellent post. I was checking continuously this blog and I'm impressed!
Very useful information particularly the last part :) I care for such info much.

I was looking for this certain information for a long time.
Thank you and best of luck.
Quote
0 #137 pragmatic 2022-04-14 21:11
Appreciating the hard work you put into your site and detailed
information you offer. It's good to come across
a blog every once in a while that isn't the same unwanted rehashed
information. Excellent read! I've bookmarked your site and I'm adding your RSS feeds to my Google account.
Quote
0 #138 카지노사이트 2022-04-20 02:39
Wow, amazing blog layout! How long have you been blogging for?
you made blogging look easy. The overall look of your website
is great, let alone the content!

My web page - 카지노사이트: https://casinobrat.xyz
Quote
0 #139 pragmaticplay 2022-04-26 07:51
Hey there! I know this is kinda off topic but I was wondering if you knew where I could locate a captcha plugin for my comment form?
I'm using the same blog platform as yours and I'm having problems finding one?

Thanks a lot!
Quote
0 #140 joker123 2022-05-23 21:01
Good blog you have got here.. It's hard to find excellent writing like yours these days.

I honestly appreciate individuals like you! Take care!!
Quote

Add comment


Security code
Refresh

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Mar 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
      1  2  3
  4  5  6  7  8  910
11121314151617
18192021222324
25262728293031

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner