I agree, this is the most readable, AND it works 🙂

@Lynn, indeed, I have read it, I also did a test and concatenated 'Value' with 'e0', and still the IsNumeric evaluates too 1, so it really always is...

Thanks Chris.

But if I leave out the where-clause, both 'IsNumeric' checks in the select always return 1, which means in my oppinion that all data can be converted to numeric...

Chris, I can see the little differences in the plan.

However, I am not a dba-expert, and not that good at analysing query plans.

Can you please explain me a bit what...

Thanks for the suggestion, but I already tried it, same error...

Since there are no new messages, may I conclude that no-one can find an answer for this very annoying problem ?

If there is anyone who has any ideas, or who...

Here is the complete syntax for the partitioning on this FactRights table :

-- FileGroups

ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_001;

ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_002;

ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_003;

ALTER DATABASE...

Thanks for all the replies yet, I'm glad to see that people are willing to help me on this strange one 🙂

DDL: the DDL I provided is correct, there is...

We have had some issues with calling packages from our control package too.

Can you tell us what the value of the property 'ProtectionLevel' is for the package you are calling...

Can't you try with the visibility of the row, and instead of recalculating the values, refer to the textboxes which contain the values needed?

For example:

= Iif((ReportItems!MarketTextbox.Value / ReportItems!SumMarketTextbox.Value) *...

You want to sort your tablix.

Sorting means you need to tell the desginer on what column(s) he needs to sort.

You expression will either return true or false, which isn't the...

Maybe an interesting fact too: everything worked fine for about 1 à 2 weeks, but then, suddenly out of nowhere, without any changes to the table, the error appeared.

My colleague...

Hereby my sql code to create the table (as you can see, a lot of columns, I've left out the foreign key statements, as they don't seem to be usefull...

tim.kay (4/2/2012)

---

We are trying to roll out Report Builder to just one 'expert user' and it is taking such a lot of effort to make it work for them that...

I would suggest to migrate to SQL Server 2008 R2.

First of all, your databases will be in the newer environment, which has lots of improvements compared to SQL Server 2005.

Second,...