Solved

Opening an Access report in ReportViewer

Posted on 2007-12-04
9
774 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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

706 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

18 Experts available now in Live!

Get 1:1 Help Now