You could also use a switch statement.  In vb.net you can do this in a single line statement, like Switch(A=B, <do something>, A=C, <do something else&gt

Both servers are on the same service pack level?

With the incremental processing, are you using a different view/table that contains only the new records?

re:the processing time, have yougot your processing logging turned on? If yes, have you reviewed...

If you're running win2k3 and have installed WSS (windows sharepointservices) and are running reportingsvcs SP2, then you could always deploy the 2 web parts in sharepoint, one is like a...

Don't know if it's stored in the DB (I couldn't see it) but you could turn tracing on the sql server for a while, limit it to only look at...

Have you allowed drill through for the virtual cube from *within* the virtual cube?  In normal cubes, you do this from the Tools|Drill through Options menu, but to make life...

I know this sound like a stupid question but you are/have been installing the AS service packs, not just the SQL ones?

Is your repository in MSSQL or MSAccess? 

Have you/did you optimise the schema?  If so, the keys for the dimensions will be supplied by the fact table query, and it's possible that just because the customer is...

I agree with Tiago, definitely put the Net Price into the view.  This also means that you can have discounts that change (or are aligned with) time (if you're not...

I think this needs to be changed in the RSReportServer.config file.  Look up 'Deploying a Delivery Extension' in BOL, this si the opposite of what you need, but instead of...

What is the setting in the Datasource for the reprot when you view it via Report Manager?  ie go to report manager, go to correct folder, change view to 'Show...

I think this is a known issue.  You can work around it by writing a dumy statement that has field names which populates the list and then swap your stored...

The asterisk needs to be between two sets, and typically I 'set' the result also to be sure; so the following should work.   I think the * is also covered off...

Hey Delpiero,

It seems like you've got a couple of questions in there

To answer the 'how to put store into this query', you have...

OK, I think I have it sorted.  The problem is using the 'Val' function tries to convert the property to a number, which i don't think your keys are (ie...