Displaying pdf reports in SharePoint

I had an interesting request by someone the other day. I was helping them set up a new site template for SharePoint 2013 and they wanted to display a couple of reports on their site that they had in pdf format in a way to showcase the numbers of the report to others in the company that would visit this site.

There are multiple ways actually to do this very method, but the one I ended up going with is referenced in the following article:

https://sharepoint.stackexchange.com/questions/151161/how-to-embed-word-and-pdf-documents-in-pages

After doing this one the page it gave a pretty good layout on the page. My only concern going forward is having to update this manually and having to possibly retrain someone to keep this showing the most up to date info on the page.

There are other things I would like to research as part of this like putting in zoom or other capabilities in the code to modify the view of the pdf for the users.

I hope this gives you more ideas for displaying info on sites and pages and should work regardless of what version of SharePoint you are working with.

If you have interesting ways to display reports or other objects on pages, feel free to add to this in the comments below.

Thanks!  -BJ

Update 9/18/17:

Beau Cameron just posted a fantastic article about how to do this in O365. Here’s the link:

http://www.aerieconsulting.com/blog/how-to-embed-a-pdf-in-a-modern-sharepoint-page?utm_source=collab365&utm_medium=collab365today&utm_campaign=daily_digest

Enjoy!

Advertisements

BI Architecture Talk for SPOC

Happy New Year everyone!

I wanted to get the word out that this month’s SQL Professionals of Chattanooga (SPOC) meeting this month on January 27th at 5:30pm at the Business Development Center (BDC) in Chattanooga, TN. It’s located at 100 Cherokee Blvd and you can get there by heading over to the northwest side of town. See here for a map. You can check out the announcement and the group website here:

http://spoc.sqlpass.org/

I will be speaking about the business intelligence (BI) architecture of SQL server at Life Care.

Come on out and learn how we have implemented SQL and how we have taken advantage of the many features and functionality that SQL Server can offer. We have been running this solution in our environment for about 8 years now and there’s not a lot of the ins and outs we haven’t tried. From clustering, to Analysis Services and Power Pivot, to Reporting Services, to Integration Services and everything in between; we try to pull as much business value out of SQL server that we can (and have to for what it costs…).

So if you are interested to hear more about this please feel free to join us for some free food, tech talk, and networking on January 27th at 5:30pm.

Even if you don’t work directly on SQL server or would like to learn more about SQL Server or aren’t even sure where to start learning, we are always open to having new people from the area to attend so that we can learn from each other. In the end that’s what this is all about! Creating a community of knowledge that can benefit anyone who wants to learn more.

Thanks!

-BJ

Hey everybody! Come out and join me for lunch and SharePoint

It finally happened. I am taking the plunge and agreed to do my first user group presentation. Believe you me, I am just as nervous thinking about it as you are. But I am also very excited at the opportunity.

I will be presenting “SharePoint Campfire Stories” on September 23rd from 11:30am until 1pm at the Small Business Development Center. Come on out and let’s share funny, sad, and maybe even interesting things I have run across in my 6 years as a SharePoint admin.

There will be something for everyone here. I will try to cover things that can help beginners new to SharePoint as well as those of us who have a few battle scars in the war of SharePoint.

My general outline will be on general gotchas and other fun and interesting experiences that I have seen while installing, maintaining, and of course patching and maintaining SharePoint from old versions like Wssv2, all the way up to SharePoint 2013.

Everyone is in for a treat because I recently finished a migration for SharePoint 2013 Foundations that I have some tips to share as well.

Go here for a signup

https://www.eventbrite.com/e/chattpac-user-group-lunch-9232014-tickets-13033933847

If you have any questions, feel free to let me know through the comments below or send me a tweet @bjfentress.

Thanks and see you there!

-BJ

SharePoint Saturday Atlanta 2014

Back on June 21st, I had the privilege of attending my first event of the year in Atlanta at the Georgia State University Student Center.

You can find out more about the event by going here.

The twitter feed for this event was #SPSATL and if you have a chance, I highly recommend you go back and check out all the content that was related to this one.

While I was there I had a chance to check out the following sessions:

“Anatomy of an Intranet” by Michael Greene Twitter Blog

“Use SharePoint as a viable Hybrid Approach to your Enterprise” by Eric Harlan Twitter Blog

“Windows Azure as a SharePoint Farm Restore Rehearsal Space” by Tyler Bithell Twitter Blog and Pablo Montequin Twitter

“The White Hat: hacking SharePoint On-Prem from Google Reconnaissance to Metasploit” by Joseph Irvine Blog

“Business Intelligence with SharePoint 2013 and SQL 2014” by Ivan Sanders Twitter Blog

My personal favorite of the day was the session on hacking SharePoint by Joseph Irvine. It gave me chills as to some steps I should be doing with my own SharePoint farms, but also gave many examples of businesses and organizations that show they just click next, next, next and then quit maintaining their servers.

Shame on them and shame on me too! Security for the most part isn’t too difficult, it just takes extra time that most people don’t have the time for. Until they get hacked or pwned.

The folks in charge of putting on this event did a great job! I look forward to these events whenever I can go because they always line up good speakers who can give you FREE training on something you want to learn more about. If there is an event going on close to you in the future it’s worth a tank of gas and a Saturday of your time to better yourself. Now go sign up!! 🙂

To learn more about upcoming events for SharePoint Saturdays head on over to http://spsevents.org

-BJ

Grid View Issue Reappears with Performance Point 2013 post June 2013 CU

Hello again SharePointers!

I wanted to get the word out on another bug that seems to have reappeared in Performance Point in SharePoint Server 2013. Originally this issue popped up as a problem with the grid view being cut off towards the top. Example below:

clip_image001

This issue was corrected in the June 2013 CU for SharePoint Server here

But after testing both before SP1 (August 2013 CU) and after SP1 in my farms, I see the following issue pop up when multiple pages exist in the web part. This is referred to pagination I believe and causes a behavior that we see in our farm like the screenshot below:

clip_image002

For us it’s more of an issue about our users not being able to view the proper info they need. I have filed a case with Microsoft support and will keep everyone up to date on how it progresses.

Fortunately as I was typing out this post I got a message from someone that this is an official bug and will be submitted to the product group to be fixed.

So I am glad that it is not just my farms that see this issue… 🙂 But I also hope that this provides some help for those of you seeing this issue as well. As soon as I get word on which CU this new fix will be in, I will let everyone know.

Thanks for visiting!

BJ

SharePoint 2013 SP1 kb2817429 fixes Dashboard Designer issue

Greetings!

I thought I would add to the hoopla currently going on around Service Pack 1 for SharePoint 2013 which was released this week. If you haven’t got it yet, go get it now and test it out on your farms! You can find it here.

One quick thing I also wanted to mention that I have verified with SP1 is that when you install this update it does fix the Dashboard Designer not loading error that I wrote about in my last two posts here and here.

One other tidbit I did notice after I patched my farms is that when you go into Central Administration and look at the patch numbers it erases all the annoying list of patches or cumulative updates applied to your farm previously. Kudos to the team for implementing this!

So a farm like this (Pardon the 2010 reference, I didn’t have a good 2013 one):

clip_image001

After the 2013 SP1 Install will look all nice and neat like this:

clip_image002

Enjoy and happy patching everyone!

-BJ

Fix for KB2825647 released and verified

In my previous two posts I focused on a problem created by the install of the October 2013 CU for SharePoint 2013 Server. It basically disabled the ability of your users to launch dashboard designer (DD) after installing the cumulative update.

In December 2013 another CU was released, but didn’t do anything to address the problem of not being able to launch DD. If anyone of you have a SharePoint 2013 farm and use BI, this is kind of important. It’s kind of like owning a cheese factory and someone comes along and disables all of your cows from giving milk.

Good news though! After checking the MSDN forums I came across the following article:

http://blogs.technet.com/b/office_web_apps_server_2013_support_blog/archive/2013/11/19/performancepoint-2013-dashboard-designer-fails-to-start-after-october-2013-cu.aspx

Originally this article listed 3 files that needed to be replaced in all of your SharePoint farms to correct the CU issue, but initially I tried this and it did not resolve the problem. But after a few days two more files were added to be replaced as well.

The great news is that I confirmed that this does fix the original issue brought on by KB2825647 and now we can launch DD with the October 2013 and December 2013 CU applied to my SharePoint 2013 farm! Oh happy day!! Smile

Maybe this will get integrated into the February 2014 CU, but secretly I hope we get to see SP1 for SharePoint 2013 before that.

We’ll just have to wait and see. Happy SharePointing everyone!

-BJ

December 2013 CU for SharePoint 2013 still has Dashboard Designer problem

KB2850024

Happy Friday again SharePoint folks! I bring you good tidings of joy in this holiday season, but all of this doesn’t come without a lump of coal from the world of SharePoint 2013.

According to this article put out:

http://blogs.technet.com/b/stefan_gossner/archive/2013/12/20/december-2013-cu-for-sharepoint-2013-has-been-released.aspx

The December 2013 CU for SharePoint 2013 has been released, but unfortunately for those of us looking for this CU to fix the broken Dashboard Designer that was a result from the October 2013 CU for SharePoint 2013, it isn’t going to happen.

I guess we all must still dream of Service Pack 1 coming hopefully next year. I hope this does get fixed eventually because if you are like me and have a Business Intelligence effort going on at your company and you use SharePoint 2013 for it, Dashboard Designer is kind of critical in this effort.

So if you are going to update your farms, feel free to, but be warned that DD is not going to function after you install it.

Everyone have a Merry Christmas and a Happy New Year! Smile

-BJ

SharePoint Server 2013 October 2013 CU Issue

 

Happy Friday everyone! Even if it’s Friday the 13th…

I wanted to post this update about an issue that is related to the October 2013 CU for SharePoint Server 2013.

You can find the summary of this issue from Todd Klindt’s patch list here.

The frustrating thing about this issue is that I have confirmed that I have this same issue after applying the patch in one of my farms and that the “fix” that is suggested from this article does not work to bring Dashboard Designer back up for me.

So I hope that in the next few days we see this fixed with the December 2013 CU, but somehow I think that if it doesn’t make it here, we may see it in SP1 which I hope comes out before the next CU.

You can read more about SP1 for SharePoint 2013 here as well.

-BJ