Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-02-2014, 11:04 AM   #1
keen1598
Newly Registered User
 
Join Date: Nov 2014
Posts: 13
Thanks: 7
Thanked 0 Times in 0 Posts
keen1598 is on a distinguished road
Calling and RDL file to generate reports from Access

So Access was unable to manage the amount of content that I needed to produce in a single report. The reports contain 12 charts/graphs all of which I needed on separate pages (one chart per page). As such I could not create large enough charts in access to fit to each page, as Access limits the amount of space one can use in a report.

I downloaded Microsoft Reports Builder 3.0 and built my reports as needed and can generate them as desired at current. I'm wondering if there a way to call that RDL file I created to generate my reports from a form control button in Access?

keen1598 is offline   Reply With Quote
Old 12-02-2014, 11:09 AM   #2
BlueIshDan
 
Join Date: May 2014
Posts: 1,122
Thanks: 155
Thanked 160 Times in 156 Posts
BlueIshDan is on a distinguished road
Re: Calling and RDL file to generate reports from Access

To execute the RDL file or to print a report with your Access Database's data. I'm not exactly familiar with RDL files yet.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Blue's Age Poll:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Animated Sorting:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Mining File Directories:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GetSubFolders:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

GetFileLines:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

FindSimilarValues:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Move (Avoid moving objects game):
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
BlueIshDan is offline   Reply With Quote
Old 12-02-2014, 11:28 AM   #3
smig
Newly Registered User
 
Join Date: Nov 2009
Location: Israel
Posts: 1,960
Thanks: 60
Thanked 131 Times in 122 Posts
smig is on a distinguished road
Create each chart as a sub report and put a page break after each sub report.

I have a report wirh almost 20 sub reports, including charts.

smig is offline   Reply With Quote
Old 12-04-2014, 07:49 AM   #4
keen1598
Newly Registered User
 
Join Date: Nov 2014
Posts: 13
Thanks: 7
Thanked 0 Times in 0 Posts
keen1598 is on a distinguished road
Re: Calling and RDL file to generate reports from Access

Seriously? No one knows how to write and interface/subroutine to activate an RDL reports package? I figured this was pretty simple since its just a SQL Report Generator...

keen1598 is offline   Reply With Quote
Reply

Tags
access , control , rdl , reports

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2003 Runtime will not generate reports msrichards Reports 6 08-21-2009 02:44 PM
SQL to generate Reports Peter Bellamy Modules & VBA 2 01-10-2008 06:24 AM
Calling Access Reports From VB SJM1982 Reports 1 02-23-2004 01:38 PM
VB to generate Access Reports yippie_ky_yay Modules & VBA 4 11-05-2002 01:28 PM
[SOLVED] Cannot Generate Any Reports.... NickSmith Reports 2 07-26-2000 12:14 AM




All times are GMT -8. The time now is 06:32 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World