XML Publisher Heading Suffixed With Date

Jacobelia S

Summary

XML Publisher Heading Suffixed With Date

Content

Hello,

I have a report with parameter, heading and data as shown in the enclosed screenshot

Could it possible to have the date concatenated with the heading based on the parameter? Let me elaborate,

if the parameter is 13-Sep-2017, then heading should be suffixed with the date as shown in the below screenshot

Appreciate any insight or help.

​

Brajesh Shukla-95078

Could you please upload/send mail...the rtf and sample xml

Brajesh Shukla-95078

ohh...then you can just add <?format-date:ParameterName;'dd';'Asia/India'?>

Brajesh Shukla-95078

Yes...you can subscribe to any country and region.

for the format 'day-dd' if date is 25-Sep-2017. it will return Monday-25. You may need to do substr to get Mon-25

Brajesh Shukla-95078

you can user <?format-date:ParameterName;'day-dd';'Asia/India'?>

Brajesh Shukla-95078

If I understand you problem correctly...you are passing one Date as a parameter and from that date you are displaying the data two days back and two days in future.

I mean if I pass date as 25-Sep-2017 what you are expecting in output?

Jacobelia S

I have emailed you the sample test data and rtf.

Thanks

Jacobelia S

I have tried as shown in the enclosed screenshot, however, the date is getting displayed along with the heading.

Jacobelia S

for the format 'day-dd' if date is 25-Sep-2017. it will return Monday-25. You may need to do substr to get Mon-25

The heading already exist, all I need to do is concatenate 'dd'.

Jacobelia S

you can user <?format-date:ParameterName;'day-dd';'Asia/India'?>

I presume that I can exclude the day as I need only the date which is 'dd' and second question is do I need Asia/India? Can I substitute with any Country/Region?

Jacobelia S

Hello,

My expected output is shown in the enclosed screenshot,