Skip to main content

Mail labels and letter templates for jasperreports

The following are free (MIT license) mailing labels and letter templates for jasperreports that you can download and use in jasperserver and/or ireport:

Update 3/15/2011: I moved the Mail templates zip file here. Please consider making a small donation if the templates are of help to you, Thank you!

If you need more information on how to use those templates please leave a comment in the blog.

Comments

Stefaan Somers said…
Where can I find this datasource. Can I download this database somewhere.

Can you also show the results of the labels once : does it print more than one label in the length.

Already many thanks for your help
12:20 AM
Juan Pablo said…
The sql queries in the templates were made for the database of a propietary student information system named RenWeb. However you can easily modify the sql query to fit your database, I recommend using iReport for that.

Yes, the labels template do print 3 across because it uses columns.
7:48 AM
Anonymous said…
Hi, thank for your template, work great. I ran into some difficulty in my servlet when compiling the .jrxml. In iReport it work perfecly, but in tomcat, jasper compiler crash with the folling error
java.lang.NoClassDefFoundError: org/codehaus/groovy/control/CompilationFailedException
Simply edit Mail_label_5960.jrxml and remove the language="groovy" attribut from jasperReport node.
4:18 AM
Juan Pablo said…
Hi André, thank you for your tip, I had forgotten to mention that I use groovy for all my templates :). At work I also use jasperserver but I have the groovy jars in the lib folder of the jasperserver webapp, so I guess that is why it worked for me. Thank you again for your solution to that potential problem.
1:24 PM
Anonymous said…
Juan,

Thank you for your sample.

I have recently been asked if iReport has templates for Avery labels, and yours is the only posting I have found so far.

Up to this point, I have only used iReport for basic forms and reports, and have not delved into java or groovy much.

Just how would I use the Avery sample you point to within iReport?

Are there any other Avery label templates you are aware of, or will I need to create one each time someone requests one?

Thank you,
Thomas
11:13 AM
Anonymous said…
Juan,

Never mind...I figured out how to use the sample in iReport.

Sometimes the most obvious answer is the hardest to see. If I took one second to look at the sample's file name it would have been self-evident.

Thank you,

Thomas
1:10 PM
Anonymous said…
Juan, I'm the I.S. Administrator for a church that is considering RenWeb for it's new Academy in 2009. Our RenWeb sales rep isn't very forth-coming about the RenWeb database. Two questions:

Is there a published ODBC connection or database diagram for RenWeb?

Have you heard of anyone importing into the RenWeb database?

Thanks...bc.
10:18 AM
Juan Pablo said…
Dear I.S. Administrator,

For now, RenWeb provides READ ONLY access to their SQL Server database. The database is a MS SQL server 2005 and you have *view* access to pretty much all the data in the program. There is no diagram of the database structure, but there is an spreadsheet listing all the fields and tables. I use iReport when creating reports and it has a nice interface to deal with the tables; you may find this or any other reporting tool handy. We access the database using JDBC, but you will also be able to use ODBC or anything else that can connect to an MS SQL Server.

Before buying RenWeb, I thought I could import data programitaclly (SQL or .NET) but that is not the case. The main reason they do not allow write access to their internal database is that the user could mess it up by executing the wrong SQL query. And no, they won't make any exceptions to this rule ... I already tried :)

Another thing worth noting is that they plan to replace this direct access to their database with a specialized Reporting tool. They have not find the right tool yet, so they still allow people to use SQL directly. That is probably why the sales rep did not want to talk about it, maybe he knows the SQL access won't be there for long.

In general, RenWeb has proven to be a fine SIS for us and specially for our teachers (they love the gradebook and homework modules b/c of their simplicity)

God bless,
Juan
3:39 PM
HenryMiller said…
Juan,
I tried to connect but www.tripro.com seems to be unavailable .
Cheers
HM
12:08 AM
HenryMiller said…
Juan,
I tried to connect but www.tripro.com seems to be unavailable .
Cheers
HM
12:08 AM
Juan Pablo said…
Hi Henry!

My new webhost had some problems transferring the domain name. The link in the post should be working now; if it does not, try clearing the DNS cache.

Thanks,
Juan
3:46 PM
wwhite said…
That's excellent.
I have been having issues creating html and css template with avery, with issues of printing from firefox.

I have used iReports before. Took me about 15 minutes to modify to suite my database, then printed 800 labels, perfect fit with Avery 5960.

Also, if you need the schema this came from, its pretty easy to reverse engineer the query, and the tables pop out. If you don't understand the query, then you probably won't understand the schema.
1:02 AM
Mike Hill said…
Hi,

Your website is not available. Do you have the zip file somewhere else?

Thanks so much!

Mike
8:36 AM
etanus said…
Hi,
I see that the last post in your blog was 2014. Hope that you still work on JasperSoft labels.
We need to print spine lables for books from Sierra Integrated Library system by Innovative Interfaces. The samples that are available do not meet the format for A4 pages we need for 3x8 labels on A4 paper format. The samples were configured and compiled with iReport from JasperSoft.
I found your samples here and tried to adapt them to our required format, but did not succeed, as I do not have experience with Jaspersoft. Would you be able to help us?
Thanks
Renate Morgenstern
Library, Namibia University of Science and Technology,
Windhoek, Namibia
10:59 AM
Unknown said…
hey, How did you do this? I am trying to create mailing level using avery template in ireport. Is there a way to set the height, width to avery style?
8:48 AM
Post a Comment

Popular posts from this blog

Powershell script for converting JPG to TIFF

The following Powershell script will convert a batch of JPEG files to TIFF format: #This Code is released under MIT license [System.Reflection.Assembly]::LoadWithPartialName("System.Drawing") $files_folder = 'C:\path-where-your-jpg-files-are\' $pdfs = get-childitem $files_folder -recurse | where {$_.Extension -match "jpg"} foreach($pdf in $pdfs) { $picture = [System.Drawing.Bitmap]::FromFile( $pdf.FullName ) $tiff = $pdf.FullName.replace('.PDF','').replace('.pdf','').replace('.jpg','').replace('.JPG','') + '.tiff' $picture.Save($tiff) }
Post a Comment
Read more

Power Automate: SFTP action "Test connection failed"

When I added an SFTP create file action to my Power Automate flow ( https://flow.microsoft.com ) , I got the following error in the action step, within the designer: "Test connection failed" To troubleshoot the Power Automate connection, I had to: go the Power Automate portal then "Data"->"Connections"  the sftp connection was there, I clicked on the ellipsis, and entered the connection info It turns out, that screen provides more details about the connection error. In my case, it was complaining that "SSH host key finger-print xxx format is not supported. It must be in 'MD5' format". I had provided the sha fingerprint that WinScp shows. Instead, I needed to use the MD5 version of the fingerprint. To get that, I had to run in command line (I was in a folder that had openssh in it): ssh -o FingerprintHash=md5 mysftpsite.com To get the fingerprint in MD5 format. I took the string (without the "MD5:" part of the string) and put
Post a Comment
Read more

Alert if file missing using Powershell

The following Powershell script can be used to send an email alert when a file is missing from a folder or it is the same file from a previous check: $path_mask = "yourfile_*.txt" $previous_file_store = "lastfileread.txt" $script_name = "File Check" ###### Functions ########## Function EMailLog($subject, $message) {    $emailTo = "juanito@yourserver.com"    $emailFrom = "alert@yourserver.com"    $smtpserver="smtp.yourserver.com"       $smtp=new-object Net.Mail.SmtpClient($smtpServer)    $smtp.Send($emailFrom, $emailTo, $subject, $message) } Try {    #get files that match the mask    $curr_file = dir $path_mask |  select name    if ($curr_file.count -gt 0)    {        #file found        #check if the file is different from the previous file read        $previous_file = Get-Content $previous_file_store        $curr_file_name = $curr_file.Item(0).Name        if ($
Post a Comment
Read more