SSRS provide table and matrix control to let user populate data in different scenario. Table control let user to populate simple format of data where fixed columns applied and rows grow dynamically. Matrix provide more powerful features where it columns and rows can be dynamically grow. In that case, writing a store procedure to support a matrix become easier in some scenarios.
Here is an interesting article, “Last mile of Business Inttelligence”. You may face the same problem in the BI world these days.
http://www1.juiceanalytics.com/writing/2007/11/last-mile-business-intelligence/
I am working on a SharePoint dashboard project recently. We have a lot of pie chart and graph integrated using Reporting Services Add-In web part. We have set Target Audience in each web part to offer multiple views to different users. It works fine in the past until this Monday. All the web part with target audience tie to AD group disappear. After spending half day on it, we found that the password for search service and content access crawler account expired. This effect the user profile and cause the target audience failed. Do check out these accounts if you have similar problem.
We are working on SharePoint Workspace with Business Intelligence solution. There some report build with reporting services show in SharePoint page. Then, we come across a special requirement that the client do not allow user to “Right click” on the entire SharePoint page including the reports. If you are using page viewer or report web part to view the report in native mode, you will never able to include your JavaScript to disable the right click. This is because it using iFrame to link to the report. To overcome this problem, there are 3 steps need to be done.
Since I am still new to SQL reporting services, I thought changing charts/pie color is impossible. The VS editor seems doesn’t have any more setting for me to do so. As you all know, the default palette color is very ugly. Luckily, I manage to found one article describe how to get more out of these limitations.
http://msdn2.microsoft.com/en-us/library/aa964128.aspx
I come across some problems setting the page height which render in web browser. The “Report Properties”-> “Page height” setting never works. It only works when you export the report to pdf or image file. So the report height in browser is never change.
Having difficulties to find help on reporting service’s functions like switch? You may not able to find any help on your local help. Go here to check on these:
yyTech Blog on .Net, SQL, SharePoint, Collaboration and tech tips. 