Home » Fusion Middleware & Colab Suite » Business Intelligence » Multi Layout Style in XML Publisher Reports (Xml Publisher Release 11i, Oracle Applications R12)
Multi Layout Style in XML Publisher Reports [message #457448] Mon, 24 May 2010 09:00 Go to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
I created a Place holder column to capture the layout style for an multi layout report with 3 parameters as Emp,Dept and Both in rdf and my report is running successfully.
I have created a value set with these 3 parameters and while running the concurrent program, the report is running successfully with these 3 parameters of 3 layout styles.

But in xml publisher i wrote the if condition for multilayout like this.

1. for emp table - <?if :CP_Layout_Style = 'Emp'?>
2. for dept table - <?if :CP_Layout_Style = 'Dept'?>

Then it giving right output with Emp and Dept parameters.

If i want to give 3rd parameter as 'Both' , then how can i write the if condition for that.

i tried with the fallowing 2 methods but it causes Warning.
<?if :CP_Layout_Style = 'Emp'
else
if :CP_Layout_Style = 'Both'?>

and

<?if :CP_Layout_Style = 'Emp' or if :CP_Layout_Style = 'Both'?>


Help me to write the If condition for this
Re: Multi Layout Style in XML Publisher Reports [message #457455 is a reply to message #457448] Mon, 24 May 2010 09:42 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Try this..
<?if:CP_Layout_Style = 'Emp' or CP_Layout_Style = 'Both'?>

By
Vamsi
Re: Multi Layout Style in XML Publisher Reports [message #457456 is a reply to message #457455] Mon, 24 May 2010 09:50 Go to previous messageGo to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
I tried with that you specified. But again it causing the same error.


--------------
error message
--------------

Post-processing of request 43027567 failed at 24-MAY-2010 15:46:47 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.
+------------- 2) PRINT -------------+
Not printing the output of this request because post-processing failed.
Re: Multi Layout Style in XML Publisher Reports [message #457457 is a reply to message #457456] Mon, 24 May 2010 09:56 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
As it mentioned, you need to check the OPP service log, why it is erring out.
If you can install the desktop XML Publisher Template Viewer, then check by providing the XML output to that Template Viewer.

By
Vamsi
Re: Multi Layout Style in XML Publisher Reports [message #457534 is a reply to message #457448] Tue, 25 May 2010 02:01 Go to previous messageGo to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
Can anyone reply me, how to write nested if conditions in xml publisher please..
Re: Multi Layout Style in XML Publisher Reports [message #457536 is a reply to message #457534] Tue, 25 May 2010 02:08 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Whatever I've give already, that is perfectly working for me.
As I told earlier, please check the OPP service log.
If you didn't get any clue, upload it.

By
Vamsi
Re: Multi Layout Style in XML Publisher Reports [message #457541 is a reply to message #457536] Tue, 25 May 2010 02:35 Go to previous messageGo to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
"Consult the OPP service log for details."

Can you please tell me how to check the OPP service log
Re: Multi Layout Style in XML Publisher Reports [message #457547 is a reply to message #457541] Tue, 25 May 2010 03:01 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Check this.
Search for 'How to obtain the OPP debug log files'.

By
Vamsi
Re: Multi Layout Style in XML Publisher Reports [message #457570 is a reply to message #457547] Tue, 25 May 2010 04:22 Go to previous messageGo to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
Thanks for your reply.
i checked that opp log file and find the error : 'If was used with out declaration'
so i rewrite the if condition as fallowing 2 ways, the concurrent program completed with normal, but it giving same output(Emp Data,Dept Data) by passing the 3 parameters Emp,Dept and Both.

1. <?xdofx: if :CP_OUTPUT_TYPE = 'Emp' or if :CP_OUTPUT_TYPE = 'Both' ?>

2. <?xdofx: if :CP_OUTPUT_TYPE = 'Emp' or :CP_OUTPUT_TYPE = 'Both' ?>

Help me how to get the required output by passing the parameter
Re: Multi Layout Style in XML Publisher Reports [message #457582 is a reply to message #457570] Tue, 25 May 2010 05:00 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
I've neither your XML nor the RTF. Even output.

By
Vamsi
Re: Multi Layout Style in XML Publisher Reports [message #457597 is a reply to message #457582] Tue, 25 May 2010 05:58 Go to previous messageGo to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
Can you please tell me How to upload the rtf file, the forum does not supports the rtf file format to upload.
Re: Multi Layout Style in XML Publisher Reports [message #457598 is a reply to message #457597] Tue, 25 May 2010 06:01 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Save it as doc.

By
Vamsi
Re: Multi Layout Style in XML Publisher Reports [message #457621 is a reply to message #457598] Tue, 25 May 2010 07:14 Go to previous messageGo to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
But doc format is also not allowed to upload
Re: Multi Layout Style in XML Publisher Reports [message #457656 is a reply to message #457621] Tue, 25 May 2010 09:29 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Upload your xml, output, the screen shot of the rtf and paste the code from rtf for that particular form field.

By
Vamsi
Re: Multi Layout Style in XML Publisher Reports [message #457661 is a reply to message #457448] Tue, 25 May 2010 09:57 Go to previous messageGo to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
This is output file
  • Attachment: Output.GIF
    (Size: 56.97KB, Downloaded 1822 times)
Re: Multi Layout Style in XML Publisher Reports [message #457662 is a reply to message #457448] Tue, 25 May 2010 09:59 Go to previous messageGo to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
This is Screen shot of Template file
Re: Multi Layout Style in XML Publisher Reports [message #457667 is a reply to message #457662] Tue, 25 May 2010 10:11 Go to previous messageGo to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
i write the fallowing code for first if condition
<?xdofx: if :CP_OUTPUT_TYPE = 'Emp' or :CP_OUTPUT_TYPE = 'Both' ?>

i write the fallowing code for second if condition
<?xdofx: if :CP_OUTPUT_TYPE = 'Dept' or :CP_OUTPUT_TYPE = 'Both' ?>

The concurrent program is running successfully, but it giving both tables(Emp,Dept) data when i pass the 3 parameters.

But my intension is to output only Emp Details when i pass the parameter 'Emp', and only Dept details when i pass the parameter 'Dept', and both tables data when i pass 'Both'.
Re: Multi Layout Style in XML Publisher Reports [message #457668 is a reply to message #457448] Tue, 25 May 2010 10:14 Go to previous messageGo to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
This is Xml file saved in txt format
  • Attachment: Xml file.txt
    (Size: 2.73KB, Downloaded 2160 times)
Re: Multi Layout Style in XML Publisher Reports [message #457739 is a reply to message #457668] Tue, 25 May 2010 15:54 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
If you give half cooked information, you will get the same.
In my first post, I've given the following.Quote:
<?if:CP_Layout_Style = 'Emp' or CP_Layout_Style = 'Both'?>
Anyway the tag is wrong. Seems you have corrected it later, as I can see that in the XML output.
So, you need to use
<?if:CP_OUTPUT_TYPE = 'Emp' or CP_OUTPUT_TYPE = 'Both'?>
<?if:CP_OUTPUT_TYPE = 'Dept' or CP_OUTPUT_TYPE = 'Both'?>
Don't put a single ':' extra. This is working perfectly fine for me.
If you could have followed this previously, this thread wouldn't have prolonged.

Moreover I didn't get why you are trying to use xdofx?
Tried to Google. But not sure how that helps in this scenario.

By
Vamsi
Re: Multi Layout Style in XML Publisher Reports [message #457772 is a reply to message #457448] Tue, 25 May 2010 23:54 Go to previous messageGo to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
Hi Vamsi,
Thank 's for your help.

So here the problem is i placed the placeholder column in small letters.
I tried with your tags and the report is resulting successfully.
There is no use of using 'xdofx' in this scenario, it is only useful when we are using if-then-else structure, i tried it only for testing the report(if it works properly or not).

Once again thank you very much.
Re: Multi Layout Style in XML Publisher Reports [message #457844 is a reply to message #457772] Wed, 26 May 2010 02:42 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Quote:
<?xdofx: if :CP_OUTPUT_TYPE = 'Emp' or :CP_OUTPUT_TYPE = 'Both' ?>

i write the fallowing code for second if condition
<?xdofx: if :CP_OUTPUT_TYPE = 'Dept' or :CP_OUTPUT_TYPE = 'Both' ?>
I think the issue is with ':' (before 'CP_OUTPUT_TYPE' and after 'or') and xdofx.
Some how that is getting always true.

By
Vamsi
Re: Multi Layout Style in XML Publisher Reports [message #526784 is a reply to message #457534] Thu, 13 October 2011 01:05 Go to previous messageGo to next message
vishnu402
Messages: 1
Registered: October 2011
Junior Member
Hi Vamsi,

iam working on multi layout xml report.
In that i have 4 options.CP_1=1,2,3&4

if i select 1 will disply 1st layout if i select 2nd option no rows selected but the data is available xml tags.
why it is happening.the loop will not moving into nd lay out .
please do need full

Regards
Vishnu
Re: Multi Layout Style in XML Publisher Reports [message #553915 is a reply to message #457448] Wed, 09 May 2012 05:28 Go to previous message
madhavk
Messages: 1
Registered: May 2012
Location: Hyderabad
Junior Member
hi,

you have any document on Multi Layout XML Publisher report. please send me its urgent.
Previous Topic: Forecasting and predictive solution in oracle BI
Next Topic: Sales Value Vs Target Value Sales Engineer Graph
Goto Forum:
  


Current Time: Thu Mar 28 05:28:29 CDT 2024