?
Solved

importing Ms Access reports in VB.net ??

Posted on 2005-04-05
6
Medium Priority
?
189 Views
Last Modified: 2010-04-23
Hi there ...
i've been developing client server applications in VB6 and crystal reports.Now i am suppose to work on a VB.NET application.I am totally fresh in this .Net area.I need to know that say if i have an application whose both front end and backend is in MS Access and all reports are also made in MS Access.Can i import those reports in VB.net with minimum amount of re-work or is there any other way  that i can take all existing Access reports and convert them into VB. .Net
using Crystal Reports.

thanks
-Ade
0
Comment
Question by:wtf666
  • 3
  • 3
6 Comments
 
LVL 71

Accepted Solution

by:
Éric Moreau earned 120 total points
ID: 13713192
Using only VS.Net 2003, you cannot. Not even using Crystal Reports. The only thing I know is that Active Reports can import them: http://www.datadynamics.com/Products/ProductOverview.aspx?Product=ARNET1

You could also keep your reports in Access.
0
 

Author Comment

by:wtf666
ID: 13727100
empreau , thats fine to keep the access report but can i call them from my VB.net application .. any idea ?
thanks
0
 

Author Comment

by:wtf666
ID: 13727638
also do i have to purchase ActiveReports ?? i mean on the link which u gave above requirs high license fee ... cr installes with .net , ActiveReports  dont come with .net or they do ?
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
LVL 71

Expert Comment

by:Éric Moreau
ID: 13727887
>>thats fine to keep the access report but can i call them from my VB.net application

To use Access reports from VB.Net, see http://support.microsoft.com/kb/317113/EN-US/#5
Every user will need to have Access on their computer.

>>also do i have to purchase ActiveReports

Yes. It is a competitor to CR. CR has special agreements witn Microsoft to include a light version of their product into VS.Net. CR also has a more complete version.
0
 

Author Comment

by:wtf666
ID: 13728493
hmmm ic , i have worked in cr9/10 with visual basic6. i installed them seperately from their full version cd and thus it was automaticallty added in the vb6 IDE.

Does this lite model of CR which is built in .Net studio enough for development needs or i can install the CR9 or 10 from full version cd and still be able to use them from .Net iDE  ..

actually i am very new to .net thats why i don't know the basic changings from vb6 to .net development / report writing etc

thanks
0
 
LVL 71

Expert Comment

by:Éric Moreau
ID: 13729114
You have a designer built-in VS.Net. Add a new report file (you should see it when you are adding a new file) and the designer will appear.

You can still continue to work with cr9/10 if you wish.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Jorge
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…
The video provides a quick and easy steps to migrate MBOX file to well known Outlook PST and Office 365. Besides this, it also supports and migrates more than 20 email clients of MBOX which include AppleMail, Opera, Thunderbird and SeaMonkey effortl…

599 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question