Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Unfortunately, that did not work either. Here is how it looks when I put in your code. <?Date___local_ID669?><?xdoxslt:set_variable($_XDOCTX, 'headerMonth', substring(Date___local_ID669, 6, 2))?><?xdoxslt:set_variable($_XDOCTX, 'prevMonth', xdoxslt:if(substring(Date___local_ID669, 6, 2) = '01', '12',…
-
Unfortunately, that did not work. I get an error for to_number. <?xdoxslt:set_variable($_XDOCTX, 'prevMonth', xdoxslt:if(substring(Date___local_ID669, 6, 2) = '01', '12', xdoxslt:format_number(to_number(substring(Date___local_ID669, 6, 2)) - 1, '00')) )?>
-
I have something that works. <?xdoxslt:set_variable($_XDOCTX, 'headerMonth', substring(Date___local_ID669, 6, 2))?> <?for-each:A_R_Statement_Detail_S9?> <?if:substring(Invoice_DueDate_ID67, 6, 2) = xdoxslt:get_variable($_XDOCTX, 'headerMonth')?> <!-- Your detail layout fields go here, like: --> <?Invoice_DueDate_ID67?>…
-
Unfortunately, none of the suggested fixes have worked. I am still looking for a resolution.