DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Running an Access Report dynamically from ASP

  1. #1
    Randy Guest

    Running an Access Report dynamically from ASP


    I wanted to find out if there is a way to call an Access created report from
    an ASP page.

    Here is what I see doing:
    1. The user selects the name of the report you want to run and the parameters
    for the report; lets say a date range.

    2. Connecting to the Access DB and passing the report name along with the
    filters/sort.

    3 Displaying the report in the browser (If possible?)

    I know there are other options/products that will allow for on-line reporting
    like I described. But I want to make sure we can't handle this with the
    tools we already have. I am going to continue my research to see if I can
    dig up anything. If I find anything I will follow up.

    Thanks in Advance for any help or suggestions!

  2. #2
    Harish Mohanbabu Guest

    Re: Running an Access Report dynamically from ASP


    Randy,

    See whether these links helps -

    http://support.microsoft.com/default...;EN-US;q259805
    http://www.4guysfromrolla.com/webtech/042600-1.shtml

    Harish M.

    "Randy" <rwells@vodavi-ct.com> wrote:
    >
    >I wanted to find out if there is a way to call an Access created report

    from
    >an ASP page.
    >
    >Here is what I see doing:
    >1. The user selects the name of the report you want to run and the parameters
    >for the report; lets say a date range.
    >
    >2. Connecting to the Access DB and passing the report name along with the
    >filters/sort.
    >
    >3 Displaying the report in the browser (If possible?)
    >
    >I know there are other options/products that will allow for on-line reporting
    >like I described. But I want to make sure we can't handle this with the
    >tools we already have. I am going to continue my research to see if I can
    >dig up anything. If I find anything I will follow up.
    >
    >Thanks in Advance for any help or suggestions!



  3. #3
    Randy Guest

    Re: Running an Access Report dynamically from ASP


    Thanks Harish.

    The 4guyfromrolla link does have some useful information in it(since we are
    concerned with dynamic/no static reports).

    Not sure that we are going to use the 4guysfromrolla method because, from
    what i have read so far, we would need to have access installed on each server
    (this is for a product which will be installed in a lot of different locations
    and each will need to run its own reports from their local web-server).
    It looks like we may go the ActiveReports2 route so we can distribute a royality-free
    run-time to create the reports dynamically at each location.


    "Harish Mohanbabu" <HarishM@MailCity.Com> wrote:
    >
    >Randy,
    >
    >See whether these links helps -
    >
    >http://support.microsoft.com/default...;EN-US;q259805
    >http://www.4guysfromrolla.com/webtech/042600-1.shtml
    >
    >Harish M.
    >
    >"Randy" <rwells@vodavi-ct.com> wrote:
    >>
    >>I wanted to find out if there is a way to call an Access created report

    >from
    >>an ASP page.
    >>
    >>Here is what I see doing:
    >>1. The user selects the name of the report you want to run and the parameters
    >>for the report; lets say a date range.
    >>
    >>2. Connecting to the Access DB and passing the report name along with

    the
    >>filters/sort.
    >>
    >>3 Displaying the report in the browser (If possible?)
    >>
    >>I know there are other options/products that will allow for on-line reporting
    >>like I described. But I want to make sure we can't handle this with the
    >>tools we already have. I am going to continue my research to see if I

    can
    >>dig up anything. If I find anything I will follow up.
    >>
    >>Thanks in Advance for any help or suggestions!

    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center