Create Mailing Labels

Hi nancy,

I don't have a copy of 2.1.3 to test on, but you should be able to use a 2 column, 1 row grid with a list box in each cell. Then you should be able to filter the data for each list box to only include every other line from the dataset. You'll probably have to create a computed column that does a running count of each row in the dataSet to use in the filters. Then, the only thing left will be to get your sizing down to fit the way you want.

nancyw

Thanks for the quick response, Michael. I'll give it a shot.

nancyw

Michael,

Thank you, thank you, thank you. It works great!

Nancy

Hi Michael
I am trying to create a similar type of report but being new to BIRT iam not able to recreate the same report.
Can you please send me the steps in details or a sample report for the same report type.
Its really Urgent as i need to propse a slolution to my Boss by today

Hi SDusad,

What version of BIRT are you using?

Hi Michael
I am using BIRT version 2.3.
I have also seen that you had uploaded a sample report regarding the same in some other thread.
Can you please upload the same report here as i am not able to download the report from that thread.

Thanks and Regards
Sushant Dusad

Sushant, 
 
Is this the thread that you tried to download the example from? 
 
<a class='bbc_url' href='http://www.birt-exchange.org/forum/designing-birt-reports/12725-mailing-label-report.html'>http://www.birt-exchange.org/forum/designing-birt-reports/12725-mailing-label-report.html</a> 
 
If so, what was the issue with the download? I was just able to save it to my BIRT 2.3.2 workspace and run it there. Let me know.

Hi Michael,
I got the report yesterday properly downloaded using FireFox.
Initially i was using IE for downloading it and it was redirecting me to the Login page inspite of being logged in. ( Microsoft

).
Anyways thanks for your help.

Thanks and Regards
Sushant Dusad

Sushant,

That's odd. What version of IE are you using? I typically always use IE and haven't seen that.

As for the help. No problem. That's what we're here for.

Let us know whenever you have questions.

I am using IE 7.

Hmmm... I am as well. Weird. Hopefully it doesn't happen again. If it does, I guess you have FF to get around it.

Hi Michael,

This mailing label report that you have posted works and looks great! But this one is 3X12 I want the report to be 3X10 labels.. whats the best way to do this?

Thank you!

Is setting the page break interval for all the three tables to 10 my answer?

SuperTime,

Yep, that should do it. Remember to do it on all 3 tables.

Hello again,

I have set up my 3X10 labels per sheet. Now I want to group the mailing lables by different attributes of the customer, eg. group them by state.
I tried using the nested table concept the performance is a major issue with this... What I did was place the main grid which has three tables into one main table which has the grouping.

Whats the best way to do this?

SuperTime,

Are you using dataSet parameters to limit each embedded table? Or are you using filters? Can you attach your report design?

See the attached report where I have added a main table which groups by State. But I am not sure how to link the main table with the three nested table. When you preview the data obvisouly the data from the nested tables repeat for each state.
I am not even sure if this is the best way to acheive groupings on this mailing label report.
Also in this example I am grouping by state, but in real world I can have upto three different grouping on other attributes of the customer like city, zip etc.

SuperTime,

Take a look at the following report design. I created another dataSet that grabs only the States. Then, I added a dataSet parameter to the original dataSet that limits the result set by state. I linked the outer table state value with the dataSet parameter in the binding tab of the inner table. Also, the inner table was put in the group footer of the outer table as not to repeat for every detail row. Let me know if you have questions.

Thanks for your report file, but I am using BIRT 2.3.2 and I am unable to open this report. How can I convert this to my version?

SuperTime,

Sorry about that. You may be able to change the version information in the XML Source to match your version info. If not, I'll make a report in your version and attach it.

I literally copied and pasted my version information from XML to this report, the layout tab is still grayed out.

Can you please upload a converted version. Thank you!