Access Report from the Web
in [Reports]
|
From: יריב החביב on 13 Apr 2010 09:57 Hello, We have few Access reports on a form, that we would like to run from the web (sherpoint) is it posible ? if not, what can be as alternative ? thank you, -- תודה רבה
From: Mark Andrews on 13 Apr 2010 14:55 In general not a good idea unless you approach it like I do with this product. http://www.rptsoftware.com/products/reportserver/ It basically runs one instance of Access on the server and uses a COM component and lots of error checking to handle the report requests. Note: the product hasn't been updated to work with access 2007 or 2010 (you would need to tweak source code). Low end reporting tools include: - this product to run access reports - active reports - crystal reports (if they still have a low end version)? - probably a few others High end products - sql server reporting services - business objects - cognos - oracle reports - many others If you have the budget make the plunge to reporting services. low end I would go with report server or active reports. If there are not too many report parameters or if batch reporting worked as a solution you could crank out a bunch of reports as pdf files and then get them on your sharepoint site. There are some listview controls that can pull data from many sharepoint lists and do something close to reporting (another approach). Just my opinion, Been doing access based web reporting for about 10 years now, Mark "יריב החביב" <yarivr(a)tasmc.health.gov.il> wrote in message news:AB6D0028-D161-4E09-BBCA-7F5A034122F5(a)microsoft.com... > Hello, > > We have few Access reports on a form, > > that we would like to run from the web (sherpoint) > > is it posible ? > > if not, what can be as alternative ? > > thank you, > > > -- > תודה רבה
From: יריב החביב on 14 Apr 2010 03:57 Thank You !!! -- תודה רבה "Mark Andrews" wrote: > In general not a good idea unless you approach it like I do with this > product. > http://www.rptsoftware.com/products/reportserver/ > > It basically runs one instance of Access on the server and uses a COM > component and lots of error checking to > handle the report requests. Note: the product hasn't been updated to work > with access 2007 or 2010 (you would need to tweak source code). > > Low end reporting tools include: > - this product to run access reports > - active reports > - crystal reports (if they still have a low end version)? > - probably a few others > > High end products > - sql server reporting services > - business objects > - cognos > - oracle reports > - many others > > If you have the budget make the plunge to reporting services. > > low end I would go with report server or active reports. > > If there are not too many report parameters or if batch reporting worked as > a solution you could crank out a bunch of reports as pdf files and then get > them on your sharepoint site. > > There are some listview controls that can pull data from many sharepoint > lists and do something close to reporting (another approach). > > Just my opinion, > Been doing access based web reporting for about 10 years now, > Mark > > "יריב החביב" <yarivr(a)tasmc.health.gov.il> wrote in message > news:AB6D0028-D161-4E09-BBCA-7F5A034122F5(a)microsoft.com... > > Hello, > > > > We have few Access reports on a form, > > > > that we would like to run from the web (sherpoint) > > > > is it posible ? > > > > if not, what can be as alternative ? > > > > thank you, > > > > > > -- > > תודה רבה > > . >
|
Pages: 1 Prev: Print Report without openning it / Fast printing Next: PDF and Access 2007 |