UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Displaying An SSRS Chart In Ms Access, Any Versions    
 
   
ordnance1
post Nov 20 2019, 09:22 PM
Post#1



Posts: 714
Joined: 7-May 11



I had a couple of data points that I wanted to chart in a multi-user db, that uses SQL Server as it's back-end .The charting in Access is so limited I have downloaded and installed Microsoft Report Server and Report Builder. I was able to create the charts I wanted and save to the server, but have no idea how I can display them in Access. Not even sure if it is possible.
Go to the top of the page
 
WildBird
post Nov 20 2019, 09:42 PM
Post#2


UtterAccess VIP
Posts: 3,696
Joined: 19-August 03
From: Auckland, Little Australia


I have found easiest is to export to Excel and use its charting, it is a lot more powerful than what Access and SSRS can do, and end users are generally happy to be able to use it in Excel as well.

--------------------
Beer, natures brain defragging tool.
Go to the top of the page
 
jleach
post Nov 21 2019, 07:41 AM
Post#3


UtterAccess Administrator
Posts: 10,399
Joined: 7-December 09
From: St. Augustine, FL


What file format are the charts you've saved from SSRS?

--------------------
Jack D. Leach
Founder & CEO
Dymeng Services Inc.
Business Software Solutions
Go to the top of the page
 
PhilS
post Nov 21 2019, 09:21 AM
Post#4



Posts: 673
Joined: 26-May 15
From: The middle of Germany


QUOTE
I was able to create the charts I wanted and save to the server, but have no idea how I can display them in Access.

I can't give a definitive answer due to lack of experience.
However, two things to look into:
1.) There is an ActiveX-Control for SSRS-Reports. You could embed that control on a Access form to display your report.
2.) Newer versions of SSRS (2016 onward) should be able to render all reports to HTML. You could use a Webbrowser-Control to display the HTML report on a form.


--------------------
A professional Access developer tool: Find and Replace for Access and VBA
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    27th January 2020 - 04:45 AM