Right, I am was interested because I have encountered this issue myself. Sometimes you want spaces in the parameter label so trimming before loading in to the parameter is...

Peter Brinkhaus (2/1/2009)

---

The Join function in SSRS expects an array of objects or strings as its first argument. It concatenates all string values of the elements in the array and...

The data driven subscription will send one email for each record in the dataset that your query returns, it won't handle the multiple datasets that your current query is returning....

You need to put the measure on columns

select sum([Client Tbl Dim Calendar].[Day Week Id].&[0828]:[Client Tbl Dim Calendar].[Day Week Id].&[0824],[Measures].[Quantity Sold]) ON COLUMNS

from [DSVClientAdmin]

Hi

You should find that the query still works, it is just you get that error message because BIDS can't verify the query because the temp doesn't exist. I still...

Hi

The above is using a sub cube which is valid, the designer generated mdx uses them all the time. I think what you want is something like this:

WITH

MEMBER [Measures].[SelectedDimensionLabel]

AS...

Ok so you'd then test the value of count in your sp or query and if you want to email then return a table with any report parameter information and...

If you set up a data driven subscription then the query that returns the email information can perform a check to determine whether report data exists or not. If...

Hi

If Report Manager (or SSMS) can't retrieve the meta data from query or sp then the validation will fail and not allow you to progress. I had this problem...

Hi

I don't want the parameter to act as the value in the filter criteria I want to use it to determine whether to perform the filter or not. I...

You could do it by adding a report parameter (e.g. ShowAll) and having the initial visibility of the rows to be based on the parameter value. Of course the...

Hi

I answered my own question. You just put the code in the jump to url section of the navigation pane. The code was html so I can't...

Try putting:

SET NOCOUNT ON

at the top of your proc.

Yes, I could retrieve a subject line from the data driven sql.

The default subject when you set up a subscription is

@ReportName was executed at @ExecutionTime.

These 2 variables...

That has cracked it, well done!

RS is quirky sometimes, I would have thought that setting repeat header rows on new page applies to the WHOLE table not table minus footer!

Thanks...