When you do your select, do you include all the dimensions or are you just summing on the fact table? I am wondering if something is introducing duplicates, causing agregation...

There is probably an easier way, but off the top of my head I would use an expression.

=iif(Fields!FieldName.Value >= 0,Fields!FieldName.Value,"(" & Fields!NumberOfLocates.Value & ")")

I have to agree that Reporting should be reads. Applications should be CRUD. But then you have the argument, Reporting Services is an Application. =)

This could work with limited...

Will your query run in the sample application?

I found this while trying to find something else (as always seems to be the way

I assume this is the code you are using to return a dataset in reporting services?

I think this will work, though I have not tried it.

="WITH MEMBER [Measures].[ParameterCaption] AS...

Can you give us the schema of the table and the schema of your cube design? Is the summed field nullable?

is this 2000 or 2005?

We've used the technique suggested by Pam and it works out well so long as the files are all in the same format. Claude's approach would work as well, again...

You can use the MSXML.XMLHTTP object in an activexscript to read the contents of a location to an adodb.stream. You can then save the stream to a file.

Dim HTTP

Dim Stream

Const...

Replace your table or view with a New Named Query

Alter your code to use a variable to build the value for the phone number, then assign the variable as the value to the column. That should get rid of...

I'm with ya. I just want something to keep me in communication. If I want something that plays MP3's I'll buy an MP3 player.

The article started out nicely but I feel it dropped off at the end. We are told where the problem was, but there was not mention, even in a short...

Exactly as sschissler says, the question was with regards to legal requirements. If you have to legally store the textual version of the xml, you would use the varchar(max) to...

I agree. Got my appetite wetted for more information so I took some time to play around with it.

Here is another approach that we have used internally.

http://www.sqlservercentral.com/columnists/bszabo/adtsdatastore.asp

http://www.sqlservercentral.com/columnists/bszabo/restoreadtspackagefromadtsstore.asp