Print labels - Best option between using access reports or HTML templates

Hi all,

I'm trying to generate labels to print in several different formats,
all of them with their own height,width and page margins. We've got
this done in MS Access 2000, using a designed report that fits with
each label type, and reads a table dinamically generated. But the
problem is page margins. Does Access store page margins and
information of that kind within de report? Is there any kind of
association between printer configuration and reports? For example, I
want to print some labels in A4, that have 0 left/right/top/bottom
margins, but i can't get this done with access, it "forgets" the
margins configuration when I send a data-filled mdb to the client.

The alternative way can be use HTML, by dinamically writing labels in
a formatted ASP and then printing, but I'm afraid the problem still
remains, because I don't know how to say IE (or other navigator) to
print the page respecting the format I'm sending.

Can I configure printing settings if I use ActiveX, embedding a
browser in HTML?

Please, any idea?

re: Print labels - Best option between using access reports or HTML templates

crystal reports supports a wide variety of labels. you can generate a crystal
report and render it to the browser as a pdf file so you can keep the format
when you print it..

hope this helps..

"Luis Serrano" wrote:
[color=blue]
> Hi all,
>
> I'm trying to generate labels to print in several different formats,
> all of them with their own height,width and page margins. We've got
> this done in MS Access 2000, using a designed report that fits with
> each label type, and reads a table dinamically generated. But the
> problem is page margins. Does Access store page margins and
> information of that kind within de report? Is there any kind of
> association between printer configuration and reports? For example, I
> want to print some labels in A4, that have 0 left/right/top/bottom
> margins, but i can't get this done with access, it "forgets" the
> margins configuration when I send a data-filled mdb to the client.
>
> The alternative way can be use HTML, by dinamically writing labels in
> a formatted ASP and then printing, but I'm afraid the problem still
> remains, because I don't know how to say IE (or other navigator) to
> print the page respecting the format I'm sending.
>
> Can I configure printing settings if I use ActiveX, embedding a
> browser in HTML?
>
> Please, any idea?
>[/color]

re: Print labels - Best option between using access reports or HTML templates

Thanks for reply.

By the moment we're not interested in using Cristal Reports, because
licensing it would increase our prices. We're sure our clients have, at
least, Office 2000, so we have to manage with this.

After the post yesterday, I realized MS Word has label assistants, and
it has the type of labels our clients use, so all I've got to do is find
some way to automate the rendering of labels from server and send the
results in a .doc file to client, or write some code in a macro that
reads data from another file. But the first way has a problem... we've
to be sure that Office is installed on server and have rights to
execute/read/write. And the second one needs two files to be sent to the
client, and the idea is send just one, already rendered file.

Some ideas?

Thanks in advance.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!