Hello, For using BIP API you have this link: https://docs.oracle.com/middleware/12213/bip/BIPDV/webservices.htm#BIPDV002 or REST (https://docs.oracle.com/middleware/12213/bip/BIPAP/toc.htm ). Here is an example using java :Oracle BI Publisher Consulting: How to Run a Report with BI Publisher Web Service? If you want more…

Hello, You could send the rtf and the sample.xml. Regards, Carlos

Hello, I am not guru , but looks (and your title suggests it) that these values are coming from distinct data sets. Can you please attach the sample.xml to check it better. If that is the case (the data is not correlated) how do you expect the excel/word(whatever output) to correlate it? I do not think it is possible…

Hello, I have done it for image only ( ). Never tried text, but if you do as if it was an image what happens? Regards, Carlos

Hello, on line 17 of your query: , coalesce(spl.WEIGHT_UOM_CODE,' ') PU_WEIGHT_UOM , select debrief.ITEM_PACKAGE_COUNT you have a 'select' word which the compiler understands that is either a mistake (and you can delete it) or, as mentioned by ​ is a subquery and in that case you have to make proper adjustments like:…

So..., close it!

Hello, Check if the following is still missing rigth parentisis: select sum( itm.ITEM_PACKAGE_COUNT) ,sum( coalesce(spu.TRANSPORT_HANDLING_UNIT_GID,'-') )TRANSPORT_HANDLING_UNIT_GID ,coalesce(substr(TRANSPORT_HANDLING_UNIT_GID, instr(TRANSPORT_HANDLING_UNIT_GID,'.', 1)+1, length(TRANSPORT_HANDLING_UNIT_GID)),'-')…

Perhaps not, but i bet there is more in that error than you posted. You want us to help you, but do not provide full error stack and hope we imagine the issues? Luckily i think it might be in the order by, but next time do a favor to all of us and post all the info we need to help you out: select sum(…

run it in db IDE (sql plus or developer).

With one IDE you would easily check for errors in the query and test if it was ok. If you can run the report please provide the sample.xml generated output. Thanks, Carlos

Hello, I a mgoing to repli with my 2nd post to this discussion: why can´t you do a query like: select item, sum(quantity) from table where 1=1 group by item; ? and display it as a table in report? Regards, Carlos

Hello, No prob. That does not imply anything. Think of it just as a placeholder for any filter criteria you need to add to the query itself. Regards, Carlos

If you do not know, we don´t know either We do not have your Database schema and tables to know the types of your columns, but seems to me you will have to make another data set for that info like(not sure if it works): select sum( itm.ITEM_PACKAGE_COUNT) ,sum( coalesce(spu.TRANSPORT_HANDLING_UNIT_GID,'-')…

Hello, Perhaps these guys (SQL & PL/SQL ) can help you in that. Regards, Carlos

Hello, DB = DataBase; When i say DB scripts is the syntax to create the tables you have and populate them with some data in order to be able to run DataModel in my schema. possible to keep "<?for-each:current-group()/ITEM?" and add the Shipment_debrief Data Set aswell ? I do not know the answer Regards, Carlos

One thing for the moment, like previously said: one step a time. The DS were different - have you change them to be all the same? Have you tried to run the data set with all DS pointing to the same? The result is the same of the one you sent me(i attach in this)? The data model is still the same(i don´t mind the sql query…

Hello, Before MSWord there is an issue with the Data Model has you have no data from G_1(aka Shipment_Debrief) data set. Therefore you have no fields from G_1(aka Shipment_Debrief) dataset to use in MSWord. This is something i´ve never seen before and not being able to run and try is time consuming.Can you create a simple…

Hello, Can you pls provide a screen shot of what you intend as output layout result (i do not use crystal-therefore i do not know what you are referring to)? Thanks Carlos

Hello, For what i see you just need to use the tag: <?xdoxslt:sum(//FIELD_NAME)?> in last row of the rtf template e.g.: <?xdoxslt:sum(//Project_Miles)?> Regards, Carlos P.S.- Ah, after post i saw the other response and realize one thing i missed (the group), so include that suggestion also.

Ok, understood. So solution is by editing source query as replied by ​ Besides, why are you having to process the data in BIP when you can do it in the SQL wich will not impact (has much) in performance. BR Carlos