Syntax on XML Publisher while converting code from crystal

Vsilvery · May 2, 2017 7:00AM

Summary

Content

hello

below is the crystal report code. i want to convert this code to XML publisher. Can someone help me

StringVar CityStateSpacer;

if {APY2021.CITY.A} = "" Or {APY2021.STATE.A} = "" then

CityStateSpacer := " "

else

CityStateSpacer := ", ";

TrimRight ({APY2021.CITY.A})+CityStateSpacer+{APY2021.STATE.A}+" "+{APY2021.POSTAL.A}

i tried Choose syntax, its not working

<?choose:?><?when:A.CITY=''?><?xdoxslt:set_variable($_XDOCTX, ‘Test’,123)?><?end when?><?otherwise:><?xdoxslt:set_variable($_XDOCTX, ‘Test’,999)?><?end otherwise?><?end choose?>

Jim Mcdonald · May 2, 2017 7:00AM

Is the question mark missing in the "otherwise" case in your template? It should be <?otherwise:?>.

Jim Mcdonald · May 3, 2017 7:00AM

xdoxslt and xdofx cannot be mixed.

Vsilvery · May 3, 2017 7:00AM

I m getting error on below. can you please suggest

<?xdoxslt:set_variable($_XDOCTX,'descr',xdofx:upper(D.DESCR))?>

i assumption that we can mix xslt and xdo function

Vsilvery · May 3, 2017 7:00AM

Thanks. its working

MFA for Oracle Community

Oracle Analytics Cloud and Server

Categories

Syntax on XML Publisher while converting code from crystal

Summary

Content

Answers