Geeks With Blogs

My Digital Life in Data Flow Data Warehouse, MDX, Cube, SSIS, BizTalk, SQL, XML, SSAS, SSRS, .NET Microsoft SQL - Reporting Services (SSRS)
BI User Group meeting 2014-11-18, PASS Highlights, SSRS Admin using Powershell
The speakers are Clayton Groom, Maria Stanley, Phil Milner. Highlights about PASS: I don’t think I’m interested in Karaoke, but having a chat with Chris Webb would be cool. Tabular versus Multi-Dimensional: One comment is that if the business is constantly changing requirement, it’s quicker to respond with a tabular model than MD. I’m not sure about that, from what I can see with building a tabular model, there is not much difference in setting up data source, view, relationships. I think it might ......

Posted On Tuesday, November 18, 2014 3:39 PM

Installing SQL 2005 SSRS on Windows 2008
First, don't ask me why. :( There was a need from vendor. Let's just leave it at that. So run through your normal SQL 2005 install, the validation page throws up a warning "IIS not running". Since SSRS is a must on this machine, so let's Google Bing it. Following some results like this one: run SQL 2005 install wizard again and got the same message. What the? Double check ......

Posted On Friday, September 26, 2014 4:30 PM

The importance of parameter ordering in SSRS Lookup LookupSet

When you use Lookup or LookupSet function in SSRS expression, make sure that the "destination dataset" is loaded before your "source dataset" starts the expression lookup

There is where it got me. I had one parameter for each set, and somehow put the one for destination set second. In that setup, none of my lookup returned anything. Once I switched the parameter order, everything works perfectly again

Posted On Thursday, September 25, 2014 3:20 PM

Using SharePoint list connection in SSRS 2008

Here is a good article from Microsoft about this:

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

SSRS subscription SQL Agent Job GUID

Can't believe I didn't have to use this until now. Bad bad automation design...

Thanks, steve_fromOZ.

Posted On Wednesday, September 24, 2014 12:15 PM

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

OLEDB going away? Microsoft claims to be deprecating it in favor of ODBC
In case you haven't heard. Microsoft claims to be deprecating OLEDB in favor of ODBC. Seems like they want to push as many people to the cloud as possible... http://social.technet.micro... ......

Posted On Thursday, June 19, 2014 3:55 PM

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

Real-time report VS Application
It is very often that we report developers get requests about "real-time" reports. I don't know about you, but I cringe every time I hear about this. For some people, "real-time" report means I have a report that executes a query in the database to get result back. But when you think about it, if you answer "yes" to any of the following questions, you don't really have a real-time report: Is your dataset cached on the report server? Is the query result cached on the database server? Does your source ......

Posted On Thursday, March 20, 2014 10:18 AM

2008R2 SSRS "Subreport could not be shown"
I got this error working on a report with subreport. At first I couldn't tell that anything is wrong with the subreport, which ran fine by itself.Turns out that the subreport pointer was changed, then the RDL did not switch out the references properly. So right-click on solution file and select "Clean".Then when I run preview again, I got a more detailed message.Now this is an error I can fix.When I tried to reproduce the error so that I can document in this post, I found that the Error List tab ......

Posted On Monday, October 7, 2013 2:38 PM

Using Recursive SQL and XML trick to PIVOT(OK, concat) a "Document Folder Structure Relationship" table, works like MySQL GROUP_CONCAT
I'm in the process of building out a Data Warehouse and encountered this issue along the way.In the environment, there is a table that stores all the folders with the individual level. For example, if a document is created here:{App Path}\Level 1\Level 2\Level 3\{document}, then the DocumentFolder table would look like this:IDID_ParentFolderName1... 121Level 232Level 3To my understanding, the table was built so that:Each proposal can have multiple documents stored at various locationsDifferent ......

Posted On Wednesday, April 4, 2012 5:29 PM

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

Using SSIS as data source for SSRS

Gotta try this:

Posted On Thursday, May 13, 2010 10:40 AM

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

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

Calling SSRS report using either T-SQL or SSIS
[Update: 2009-12-30] We got it working using SSIS. Read this post: [Original post] Would love to know if there is a way to kick off a SSRS report and pass some parameters into it via T-SQL or SSIS. Unfortunately, we can't have MS SQL Enterprise edition. Guess this is the true list of possible solutions: VB script PowerShell WMI script batch file T-SQL Sad thing is I know how to make this ......

Posted On Tuesday, November 24, 2009 2:53 PM

How to add a group without using wizard after a report was created
SSRS 2008 gave me a lot of white hair for sure. Here are a few things I learned that have made my life a little easier. Do not use Page Header, or rather, page header is useless. If you want to do anything with data per page, use the group header. Do not use column header given to you by default. Create your column header as another row in the inner most group that does paging; you can control it better from there. When creating report for the first time, create header and footer for each group, ......

Posted On Thursday, November 5, 2009 4:53 PM

Copyright © Kevin Shyr | Powered by: | Join free