Morovia Community

[jbonds (legacy member)]

Is there a way to change the security level/error correction of the PDF417 barcode using the UFL in Crystal Reports?

Thanks

[glitch (legacy member)]

The current UFL does not support setting the security level. It sets the propety to automatic (9).

We will accommodate this request into the next release of 2D UFLSurrogate upgrade. It will be released as a minor upgrade to the 2D UFL module(free upgrade).

[Guest]

The current UFL does not support setting the security level. It sets the propety to automatic (9).

We will accommodate this request into the next release of 2D UFLSurrogate upgrade. It will be released as a minor upgrade to the 2D UFL module(free upgrade).

[jbonds (legacy member)]

Ok, sounds good. When will this release be available?

[glitch (legacy member)]

It will be released at the end of the month as a separate upgrade module.

[glitch (legacy member)]

If you are looking for an upgrade module, visit here:

http://www.morovia.com/supportforum/for ... _PN_1.html

[RussellHaper (legacy member)]

If you have an SQL back-end then.....

The best way I found to alter the security level and other attributes is to create an SQL Function which returns the encoded results to Crystal Reports. This eliminates using the MoroviaPDF417Encode function in Crystal Reports and having to use trunk numbers to seperate a string that is more than 255 characters. Here's the function I created:

Code: Select all

CREATE FUNCTION fn_2dbarcode (@datain char(263))
RETURNS varchar(3000)
AS
BEGIN
     DECLARE @obj int
     DECLARE @Result varchar(5000)
     
     EXEC @Result = sp_OACreate 'Morovia.PDF417FontEncoder', @obj OUT

     EXEC @Result = sp_OASetProperty @obj, 'PDFMaxCols', '9'
     EXEC @Result = sp_OASetProperty @obj, 'PDFMaxRows', '0'
     EXEC @Result = sp_OASetProperty @obj, 'PDFSecurityLevel', '4'

     EXEC @Result = sp_OAMethod @obj, 'Encode', @Result OUT, @datain
     EXEC sp_OADestroy @obj OUT

     RETURN(@Result)
END

I then created a view which passed my 2D barcode into the function to return the encoded result. If you want you could make the max columnns/rows and security levels paramaters that are passed in when the SQL function is called

Edited by RussellHarper on February 07 2007 at 11:06am