Recent content by WillTRiker

Damn, it looks like we get a scaled down version so I don't have the option of an SQL view. I'll try and get it from our supplier .... might take a while if I get it at all.

Sorry, I'm very new to this, but you want this? Edited: posted xml.

Sorry, I'm very new to this, but you want this? emas.microsoft.com/sqlserver/2004/10/semanticmodeling" xmlns:xsd="" xmlns:xsi="" xmlns:qd="" xmlns:rb=""> (((links removed))) <Hierarchies> <Hierarchy> <BaseEntity> <!--Meetwaarden-->...

No joy. Initially I get the message that Null is no longer supported and that I should use System.DBNull instead, but that gets the error message that it can't be used in an expression :banghead:

I have a calculated field (Bhours) with the following IIf function: =IIf(Fields!BDate.Value<=Parameters!Pdate.Value and Fields!EDate.Value>Parameters!Pdate.Value,Fields!Hours.Value,0) It works perfectly, but I don't like the fact that it has a zero for the false part as I like the field to...

Just call me Will after my nick here on the forum. I have very little experience with SQL, but we recently started using Reportbuilder 3.0 and it would be handy for me to be able to get at least some fairly modest reports out of it. In fact, ran into a problem I couldn't solve using google so...