i have to print report in access using asp

this report has for source a query which requires an input parameter

if i use the Adodb.Command object from asp and send the parameter to the 
stored procedure ( the query) every thing is fine ...i guess the query is 
opened in access ...i said i guess cause i can't see it..but this doesn't 
bother me

the stored procedure (the query) is the only thing Command can open
i don't need a stored procedure

i need to open a report and print it


i guess if i could call from asp a macro ( open query with that input 
parameter, open report based by the opened query, print that report) it 
would be ok

but how?

or maybe is there a posibility to create an event...an OnOpen event for 
the query so that when it opens (thing that i've seen it works) it should 
open the report and print it

i don't see any solution

When you are referencing an OLEDB database (Access) using ADO,
that is NOT the same as executing Access.  Access, the program,
is NOT running on the server.  Therefore, you can't execute a
report that you have defined within the Access database.

Larry Woods


> -----Original Message-----
> From: dtudose@y... [mailto:dtudose@y...]
> Sent: Monday, November 04, 2002 5:47 PM
> To: Access ASP
> Subject: [access_asp] print report in access using asp
>
>
> i have to print report in access using asp
>
> this report has for source a query which requires an
> input parameter
>
> if i use the Adodb.Command object from asp and send
> the parameter to the
> stored procedure ( the query) every thing is fine ...i
> guess the query is
> opened in access ...i said i guess cause i can't see
> it..but this doesn't
> bother me
>
> the stored procedure (the query) is the only thing
> Command can open
> i don't need a stored procedure
>
> i need to open a report and print it
>
>
> i guess if i could call from asp a macro ( open query
> with that input
> parameter, open report based by the opened query,
> print that report) it
> would be ok
>
> but how?
>
> or maybe is there a posibility to create an event...an
> OnOpen event for
> the query so that when it opens (thing that i've seen
> it works) it should
> open the report and print it
>
> i don't see any solution
>
>

> i have to print report in access using asp

> this report has for source a query which requires an input parameter

> if i use the Adodb.Command object from asp and send the parameter to the 
s> tored procedure ( the query) every thing is fine ...i guess the query 
is 
o> pened in access ...i said i guess cause i can't see it..but this 
doesn't 
b> other me

> the stored procedure (the query) is the only thing Command can open
i>  don't need a stored procedure

> i need to open a report and print it

> 
i>  guess if i could call from asp a macro ( open query with that input 
p> arameter, open report based by the opened query, print that report) it 
w> ould be ok

> but how?

> or maybe is there a posibility to create an event...an OnOpen event for 
t> he query so that when it opens (thing that i've seen it works) it 
should 
o> pen the report and print it

> i don't see any solution

> 

i know that
i just want to find a way to 
- either grad the data clasicaly by recordsets, form a table and print it 
from IE
-or print it from access directly

but i want it done automaticaly when the user clicks a button on my asp 
page

i know there is a method for the window object but it's only for Navigator
and i am IE dependent
furthermore the page is printed with a footer which containes the number 
of the page...i guess i could eliminate the footer setting the page but 
this is not an automate printing
i don't want the user to sweat to much :))

Hmmmmm.

You could always generate an HTML equivalent of the report on
YOUR computer, then upload the HTML file to your server.  This,
of course, would create a STATIC report.  The user could then
open it from there.  As far as creating a table, you could always
do that in an ASP script, but there is no AUTOMATIC way of doing
that.  You would have to write the code.

Again, sorry if I am "beating a dead horse", but your comment
about "...print it from access directly" implies that you are
still thinking that Access is running on the server--which it
isn't.

Larry Woods


> -----Original Message-----
> From: dtudose@y... [mailto:dtudose@y...]
> Sent: Tuesday, November 05, 2002 11:18 AM
> To: Access ASP
> Subject: [access_asp] Re: print report in access using asp
>
>
> i know that
> i just want to find a way to
> - either grad the data clasicaly by recordsets, form a
> table and print it
> from IE
> -or print it from access directly
>
> but i want it done automaticaly when the user clicks a
> button on my asp
> page
>
> i know there is a method for the window object but
> it's only for Navigator
> and i am IE dependent
> furthermore the page is printed with a footer which
> containes the number
> of the page...i guess i could eliminate the footer
> setting the page but
> this is not an automate printing
> i don't want the user to sweat to much :))
>