Adatis News

We have moved (again!)

After a short spell in Woking, we have now moved to a more permanent location in Farnham, Surrey.   Please update your records:

Adatis Consulting Limited
A2 Endeavour Place
Coxbridge Business Park
Farnham
Surrey
GU10 5EH
United Kingdom

Maps can be found on our website

 

Molding the Microsoft BI Stack

Stop Reporting Services (SSRS) 2008 from overwriting custom Parameter Datasets

Frustrating little quirk when building reports in SSRS 2008 using Visual Studio 2008.  If you write a custom query against a parameter dataset, and then change a query that references the parameter, the custom query used by the parameter is overwritten and reset to the default.

Now, you could keep a copy somewhere and replace it after every update, or, alternatively, use the <rd:SuppressAutoUpdate> tag by editing the rdl file directly.

<Query>
...
<rd:SuppressAutoUpdate>true</rd:SuppressAutoUpdate>
</Query>

I was close to raising this as a bug, when I found someone had beaten me to it:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=417209

 

PerformancePointing

SQLBits VI comes to London

Just in case you hadn’t already heard from Chris or Simon the next SQLBits has been confirmed for 16th April at Church House Conference Centre in Westminster.  Simon also explains why the tight timescales and only single day event this time.

If you need to find a reason to convince your boss why he should give you a day off to attend just look at the session list from the last SQLBits!

And if you fancy presenting yourself, session submission is open now.  You'll need to Login/Join first then complete your Speaker Profile before submitting a Session 

See you on the 16th!

 

Sooo Tired...

Installing SharePoint 2007 on Windows Server 2008 R2

Obviously when we get a new development machine, we install the latest Microsoft software in order to test the latest applications.  All in all Windows Server 2008 R2, is basically the server version on Windows 7, therefore it shares many drivers, and many common issues with its counterpart.  Therefore its no surprise that SharePoint 2007 does not install from disk to a Windows 7, or Windows Server 2008 R2 installation. 

In order to install SharePoint, you need to create what is called a “Slipstream” version, which in essence means rolling up all the latest service packs into the installation.  Something that Microsoft I'm sure will get round to releasing in due course.  However in the meantime you can follow these simple instructions. 

I would advise burning that back to a disk, so you don't have to do it in the future.   You may still get a few compatibility issues, but it seems to install and run as expected.

 

Latest PerformancePoint news from Microsoft

Cleaning Up Scorecards by Filtering Results

In building scorecards, sometimes the end result can lose impact if it contains information that has no value. One such kind of information are members that return empty results. Today, you have the ability on a published scorecard, in SharePoint, to...(read more)