Yes indeed Carlos, it was a mistake on my part, I think the data source shoud be otmoltp like the other DS. I changed it and it still doesn't seem to work though. I will tell you for the types of connections as soon as I have the answer.

Ok so I got some help on the SQL and this is what I have now : 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 The ITEM_PACKAGE_COUNT_DEBRIEF is now…

If I deleted the link it works just as if I hadn't changed my data model (doesn't take into account the new data set I created).

Hello, Sorry for my late reply. This is the link i've created (G1 corresponds to shipment debrief): I've done nothing else than create the new data set shipment debrief and click on "create a link" from shipment_gid field on the "item" data set. I must be missing something.

Yes I have tested it and it works fine : * I must be doing something wrong in the data model, i've never created one

And my XML works but it comes out without the new fields I've tried to add.

Thanks for your answer, I forgot to post here but I already got my answer on the SQL forum of oracle. The SQL query is: SELECT * FROM ( select t.*, row_number() over (partition by s_ship_unit_gid ORDER BY INSERT_DATE DESC) rn FROM shipment_stop_debrief t WHERE SHIPMENT_GID = 'PEI.H171123883' ) where rn = 1;

Hello Tim, Thanks for you advice on the report wizard, I actually tried using the pivot table as it seems to be more suited. I managed to have this result : by making this pivot table in my rtf : I still have a lot of issues but at least it merges data. Some of the issues that this pivot table is causing are that : * It…

Hello Managed Bean, How can I do that on this forum ? I don't see this option : But i've seen people do it so this option must exist.

I've tried doing this but it doesn't seem to work... ​, why can't I use a nested group on word ? I'm currently trying to work on that but can't seem to merge the data...

Should I have this in my RTF template in MSWord Header ? : I'm sorry but i'm lost, I found documentation on internet but I can't find my answer...

Ok thanks, that would be really helpful, I will try to understand what you wrote on my part to start. managed BEAN yes that's exactly what I mean : SLI---2112 11 and other line with: SLI---0770 46

1. I deleted start and end body 2. I wrote the code <?format-barcode:SHIPMENT_XID;'code128a'?> directly in the header and this is what I get : This super long barcode displays this way in the report but I don't know if I can move it to the right, it seems pretty challenging ( for me) as the barcode in the rtf (above) is…

1. No particular reason. I had two separate fields before thats why I kept it this way but I changed that to shorten it : , to_char(utc.get_local_date(itm.STOP_PLANNED_ARRIVAL, itm.location_gid), 'DD-MM-YYYY HH:MI AM') STOP_PLANNED_DATE_ARRIVAL , to_char(utc.get_local_date(itm.STOP_PLANNED_DEPARTURE, itm.location_gid),…

When I say that I have activated multishipment it means I changed the SQL query in the data model (but that's not important here) and I inserted a for-end loop as shown here: The "BCR" field is the barcode register which is necessary to be before the barcode in order for it to work. So basically my problem comes from the…

I don't think I really understood your article as I get a blank report when I try to follow it. I created a field with this data in it : What am I doing wrong ?

It seems to be working fine thanks !

Sorry for my late response but i've been quite busy. I've looked at your article but unfortunately I don't think it will help me as I don't want to change the font size. Basically I have several tables with variables, and some of them can, in some cases, take up a big part of the page which, if the table starts at 1/2 of…

Yes I already recommended some of your comments and marked them as useful, does it give you points ? I marked my last post as correct as this was the answer to my problem, idk how the point system works.

Ok so my internet is very slow atm so I can't really do tests but it's weird that it took the font from datfont.com since I thought I had uninstalled it and when I uninstalled BIP I couldn't choose the font 'code 128', it appeared again when I reinstalled BIP. The other thing is that I have a french version of BIP in word…