Ok i sent you the email

This is what I get if I put your code with arial The concerned field is the one on the right (123456789012)

My SQL table for my Data Set shipment is this : select sh.SHIPMENT_GID , sh.SHIPMENT_XID , sh.DEST_LOCATION_GID , coalesce (c1.CORPORATION_NAME,' ') DEST_NAME ,coalesce (c1.CORPORATION_GID,' ') DEST_GID , l1.LOCATION_NAME DEST_LOC_NAME , l1.CITY DEST_CITY , l1.POSTAL_CODE DEST_CP , l1.COUNTRY_CODE3_GID DEST_COUNTRY ,…

So basically I have a data model (image attached) and when I go in OTM (Oracle Transportation Management) and try to run the pick-up sheet report for multiple shipments, I get only one report with is a merger of the two shipments I selected. Before I couldn't even select more than 1 shipment ID to run a report but someone…

Yes one data model. Actually I need to 2 pdf's that come out from one report. Apparently I can't upload anything other than an image, a video or a link, or maybe you know a way to upload word documents here ?

Ok, I don't necessarily need multiple PDF's actually, if I can get one PDF but with the ShipmentA report and ShipmentB report with data that hasn't merged it is fine as well. I will send you the documents by mail !

The algorithm seems to work fine. My code behind my field is <?format-barcode:SHIPMENT_XID;'code128';'XMLPBarVendor'?> I tried with code128a b and c but it doesn't work so i leave code128 because my font doesn't have a number (its called Code 128, I named it like that in BIP). And yes i've created a register barcode field…

If I remember well, I found my barcode font here https://www.dafont.com/fr/code-128.font . As for the scanner i'm using a android App to scan the bardcode, because i'm assuming if an android app can read it, any scanner will. And since my app can read font 128 and i'm using it, it isn't coming from my app but from the…

Someone else did this before me and added this in the sql for querying the parameter: and SH.SHIPMENT_GID=nvl(:P_SHIP_ID,SH.SHIPMENT_GID) Before this, the error message was "SQL command not properly entered", now it is as i've said "invalid number of arguments". Sorry i'm a newbie on this, I'm trying to help someone.

I changed it but I still have the same error message "ORA-00909: invalid number of arguments --"

My bad I had made a moistake and now there is no more error message when I try to run multiple reports. Reports don't exactly seem to come out the way they are supposed to but I will look into it. Thank you for your help !

Actually I would like to reopen this thread if it's not a problem because my two reports are merged. Do you know how to make 2 distinct reports (either 2 pdf's or 1 pdf after another) ?

Hello Tim, Thanks for your anwser and sorry for my late replay. I had already tried to add the types "a" "b" and "c" but it doesn't work with any of them. Sorry but I don't understand what you mean by the "string" in the world template. Where should I go exactly ?