Solved

Opening an Access report in ReportViewer

Posted on 2007-12-04
9
790 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
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 

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

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
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.
Suggested Courses

617 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