matthall

Many thanks Thomas. I think the links you have provided there will be most helpful. CSV probably would be sufficient. I'm using a link to an oracle database behind Red Prairie Dispatcher so it's not a database that I have any control over as it underlays the third party application. That said there are some redundant tables which might be highjacked for this purpose. It's a solution I'm hoping the users will sign up for but the above was my first thought and one I can now hold in reserve. Thanks again.

I am creating a report that sends delivery details out to our courier, including an email address that then generates an email to the customer. The functionality is currently switched off at the couriers end but we are looking to turn it on. We are anticipating some feedback that certain customers do not want this service but rather than edit each out individually I was hoping that I could set up a spreadsheet of exclusions which my ireport could reference and therefore not display any that wer ein the spreadsheet. Is that possible? Thanks

Returning to this a month on... I tried to pass each digit through individual variables but cam up against a 'maximum file size' problem. Now investigating user defined functions to reduce the large but repeptitive functions into smaller call functions.

I'm back on this after a break but to no avail - any ideas out there?

Hi, I am required to calculate a check digit at the end of a 27 character string. I have the string (separately constructed and held) in a Variable. I include the basic logic for calculating this below. Of the string the majority of characters are numeric and so do not need converting to numeric alternatives as per step one. That said, the first seven characters will be formed of the postcode and so may need these conversions on any given character (where the postcode is shorter than 7 characters 0 is used to fill). Can anyone advise on the best way to accomplish this task? Can I do multiple looping calculations within a single varibale? Will I need a scriptlet instead? Can someone talk me through creating one because i have no idea!? ----------------------------------------- 28 & 14 Digit Check Digit Calculation Function to create a Check digit for barcode strings using ISO 7064 Mod 37, 36 This calculation is also to be used to generate the Parcel Tracking No: check digit. Maintain two variables through the function: V initialised to zero Reset for use on each character. Cd initialised to 36 Running value maintained through the function. Loop through all the characters of the string For each character Calculate V where; 0=0, 1=1, 2=2, 3=3,…. A=10, B=11, C=12, D=13,E=14,….. ---------------------------------- Add the resultant V to running value Cd If Cd is greater than 36 then subtract 36 from Cd. (Cd = Cd – 36) ---------------------------------- Multiply Cd by 2 (this value is now an even number between 2 and 72) ---------------------------------- If Cd is greater than 36 then subtract 37 from Cd. (Cd = Cd – 37) ---------------------------------- After all characters have been processed: Subtract the resultant Cd from 37 (Cd = 37 – Cd) If Cd equals 36 then reset Cd to Zero Once cycled through all characters the resultant Cd is converted back to a check digit, where; 0=0, 1=1, 2=2, 3=3,…. A=10, B=11, C=12, D=13,E=14,…..

Removed the XA and XZ commands and this now works - no idea what those were doing specifically but they were included in the Zebra documentation and not in my original StreamServe coding - doh! "^FO50,1250" + "^GB735,60,60,B,0^FS" + "^FO55,1255^CFG,40,35" + "^FR" + "^FD"+$F{INV_CONTACT_FAX}+"^FS" It is still a little peculiar, the code ought to set the size and location of both the black box and the text but; I seem to need to control the text location by field placement within iReports - it doesn't get placed by the Zebra code (whereas it does in StreamServe) I have two separate labels each with the black box in different places. To create the second I simply moved the variable location in the iReport, adjusted the black box position using the zebra code ("^FO50,1250" + ==>>> "^FO50,850" +) and yet the font size comes out smaller on the second. Weird. At any rate a satisfactory result achieved

At a guess i tlooks like for anything lower than 3 there is not enough space in the band to display the number. Can you test this by reducing the font size in general? I've never used graphs so wouldn't know. Assuming that is the problem, how you could then fluctuate font size for any label count less than four I'm not sure...?

I need to print white text on a black background to a Zebra printer. Whilst these are configurable settings in iReports the zebra doesn't respond to them and will print an unfilled rectangle with black text in it if I try to do it this way. I am trying instead to send the Zebra print commands (I have used these successfully before in a StreamServe project) and whilst this now works [white text on black background] none of the other fields, static text, lines etc. that I have displayed on the report are printed! I am using zebra command within a variable: "^XA" + "^FO50,1250" + "^GB735,60,60,B,0^FS" + "^FO55,1255^CFG,40,35" + "^FR" + "^FD"+$F{INV_CONTACT_FAX}+"^FS" + "^XZ" Any advice on either the Zebra command or any alternatives I might attempt much appreciated.

Thank you. That was so much easier than I was trying to make it, I'm sure we have probably looked straight past that fields on a number of occassions. Works a charm, much appreciated.

I have tried all kinds of control characters none to any avail so still wondering if anyone mightt assist. In general printing to a Zebra printer (via Red Prairie Dispatcher) seems to be troublesome so any general advice or direction to useful guides in this field would be most welcome

[EDIT 13/04/12 11:20: Summary; Need new line / carriage return character for printing to Zebra printer] Hi, My colleague and I are new to iReports but are attempting to replicate some output that we currently have from StreamServe in the iReports environment. In particular (and the reason I am here) printing despatch labels on a Zebra printer. We are trying to print the address in standard address format on multiple rows. Each row may or may not have data. e.g: Name = Mr Bishop Address1 = Honeydew Road Town = Leicester County (null) PostCode = LE9 2RR We'd want this to discount the null line (wherever it appears) and build up an address without ny blank lines e.e Mr Bishop Honeydew Road Leicester LE9 2RR We've achieved this by passing the fields through an if statement within individual variables and building them into a final variable for the address. $V{NAME} $F{NAME}!="#"?$F{NAME} +"n":"" $V{ADDRESS1} $F{ADDRESS1}!="#"?$V{Name} + $F{ADDRESS1} + "n":$V{Name} $V{TOWN} $F{TOWN}!="#"?$V{ADDRESS1} + $F{TOWN} + "rn":$V{ADDRESS1} .... and so on... The difficulty comes from getting this fully formed address variable to output on separate lines. As you can see we are attempting to use the java n andor rn commands to do this and in iReports it outputs correctly. Having published to our host system (for info: Red Prairie Dispatcher) the label printed via a Zebra printer just outputs each line one on top of another. I'm hoping that someone has experienced (and overcome) a similar issue and might advise. Many thanks, MattHall Code: Post Edited by matthall at 04/13/2012 10:21