Solved

Opening an Access report in ReportViewer

Posted on 2007-12-04
9
776 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
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
 

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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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 500 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help with LINQ and XML 10 27
Help with Syntax 9 28
Export Query data to excel file 14 36
Find missing numbers in Access Table PrimaryKey 9 12
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

895 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now