Dynamic footer on RTF template of word

[Huy Nguyen]

Hi Erman,
I have a case to change dynamic footer based on student filed. According to my body of word, it already automaticallly change name of student by group. But as I know, the footer is not belong to body of word. So  when I run report, it always show name of first student. So how can I create dynamic footer depends on student filed when out of each student or page break. Thank you for your time and in advance.

[ErmanArslansOracleBlog]

Please revise your question.
What is the system that you are talking about?
Is it EBS? What approach did you follow to accomplish this task?
Please give me all the details so I can help..

[Huy Nguyen]

Thank you for quickly response to me, Erman. I use it on EBS, but exactly on Oracle Apex version of 20. That method now I apply is I use xml on rtf template. When I choose one variable class, the system will print report of all of student in class in one file. Now the body of report, it will change name of each student as soon as ending of each student. But the footer it gets the first name of student for each student in class. Now I want to when ending of each report student, it will automatically change name of each student. If you  
don't clearly understand I said( sorry for that), you say to me. Thank you.

[ErmanArslansOracleBlog]

So you have a model (template and a piece of code) and you use it for producing different outputs. You are dynamically generating reports, changing student name, but you have a footer problem.. You just can't dynamically generate the student name display in the footer?
What is the tech that you use for producing the rtf?
Is it XML publisher , is it a custom code?

Please send me a screenshot so that I can understand your situation better.

[Huy Nguyen]

Thank you Erman. You understand me. Now it is my custom code for xml:
For body code:



For footer code now I use:

REPORT CARD <?LOP?> <?MA_HOC_SINH?> - <?HOC_SINH?>

[ErmanArslansOracleBlog]

What is the tech that you use for producing the rtf?

Do you use EBS concurrent programs and XML publisher? Oracle Reports?
Or what do you use to produce it?

[Huy Nguyen]

As I mentioned  above, I export report on Oracle Apex it need two fundamentals: the first is report query, it is my custom code, give me xml sample. Secondly. a report layout, it is a file word I load that xml and create my layout. ( you can see the picture above).

[ErmanArslansOracleBlog]

This is a developer question.. An apex developer question..  This is beyond of the scope.
Still, I tried to take it into an abstract form, so that I can help.

So, I think the problem is you are producing an RTF from Apex using a custom report query and custom template.. You can do it, but you can't just dynamically generate the contents of the footer section.

I think you can't reach the footer section while populating the layout.. How do you populate the footer section?  How do you create the mapping between the related data and the related parts of the footer section? If we can see the technical details there, we may say something using the induction or generalization method.

[Huy Nguyen]

Thank you for your good idea. You are always nice person even taking your time. I know my custom code will run the footer when put in on my body template. But that the footer is not belong to the body. When I search on GG, there is not maybe event related to my present problem.  Answer yo your question:

The footer I normally create on word (susch as header, footer of word). I add parameter <?MA_HOC_SINH?> it present for each student when change the value of MA_HOC_SINH. You can see the bi puplhiser of field MA_HOC_SINH on column student code, it automatically change the value on my body template.

[ErmanArslansOracleBlog]

Huy,

Does the following thread help? - >

https://community.oracle.com/mosc/discussion/4012776/how-to-display-dynamic-footers-through-xml-publisher-rtf-template

They are discussing about template and a sub templates for accomplishing this task and there are links for this procedure. So please have a look.

[Huy Nguyen]

Thank you Erman for your good information.