?
Solved

importing Ms Access reports in VB.net ??

Posted on 2005-04-05
6
Medium Priority
?
185 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 70

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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 70

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 70

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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying 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

Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses
Course of the Month12 days, 15 hours left to enroll

777 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