Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Opening an Access report in ReportViewer

Posted on 2007-12-04
9
Medium Priority
?
796 Views
Last Modified: 2013-11-28
Hi All,

I have a number of reports created in a Microsoft Access database. Is it possible to open them using a ReportViewer control in VB.Net so the user can view the reports without opening Access?

Many Thanks
0
Comment
Question by:kiranboi
[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
9 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 20403458
Based on this thread it would appear so.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=176302&SiteID=1

I don't know any more than that.
0
 
LVL 13

Expert Comment

by:wiswalld
ID: 20404316
Do you mean without access opening at all or without having to open access first and view the report from access?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 20408834
kiranboi,

Since Access Reports live inside the DB, you have to "Open Access" in one way or another.
(With code, opening a hidden instance of Access)

Even using a Report shortcut on the desktop requires Access to be opened.

Some options:


You could:
Save the Report to the Snapshot format:
-Access needn't be open.
-It will be static a static report.
-Users will still need Office to view it.

Or, save the Report as HTML
Again, it will only be static.
But users only need a web browser to view it.

Or (If this is even an option), go outside of Access and use Crystal Reports.
Duplicate the Report with Crystal. Then either open the Crystal Report, (which will be linked to the Access data), or use a Crystal Reports "Viewer".
In either case the Report will be "Live".

Hope this helps.
0
Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

 

Author Comment

by:kiranboi
ID: 20410652
boag2000, thanx for the comments. I am having a look at the Crystal Reports option.
Is there a way of letting my users create a custom Crystal Report at runtime like they can do with Access?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 20413124
kiranboi,

You don't have to go the Crystal Report route just yet.
The catch here is that the users will have to now "Learn" CR, and how it differs from Access.
You can wait to see if another expert can provide another alternative.

<create a custom Crystal Report at runtime like they can do with Access>
If by "Runtime" you mean while Access is open, then yes.
They can create or modify a Crystal Report anytime they like. As long as CR can connect to the Database.
Think of CR as a similar report engine to what is *in* Access, but it is actually *outside* of Access.
It basically Links into the Access Data to get its source.

There is also a "Refresh" feature in CR where users can refresh the data to see any recent updates.

But just like anything else, If they are trying to create/Modify a Report from Access and the Access source can change or be deleted, then they have to be aware of that.
If you ever move or Rename the DB (or any other object the Report needs from Access), Crystal might be confused.
:O
You will have to use the "Set Location" option to repair the reference.

JeffCoachman
0
 

Author Comment

by:kiranboi
ID: 20418383
Thanks for that :)

One last, quick question. If using the report creator in Access obviously Access needs to be open and the user can then create, edit and view reports using Access. With Crystal Reports can the facility to create, edit and view reports be integrated into my VB .Net application so the user isnt using a seperate application for reporting?
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 20421487
0
 

Author Comment

by:kiranboi
ID: 20426218
Perfect, thats exactly what i needed. Thanks!!
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 20426275
;)
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

722 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