SQL 2008 February CTP available

Microsoft has announced the release of a new feature complete SQL Server 2008 CTP, try it online for free on the SqlServerBeta site or at the MS connect site. I’ve played with it a little and found the new report designer to still be a preview version with some strange behavior. BIDS seems stable and the report project environment  is nice, too bad the wizard isn’t there (yet i hope). The new reporting services configuration manager had... Read more

Opening a Cube from Sharepoint issues

I made a connection to AS in Excel and published this connection as a ODC file to SharePoint as mentioned in a previous blog post. But when i openend the file connection by clicking itm i got a warning: “Excel was unable to get necessary information about this cube. The cube might have been reorganized or changed on the server”.   After some searching with MS i found a solution: http://support.microsoft.com/kb/931388. I tried tuning the... Read more

Using Analysis Services data in Excel Services

When you want to analyse a cube in sharepoint from excel services you need to create a data connection file and publish it to SharePoint, see the following Blog post for a walk through: http://www.sharepointblogs.com/tonstegeman/archive/2007/03/13/using-analysis-services-data-in-excel-services-part-3-create-and-test-an-excel-sheet.aspx One note, it is stated in the above walk through you need to save the file and upload it to the data connection folder, but its easyer to save it to the data connection folder at once. Read more

Using Toggling in Reports

When using the Report designer you can enable fancy toggeling of fields. Once you know the trick its realy easy.   Make sure you have multiple fields in rows or columns. Select the field you want to toggle and go to edit group and the tab visibilty, put it on visiblity hidden and check the “visibility can be toggled by another report item” box and select the parent report item you want to toggle. Thats all there... Read more

Using a Report Model from SharePoint in Report Designer (BIDS)

Today i tried to get my Report designer to work with a Report Model that was published to a SSRS in integrated mode. Ok i found this handy page from MS Working with Report Model Query Designer. Well that was simple .. o no it wasn’t we dont have a “Server=http://reportserver;” anymore in MOSS integrated mode.   After some fruitless tweaking the datasource i went to the net and i found a MSDN blog post:... Read more