Embed SSRS Report into PowerPoint Slides | SansSQL

Friday, July 8, 2016

Embed SSRS Report into PowerPoint Slides

Presentations are one major activity in each and everyone's career. There are different ways of presenting your information, some does it just by showing the static data and some wants to do it with the Live data. We are the people who are of type 2, presenting the live data. But when it comes to presenting live data, it is through reports.
How beautiful it will be if we have the option to interact with the Live data from a PowerPoint Presentation?
In this post, we shall learn how to embed SSRS report into PowerPoint Slides.

Before we begin, we need
  1. A Web Viewer add-in for PowerPoint
  2. Report URL to embed in the PowerPoint
Open a PowerPoint Presentation, go to "Insert" Tab and Click on "Store"

Now search for "web viewer" add-in and Click "Add". This is an add-in from Microsoft.

Once you click "Add", this is add the add-in into your slide and it looks like this

Now Insert your SSRS Report Server URL into the URL box and hit "Preview". 
This was my URL https://sql01.sanssql.com/ReportServer/Pages/ReportViewer.aspx?%2fAdventureWorks+Sample+Reports%2fCompany+Sales&rs:Command=Render&rc:Toolbar=False 
And that's it, Now your Slide will Load the data from SSRS Report.

Now you can interact (Drill Down or Drill Through, etc...) with the data depending on the report type. 
If you want to show a static image, then click on the small left arrow on the top right of the add-in and choose "Show as Saved Image" and this is display the data in the image format.

Now your presentations will be more fun with the Live Data.


Unknown said...

Thanks for the info looks great information have been shared elearning voice over

Unknown said...

Useful information, thank you for sharing. I can share templates for powerpoint http://www.poweredtemplate.com/ppt-powerpoint-design-templates.html. Can it be useful to you. I look forward to new and interesting things. Good luck.

Unknown said...

Definitely useful in creating reports for essayrepublic project presentation by student interns.

Unknown said...

Being new to the blogging world I feel like there is still so much to learn. Your tips helped to clarify a few things for me as well as giving..
iOS Training in Chennai
Android Training in Chennai
php Training in Chennai

Unknown said...

Helpful information. Microsoft should support this feature even for 64 bit.

Unknown said...

is the embedded SSRS Report in the slide are can be editable or customizable?

Unknown said...
This comment has been removed by a blog administrator.
Tech Studio said...

free antivirus soft
Craktonia Downloads

Unknown said...

thanks for this such great article!

idle heroes mod apk .
Free call packages .
age of empires cheats 2018
Free apk and mods .
happy new year 2019 images .
asphalt 9 Legends apk .
best orthopedic dog bed 2018 .
watch Bepanah hd drama online 2018

Tech Studio said...

veterans day clipart

Tech Studio said...

why we celebrate makar sankranti

Tech Studio said...


social zone said...

WhatsApp Status Hindi

Tech Studio said...

Bli Meriterad Coach med en kvalitetsutbildning

social zone said...

tours peru

Tech Studio said...

Offert värmepump

Tech Studio said...


mary Brown said...

A IEEE project Domain is an interrelated arrangement of exercises, having a positive beginning and end point and bringing about an interesting result in Engineering Colleges for a particular asset assignment working under a triple limitation - time, cost and execution. Final Year Project Domains for CSE In Engineering Colleges, final year IEEE Project DOmains Management requires the utilization of abilities and information to arrange, plan, plan, direct, control, screen, and assess a final year project domains for cse. The utilization of Project Management to accomplish authoritative objectives has expanded quickly and many engineering colleges have reacted with final year IEEE projects Project Centers in Chennai for CSE to help students in learning these remarkable abilities in their respective domains.

Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining the authors explore the idea of using Java in Big Data platforms.
Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai

Nada Ramahdani said...


JohnSon said...

Rakesh Yadav Class Notes PDF
RS Aggarwal Reasoning PDF
UP Sarkari Naukri

RAJU said...

up ration card

Tech Studio said...

Aiman Online Quran Learning Academy is an impressive online academy for teaching the Quran.
This leading online Quran academy from
Pakistan provides you an excellent chance to have one
to one online Quran classes with tajweed and learn the basic teachings of Islam.

Tech Studio said...

Como desenhar

Tech Studio said...

army job vacancy in india

Hindu Parv said...

Happy Republic day best SMS and Messages in English

Students Guide said...

Thanks for sharing this post
Govt Job

Kumar JI said...

who won the toss today in ipl 2021 thankyu

Unknown said...

Thank you so much for sharing this post, I appreciate your work.It was a great informative post.Go so many useful and informative links.Loved your writings also. Concept of the topic was well discussed. Love to come here again.

Today IPL Match Prediction

today ipl toss prediction

boss said...

very informative blog
All you need to know about music

techvacuum said...

Thank you so much for sharing this post, I appreciate your work. It was a great informative post. Go so many useful and informative links.Loved your writings also. Concept of the topic was well discussed. Love to come here again.

best vacuum cleaner

Best Vacuum Cleaners Under 10000

Best Vacuum Cleaners Under 5000

Best Vacuum Cleaners Under 3000

Unknown said...

That is very important for me and helpful for others. The post is very clear and focuses on the main points.I need this type every day for learning. Outstanding articles and think are very unique.

Today ipl Match Prediction

today ipl toss prediction

tomorrow ipl match prediction

IPL Prediction

werwer said...

Omnisphere 2 update comes that has a thoroughly redesigned consumer interface, modulation pane and a mini-browser, about 25 new Fx units which includes Rock, Fuzz, Innerspace, Vintage Twin, etcetera. The sound business system happens to be improved within a remarkably pleasant way, https://freeprosoftz.com/omnisphere-2-serial-key-full-latest-version/

Post a Comment