Try this:

SELECT COUNT(*) AS TotalCount,Quality.Qualitydesc

FROM QualityCheck INNER JOIN Quality

ON QualityCheck.QualityID = Quality.qualityID

WHERE DATEDIFF(d,DueDate,GETDATE())...

It is also possible to get a result 1000,200000,199000,1,1 as the data type of lastupdatedatetime is not stated nor is the value. The question says that a single value...

This is a common requirement, to calculate the percentage of total given a list of values.

The normal calculation would be : Percentage of Total = ThisValue / Total

Your calculations look...

Can you provide a picture of what you want as output? How does the picture I provided differ from your original request?

Fitz

This is something I answered in a course a few weeks ago. Not the most elegant of charts at the end but it was what the client wanted.

Example source...

Could you please include a screenshot of your report design as I think you may not have grouped the report correctly.

Fitz

Assuming that you get the parameter choices from a dataset then how about:

1. Checking the number of selected items in the multivalue parameter against the number of choices available from...

Within your tablix you have a group (DocNumber) and a details row at present. Create another group level between the two existing items, by adding a child group to...

Better for you to try an example.

1. Create a new report and add two text fields one below the other, does not matter how far apart they are.

2. Change the...

wendy elizabeth (11/3/2013)

---

Thanks for your answers! I still have the following additional questions:

1. "Table with no allow auto filter in excel.'? Can you tell me what you mean by the...

If you have not used merged cells within your report then this would be caused by text boxes such as headers and footers that do not exactly match the widths...

sharonsql2013 (11/1/2013)

---

The reason I have another IIf in the denominator is because we have Previous year again in denominator and this denominator can be zero too. If I do not...

I have reproduced you requirement using a different cube. The issue is the hierarchy you have chosen to show ([Date].[Calendar Semester of Year].[Calendar Semester of Year]) is part of...

sharonsql2013 (10/31/2013)

---

I am trying to find out the sum of a filed named "PercentColumn" which is calculated column based on PreviousYear and Currentyear.

The expression of the "PercentColumn "is :

=IIF(Fields!PreviousYear.value ...

There is an open MSConnect bug / feature request for this. You can...