Microsoft SharePoint

Using SharePoint list connection in SSRS 2008

Here is a good article from Microsoft about this: http://msdn.microsoft.com/en-us/library/ee633650(v=sql.105).aspx

The gotcha was really knowing which site your list belong to, and don't follow some other posts that tell you to do "data source= blah blah blah". Just straight up URL at the site level.

Posted On Wednesday, September 24, 2014 3:04 PM | Comments (0)

SSRS SharePoint connection

I've only done this in SSIS once, connect to a SharePoint list and compare the result. But just now I got a requirement that basically ruled out having that in SSIS (basically the requirement is everything has to be web interactive). Looking around trying to find some ingenious solution, and found that there is also a SharePoint connector in SSRS. Figures/should have know. This makes my life a lot simpler.

Posted On Tuesday, September 23, 2014 9:56 AM | Comments (0)

PowerPivot, Silverlight PivotViewer, Excel Services, Performance Point, Project Crescent from STL BI Use Group

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.000... mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans... mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-... ......

Posted On Thursday, May 19, 2011 9:21 PM | Comments (0)

SharePoint 2010 and SQL Server 2008 R2 BI

Just saw a presentation on SharePoint 2010 and SQL Server 2008 R2 BI Integration. There are some cool stuff that will be out soon. The presentation focused on PowerPivot and Performance Point server. A end-business user can access her/his datasource, pull in some external data (like weather condition), and create a spreadsheet using PowerPivot. This spreadsheet, in addition to being hosted on SharePoint, can be incorporated through Performance Point by a SharePoint developer, and build a Cube in ......

Posted On Wednesday, January 13, 2010 12:21 PM | Comments (2)

Final note on creating PDF using SSRS and SSIS

Business Scenario: The client gets some kind of feeds that writes into a process table of their client processing system. The data is stored directly as the raw XML file inside a SQL data column. The XML could store multiple enrollment information for the same member. We need to use this info to determine whether a member is eligible, then insert into a staging table. The staging table is then used as a feed to drive a report that generates an image for each claim and sent off to the different provider. ......

Posted On Tuesday, December 8, 2009 2:19 PM | Comments (0)

Performance issue with SharePoint Services 3.0 and SQL Reporting Services 2008 in integration mode

I'm having an issue here at a client site. The report we designed runs fairly quickly in DEV, it takes 8 seconds for the report to render. We now have the report deployed to the production SharePoint site and it's taking 1 minutes 8 seconds to load. Both reports point to the same database, so there is no difference on the data side. It's past 5 PM here so there is nobody on the SharePoint site, either. There is a slight difference in the hardware: the prod has 0.5 GB less available memory than DEV, ......

Posted On Thursday, October 29, 2009 2:34 AM | Comments (0)

Copyright © Kevin Shyr

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski