Oh ok but this is directly linked to OTM and not FTI so I already checked, I wanted to see if there was a role in FTI I could change or something like it. I will check again what you tell me but I haven't seen anything corresponding to what I'm looking for, for the moment

For information I've added this for-each@section outside the header which seems to work better : The template changes the information in the header but all of the rest of the template is blank :

Ok I have deleted a For-each loop and it works fine now, sorry for spamming my thread... :

Hello, Do you know what seems to be the problem in my header ? This is what I have in my template

Ok sorry for this thread, I should've closed it on friday evening. Problem was fixed but I don't know yet how.

Well I posted this : 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)),'-') TRANSPORT_HANDLING_UNIT_XID from SHIP_STOP_ITEM_BOV itm…

Weirdly I get "TRANSPORT_HANDLING_UNIT_XID": invalid identifier

Well, appart from the ORA number, that was the only error message I got: With your new SQL the Data set can be created (G_1) : But when I run the report it says "report not valid" and I also get this message : ORA-01722: invalid number -- I don't know if it's not coming from the fact that I didnt use links like for other…

My internet is very slow atm so if i can avoid downloading SQL Dev it's better. I tried to run SQL plus with a tuto but I get "'sqlplus' is not recognized as an internal or external command," in cmd, do you have an idea why ? Edit: I created a link and I can now launch the report but it doesn't change anything, there is no…

What do you call an IDE ? I have an SQL Execution Interface in Oracle where I can try this query but it says : java.rmi.AccessException: [EJB:010160]Security violation: User DBA.CONFIGDBA has insufficient permission to access EJB type=<ejb>, application=GC3App, module=SqlSession.jar, ejb=SqlSessionHome, method=execute,…

Any idea ? I still havent found out how to do it with nested groups as ​ said and I don't want to be using table wizard actually because it doesn't seem to suit my need and I want to keep my tables how they are currently displayed.

Sorry i'm a newbie, what does "where 1=1" imply ?

Well I don't know if it's possible. Here is my "ITEM" Data Set : select itm.SHIPMENT_GID , itm.STOP_NUM , itm.STOP_ACTIVITY , itm.ORDER_RELEASE_GID , itm.ORDER_RELEASE_XID , itm.OR_LINE_GID ,LTRIM(itm.OR_LINE_GID,itm.DOMAIN_NAME||'.') OR_LINE_XID , itm.S_SHIP_UNIT_XID , itm.ITEM_GID , itm.ITEM_XID , itm.ITEM_PACKAGE_COUNT…

Because I've tried but I can't manage to make a group by in the SQL, I don't think it's this simple

Di you have any idea how to add this query : SELECT t1.shipment_gid, t1.ITEM_PACKAGE_COUNT as ITEM_PACKAGE_COUNT_DEBRIEF FROM (select t.*, row_number() over (partition by s_ship_unit_gid ORDER BY INSERT_DATE DESC) rn FROM shipment_stop_debrief t ) t1 where rownum=1 in this : --- ITEM DATA SET ---- select itm.SHIPMENT_GID ,…

I'm not sure to fully understand, when you say DB you mean database ? And I changed G_1 it is now called Shipment_Debrief and this is what I have : So I do have fields, the problem clearly comes from the loop, do you know if it possible to keep "<?for-each:current-group()/ITEM?" and add the Shipment_debrief Data Set aswell…

As indicated in my post from yesterday, yes I have made the changes from data source to make them all the same and the results are the same. I havent made changes to my files appart from the SQL query. As my field works when I get it out of my for-end loop, I assume the problem is coming from this loop which repeats data…

The problem comes from the fact that the loop is on the ITEM Data Set whereas my field is in the Shipment_Debrief Data Set. Do you know how iI can counter that ? I havent done enough research, maybe I can put several groups in this loop.

I'm not sure I understand your post but when I downloaded my XML file, there is nothing that corresponds to shipment debrief in it: As for the link I wanted to create it was more of a test than anything else but before trying to make a link I would like to make it work without any link, as it doesn't atm. Afterwards (but…

I obtained the xml by clicking on export here : But it doesn't seem to be taking the new data set into account. Do you have an email on which I can send you the xml ? Because even in advanced mode I don't have the option to attach any files to my post.