Open Access Reports from ASP.NET

[gslick]

Hi,

Does anyone know how to open a Microsoft Access report from ASP.NET ?

Thanks

Gslick

 

[Isadore]

gslick: I have never seen a reference to this; although I have read an article some time ago in which Access queries can be used as "Stored Procedures" - perhaps this might provide a a work around -- I do not think that dot NET would allow this - but I can say that I have never seen a reference to this being done. You can however put together a very nice report in dot NET, that is equally as nice looking and equally (actually more so) functional.

Do a search on the web and see what you come up with. I cannot remember this technique being discussed here at Tek-Tips (indeed, haven't seen this technique mentioned at all anywhere) -- of course, that doesn't mean its not possible.

Perhaps another can add their 2 cents here -- this is just my observation.

 

[gslick]

Thanks for your reply.

Are you talking about using Crystal Reports in .NET ?

If I used this technique, could I have a hyperlink that once pressed would run a report using crystal ?

Thanks

Gslick

 

[Isadore]

gs: What I was referring to was an article I read some time back in which Access Queries were successfully used on a dot NET project as "Stored Procedures", sort of like compiled dll files in which the internal SQL is executed.

If you are going to be doing a lot of Reports Crystal Reports may just be the ticket - it comes with Visual Studio and/or you can purchase it separately. Crystal Reports can be fairly easily integrated into the dot NET platform and you can drill data tables, etc..

However, its something else to learn; I suppose if it were only a report or two I might just custom design my own in a web form -- but Crystal Reports of course is much more elaborate in it's abilities -- a choice I suppose you would have to make.

Do a general serach on the web for Crystal Reports for dot NET and see if that is what you are looking for. Crystal Reports have been discussed here at Tek-Tips from time to time and you might persuse the "Search" capabilites of this forum and see what you can dig up -- it is not however a primary target of discussion here as it is, on its own, an individual platform (so truely integrated to used with dot NET).

 

[Ecreations]

this tutorial is for asp not asp.net but if its done in asp it should be done in asp.net

http://www.4guysfromrolla.com/webtech/042600-1.shtml

i think Crystal Reports is a better option

good luck


The solution is simple, the problem is complex.

http://www.ecreationscanada.com

 

[Isadore]

Ecreations: thanks, that's the first time I've seen a reference to opening Access reports in asp, and I agree, you should be able to do it dot NET -- but in the long run Crystal Reports would no doubt be the better option in dot NET.