I was able to solve this by using variables and making sure the data type on my field didn't change to Regular text from Number. <?xdoxslt:set_variable($_XDOCTX, 'a', sum(current-group()/PRIOR_EXP) + sum(current-group()/CURRENT_EXP))?> <?xdoxslt:set_variable($_XDOCTX, 'b', sum(current-group()/BUDGET))?> <?choose:?><?when:…

My solution for this was to write a custom view that used SQL from the first query and then left join to the work type code query. This allows me to run the two reports separately on their own. Then, I merge the two report result pdfs after processing into 1 pdf. I wish there was a more elegant solution for this, but it…

fyi, Sareesh, had to create a new SR for this: SR 3-18297137441 

Yup, it's created. 3-18212685491

Ok, thanks Sareesh. And, yes, that is my version of BIP.

Thank you Sareesh. I'm not able to find that Bug in Oracle support. maybe I'm searching incorrectly. I can create an SR through my Oracle Support account. Is there a patch for the problem or some other fix? Thanks, John

finally fixed this... see for reference: http://pplsoftlearner.blogspot.com/2013/03/xml-publisher-passing-run-control.html just had to declare the prompt variables: &ReportName1 = "WYES001"; &oRptDefn = create PSXP_RPTDEFNMANAGER:ReportDefn(&ReportName1); &oRptDefn.Get(); rem MERGER_AET.SIC_CODE; /* fill query runtime…

i see... all of the comments are in 1 location and just have filters applied. fyi, couldn't delete this post... Permissions denied

The user requirement is for the two reports to be merged into 1 PDF like it is in the Crystal Report. I created an Oracle support ticket. Their suggestion was to see Doc ID 1078734.1 ​in Oracle support: E-BI/XMLP: How To Generate A Merged File From Two PDF Reports? (Doc ID 1078734.1) It essentially wants you to code an app…

Hi Venkat, My two datasources have nothing in common. 1 is a list of Vendors and the other is a list of Work type codes. Can the 2 xml data-sources still be combined into 1 XML file? John

Venkat, Thank you for your help. I'm still not getting a result though... This is what is in my 'group row by FIELDVALUE' field in the first column: <?for-each-group:G_1[ColumnVal=1];./FIELDVALUE?><?sort:current-group()/FIELDVALUE;'ascending';data-type='text'?> It just produces a blank column. I also removed the sorting…

It's attached above.

Woohoo! This works nicely! Thank you Venkat! I was pulling out my hair! <?for-each-group:row[COLUMNVAL=1];./FIELDVALUE?><?sort:current-group()/FIELDVALUE;'ascending';data-type='text'?> John

Venkat, I'm having trouble with the for-each-group section. This is what I currently have to get a list of all results. <?for-each-group:row;./FIELDVALUE?><?sort:current-group()/FIELDVALUE;'ascending';data-type='text'?> How do I add the filter to this? (BTW, my custom column name is ColumnVal and it is numerical.) This…

Thanks Sven, I ended up using your SQL listagg in a PS Query expression. Works great. John

Ahhh, that makes a lot of sense, Venkat. Thank you!

I figured it out... the trick was to add a dummy field to the PS query with a Case expression changing the value of the Various County to 'ZVA' and then sorting on that field.

Hi Kavitha and Bean, I've attached images to the top. I'm using Word BIP Plugin 11.119. john

Venkat, is there no solution inside of BIP besides editing the source query?

Bean, I can get the totals.. that's not the problem... I want to hide the details... all of the rows... so I just see the subtotals... j