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
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.
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.
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.
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
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
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.
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
HenryMiller said…
Juan,
I tried to connect but www.tripro.com seems to be unavailable .
Cheers
HM
HenryMiller said…
Juan,
I tried to connect but www.tripro.com seems to be unavailable .
Cheers
HM
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
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.
Mike Hill said…
Hi,

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

Thanks so much!

Mike
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?

Popular posts from this blog

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 ($

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

How to use Windows SSO with OpenXava

One of the nice things about the .NET web environment is the dead easy way to implement Single Sign On in your web apps through Active Directory authentication. In the Java world there are multiple alternatives to use Windows’ Single Sign On with Java based web apps. One of those alternatives is Waffle . Waffle allows your Java web app to authenticate against Active Directory groups (and users). The only caveat is that your web server needs to be running in Windows, which kind of makes sense. In this article, you will learn the steps required to have your OpenXava web application use Waffle to authenticate your Windows users. The first step is to download Waffle from their site and then copy the JAR files outlined in https://github.com/dblock/waffle/blob/master/Docs/tomcat/TomcatSingleSignOnValve.md to the OpenXava’s tomcat server. In your OpenXava project, create servlets.xml in the Web-inf, containing the following: <!-- the role name (the domain gorup) must be e