wendy elizabeth (10/16/2013)

---

Thanks for your response! I have a few additional questions to ask you about your comment,

"1. Create the parameter and make sure to allow nulls

2. Add an available...

Assuming that the query you have written works correctly when @Course or @Grade are specified then :

1. Create the parameter and make sure to allow nulls

2. Add an available value...

In SSRS the report language set to fr-FR then the format 0.00 for the value 12.34 shows as 12,34

Seems that SSRS uses the localised version of the decimal point for...

m.eddakri (10/15/2013)

---

Hi Fitz,

Thank you very much for your response.

I get the expected result.

By cons I have a problem with the totals:

the term I use is as follows:

= Format (Sum (Fields!...

Looks like you are using .LABEL(0) from the parameter. This will return a text value. The DimDateMois.value is probably a number. Try :

=Format(IIF(Fields!Mois.Value <= cint(Parameters!DimDateMois.Label(0)), Fields!Montant_Réalisé.Value, nothing),...

Jason Selburg (10/10/2013)

---

Mark Fitzgerald-331224 (10/10/2013)

---

Jason Selburg (10/10/2013)

---

Personally, I'd move the decision logic to the procedure. have it accept both parameters as nullable, then handle your logic there.

The Report then only...

No problem...

Assuming that the datasets are the same but come from different tables then you can combine the two queries into a single dataset.

Change the dataset query to be like the...

Given the requirement I think that the design of the mapping table needs changing to allow the query to be written in a way to produce the correct results and...

Not a lot to go on from the picture and result of the query but...

Your hierarchy seems to suggest YQMD. From the fact you get a result suggests that...

The following CASE STATEMENT is the result in my SQL Management.

select

Column1 = case when Column1 = 'true' then 'Y'

ELSE 'N'

END ,

Column2 = case when Column1 = 'true' then 'Y'

ELSE 'N'

END...

I think you are asking for the same rows values as the first query, without all the NULLs. The NON EMPTY instruction any row that contains at least 1...

Just to clarify, are you looking to do this in a SSRS dataset containing an MDX query or within a table in SSRS.

If it is the MDX route then please...

It comes down to the data you have for the chart in SSRS to work on. Having the data in a denormalised format (jan, feb, mar etc) means...

As your default is 0 (not null) this must be in the accounts table.

Example:

Accounts PK values {0,1,2,3,4...}

Customer (Account FK) values {1,2,3,2,3,2,1,2,3,4...}

When you delete the values from Accounts this attempts...