Home » Archived » BIRT » Mailing Labels with BIRT?
|
| Re: Mailing Labels with BIRT? [message #57431 is a reply to message #57305] |
Wed, 13 July 2005 09:32   |
Eclipse User |
|
|
|
Originally posted by: none.none.com
Hi Alan,
The way to do this is to create a list, bind it to your dataset. Then inside
the list, create a single-cell grid, resize it so you can have several of
them on the same line (in your example 2) and set its Section/Display
property to Inline. The grid should not be bound to the dataset, since it
will use the dataset of the list.
I am attaching a sample report demonstrating this kind of mailing labels
reports with the sample database. I created it with BIRT 1.0
Thanks,
David
"Alan" <Alan@urdd.org> wrote in message
news:db2i4q$j1h$1@news.eclipse.org...
> Hi there, I'm new to new to BIRT and Eclipse. My company is trying to
> move away from an ms access based system to a more web based one.
>
> BIRT seems to be a great way of doing the reporting side which we do
> rely on.
>
> One thing we need to be able to do is to create mailing labels with
> addresses lifted from the database.
>
> What I'm trying to do is have a two column layout for the labels, going:
>
> 1 | 2
>
> 3 | 4
>
> etc
>
> I've tried putting two tables in a two column grid, but then I get
>
> 1 | 1
>
> 2 | 2
>
> What's the best way of laying out the report to get labels in the order
> I want?
>
> If this can be accomplished with BIRT, then it would be fantastic. We
> are slowly replacing access forms with asp front ends, and if we can use
> BIRT for reports and mailing labels is would be a great help.
>
> I would be grateful for any suggestions you may have.
|
|
|
| Re: Mailing Labels with BIRT? [message #57560 is a reply to message #57431] |
Wed, 13 July 2005 13:47 |
 Alan Rhys Evans
Messages: 5
Registered: July 2009 |
Junior Member |
|
|
Thanks for your help
That seems to have don the trick.
The only problems I have now is that while it looks fine in the preview,
it dose not look the same in the viewer - I'm getting 4 columns, and
when I generate a PDF it reverts to being one column again.
Also, there are some fields in my database that can be blank e.g. village
when i do
row["Village"] + ", " + row["Town"]
in some cases I'm getting
null, Manchester
Is there any way of removing the nulls?
Any help with these 2 issues would be appreciated
David Michonneau wrote:
> Hi Alan,
>
> The way to do this is to create a list, bind it to your dataset. Then inside
> the list, create a single-cell grid, resize it so you can have several of
> them on the same line (in your example 2) and set its Section/Display
> property to Inline. The grid should not be bound to the dataset, since it
> will use the dataset of the list.
>
> I am attaching a sample report demonstrating this kind of mailing labels
> reports with the sample database. I created it with BIRT 1.0
>
> Thanks,
>
> David
>
> "Alan" <Alan@urdd.org> wrote in message
> news:db2i4q$j1h$1@news.eclipse.org...
>
>>Hi there, I'm new to new to BIRT and Eclipse. My company is trying to
>>move away from an ms access based system to a more web based one.
>>
>>BIRT seems to be a great way of doing the reporting side which we do
>>rely on.
>>
>>One thing we need to be able to do is to create mailing labels with
>>addresses lifted from the database.
>>
>>What I'm trying to do is have a two column layout for the labels, going:
>>
>>1 | 2
>>
>>3 | 4
>>
>>etc
>>
>>I've tried putting two tables in a two column grid, but then I get
>>
>>1 | 1
>>
>>2 | 2
>>
>>What's the best way of laying out the report to get labels in the order
>>I want?
>>
>>If this can be accomplished with BIRT, then it would be fantastic. We
>>are slowly replacing access forms with asp front ends, and if we can use
>>BIRT for reports and mailing labels is would be a great help.
>>
>>I would be grateful for any suggestions you may have.
>
>
>
|
|
|
| Re: Mailing Labels with BIRT? [message #57610 is a reply to message #57560] |
Wed, 13 July 2005 14:07 |
| Eclipse User |
|
|
|
Originally posted by: none.none.com
Alan,
For the PDF issue please file a bugzilla entry describing the issue, so we
can fix it.
For the viewer issue, the number of columns depend on the size of the
viewer. The preview uses the same size you mention in the masterpage (by
default US Letter). So if you try to print on US letter paper, you should
get the number of columns you saw in the preview.
Regarding the null values, you can change your expression like this:
if (row["Village"] == null )
{
row["Town"]
}
else
{
row["Village"] + ", " +row["Town"]
}
Thanks,
David
"Alan" <Alan@urdd.org> wrote in message
news:db361s$d4k$1@news.eclipse.org...
> Thanks for your help
>
> That seems to have don the trick.
> The only problems I have now is that while it looks fine in the preview,
> it dose not look the same in the viewer - I'm getting 4 columns, and when
> I generate a PDF it reverts to being one column again.
>
> Also, there are some fields in my database that can be blank e.g. village
>
> when i do
>
> row["Village"] + ", " + row["Town"]
>
> in some cases I'm getting
>
> null, Manchester
>
> Is there any way of removing the nulls?
>
> Any help with these 2 issues would be appreciated
>
> David Michonneau wrote:
>> Hi Alan,
>>
>> The way to do this is to create a list, bind it to your dataset. Then
>> inside the list, create a single-cell grid, resize it so you can have
>> several of them on the same line (in your example 2) and set its
>> Section/Display property to Inline. The grid should not be bound to the
>> dataset, since it will use the dataset of the list.
>>
>> I am attaching a sample report demonstrating this kind of mailing labels
>> reports with the sample database. I created it with BIRT 1.0
>>
>> Thanks,
>>
>> David
>>
>> "Alan" <Alan@urdd.org> wrote in message
>> news:db2i4q$j1h$1@news.eclipse.org...
>>
>>>Hi there, I'm new to new to BIRT and Eclipse. My company is trying to
>>>move away from an ms access based system to a more web based one.
>>>
>>>BIRT seems to be a great way of doing the reporting side which we do
>>>rely on.
>>>
>>>One thing we need to be able to do is to create mailing labels with
>>>addresses lifted from the database.
>>>
>>>What I'm trying to do is have a two column layout for the labels, going:
>>>
>>>1 | 2
>>>
>>>3 | 4
>>>
>>>etc
>>>
>>>I've tried putting two tables in a two column grid, but then I get
>>>
>>>1 | 1
>>>
>>>2 | 2
>>>
>>>What's the best way of laying out the report to get labels in the order
>>>I want?
>>>
>>>If this can be accomplished with BIRT, then it would be fantastic. We
>>>are slowly replacing access forms with asp front ends, and if we can use
>>>BIRT for reports and mailing labels is would be a great help.
>>>
>>>I would be grateful for any suggestions you may have.
>>
>>
|
|
|
| Re: Mailing Labels with BIRT? [message #58770 is a reply to message #57610] |
Fri, 15 July 2005 08:02 |
Alan Rhys Evans
Messages: 5
Registered: July 2009 |
Junior Member |
|
|
I filed a bug report on the PDF formatting problems, the reply was as
follows
------- FOP does not support "fo:inline-container" so that we are not
able to make a table/grid inline. Postpone this bug to BIRT 2.0 in which
we will create a PDF writer of our own.
Is there another way I can lay out labels, that the PDF exporter will
support?
Any suggestions would be appreciated
Thanks
David Michonneau wrote:
> Alan,
>
> For the PDF issue please file a bugzilla entry describing the issue, so we
> can fix it.
> For the viewer issue, the number of columns depend on the size of the
> viewer. The preview uses the same size you mention in the masterpage (by
> default US Letter). So if you try to print on US letter paper, you should
> get the number of columns you saw in the preview.
>
> Regarding the null values, you can change your expression like this:
> if (row["Village"] == null )
>
> {
>
> row["Town"]
>
> }
>
> else
>
> {
>
> row["Village"] + ", " +row["Town"]
>
> }
>
> Thanks,
>
> David
>
> "Alan" <Alan@urdd.org> wrote in message
> news:db361s$d4k$1@news.eclipse.org...
>
>>Thanks for your help
>>
>>That seems to have don the trick.
>>The only problems I have now is that while it looks fine in the preview,
>>it dose not look the same in the viewer - I'm getting 4 columns, and when
>>I generate a PDF it reverts to being one column again.
>>
>>Also, there are some fields in my database that can be blank e.g. village
>>
>>when i do
>>
>>row["Village"] + ", " + row["Town"]
>>
>>in some cases I'm getting
>>
>>null, Manchester
>>
>>Is there any way of removing the nulls?
>>
>>Any help with these 2 issues would be appreciated
>>
>>David Michonneau wrote:
>>
>>>Hi Alan,
>>>
>>>The way to do this is to create a list, bind it to your dataset. Then
>>>inside the list, create a single-cell grid, resize it so you can have
>>>several of them on the same line (in your example 2) and set its
>>>Section/Display property to Inline. The grid should not be bound to the
>>>dataset, since it will use the dataset of the list.
>>>
>>>I am attaching a sample report demonstrating this kind of mailing labels
>>>reports with the sample database. I created it with BIRT 1.0
>>>
>>>Thanks,
>>>
>>>David
>>>
>>>"Alan" <Alan@urdd.org> wrote in message
>>>news:db2i4q$j1h$1@news.eclipse.org...
>>>
>>>
>>>>Hi there, I'm new to new to BIRT and Eclipse. My company is trying to
>>>>move away from an ms access based system to a more web based one.
>>>>
>>>>BIRT seems to be a great way of doing the reporting side which we do
>>>>rely on.
>>>>
>>>>One thing we need to be able to do is to create mailing labels with
>>>>addresses lifted from the database.
>>>>
>>>>What I'm trying to do is have a two column layout for the labels, going:
>>>>
>>>>1 | 2
>>>>
>>>>3 | 4
>>>>
>>>>etc
>>>>
>>>>I've tried putting two tables in a two column grid, but then I get
>>>>
>>>>1 | 1
>>>>
>>>>2 | 2
>>>>
>>>>What's the best way of laying out the report to get labels in the order
>>>>I want?
>>>>
>>>>If this can be accomplished with BIRT, then it would be fantastic. We
>>>>are slowly replacing access forms with asp front ends, and if we can use
>>>>BIRT for reports and mailing labels is would be a great help.
>>>>
>>>>I would be grateful for any suggestions you may have.
>>>
>>>
>
|
|
|
| Re: Mailing Labels with BIRT? [message #59144 is a reply to message #58770] |
Fri, 15 July 2005 16:04 |
David Michonneau
Messages: 1145
Registered: July 2009 |
Senior Member |
|
|
Alan,
Thank you for submitting this bug. I suggest you input your comments
directly in the bugzilla entry.
Unfortunately I don't know any workaround to lay out the labels this way in
PDF.
Thanks,
David
"Alan" <Alan@urdd.org> wrote in message
news:db7qim$iaq$1@news.eclipse.org...
>I filed a bug report on the PDF formatting problems, the reply was as
>follows
>
> ------- FOP does not support "fo:inline-container" so that we are not able
> to make a table/grid inline. Postpone this bug to BIRT 2.0 in which we
> will create a PDF writer of our own.
>
> Is there another way I can lay out labels, that the PDF exporter will
> support?
>
> Any suggestions would be appreciated
>
> Thanks
>
>
> David Michonneau wrote:
>> Alan,
>>
>> For the PDF issue please file a bugzilla entry describing the issue, so
>> we can fix it.
>> For the viewer issue, the number of columns depend on the size of the
>> viewer. The preview uses the same size you mention in the masterpage (by
>> default US Letter). So if you try to print on US letter paper, you should
>> get the number of columns you saw in the preview.
>>
>> Regarding the null values, you can change your expression like this:
>> if (row["Village"] == null )
>>
>> {
>>
>> row["Town"]
>>
>> }
>>
>> else
>>
>> {
>>
>> row["Village"] + ", " +row["Town"]
>>
>> }
>>
>> Thanks,
>>
>> David
>>
>> "Alan" <Alan@urdd.org> wrote in message
>> news:db361s$d4k$1@news.eclipse.org...
>>
>>>Thanks for your help
>>>
>>>That seems to have don the trick.
>>>The only problems I have now is that while it looks fine in the preview,
>>>it dose not look the same in the viewer - I'm getting 4 columns, and when
>>>I generate a PDF it reverts to being one column again.
>>>
>>>Also, there are some fields in my database that can be blank e.g. village
>>>
>>>when i do
>>>
>>>row["Village"] + ", " + row["Town"]
>>>
>>>in some cases I'm getting
>>>
>>>null, Manchester
>>>
>>>Is there any way of removing the nulls?
>>>
>>>Any help with these 2 issues would be appreciated
>>>
>>>David Michonneau wrote:
>>>
>>>>Hi Alan,
>>>>
>>>>The way to do this is to create a list, bind it to your dataset. Then
>>>>inside the list, create a single-cell grid, resize it so you can have
>>>>several of them on the same line (in your example 2) and set its
>>>>Section/Display property to Inline. The grid should not be bound to the
>>>>dataset, since it will use the dataset of the list.
>>>>
>>>>I am attaching a sample report demonstrating this kind of mailing labels
>>>>reports with the sample database. I created it with BIRT 1.0
>>>>
>>>>Thanks,
>>>>
>>>>David
>>>>
>>>>"Alan" <Alan@urdd.org> wrote in message
>>>>news:db2i4q$j1h$1@news.eclipse.org...
>>>>
>>>>
>>>>>Hi there, I'm new to new to BIRT and Eclipse. My company is trying to
>>>>>move away from an ms access based system to a more web based one.
>>>>>
>>>>>BIRT seems to be a great way of doing the reporting side which we do
>>>>>rely on.
>>>>>
>>>>>One thing we need to be able to do is to create mailing labels with
>>>>>addresses lifted from the database.
>>>>>
>>>>>What I'm trying to do is have a two column layout for the labels,
>>>>>going:
>>>>>
>>>>>1 | 2
>>>>>
>>>>>3 | 4
>>>>>
>>>>>etc
>>>>>
>>>>>I've tried putting two tables in a two column grid, but then I get
>>>>>
>>>>>1 | 1
>>>>>
>>>>>2 | 2
>>>>>
>>>>>What's the best way of laying out the report to get labels in the order
>>>>>I want?
>>>>>
>>>>>If this can be accomplished with BIRT, then it would be fantastic. We
>>>>>are slowly replacing access forms with asp front ends, and if we can
>>>>>use
>>>>>BIRT for reports and mailing labels is would be a great help.
>>>>>
>>>>>I would be grateful for any suggestions you may have.
>>>>
>>>>
>>
|
|
|
Goto Forum:
Current Time: Wed Sep 18 17:32:16 GMT 2024
Powered by FUDForum. Page generated in 0.04383 seconds |
] 
Search
Help
Register
Login
Home
