SSRS - Incorrect Report Total for field

Question

I am having an issue where there is a report that brings in all information for a specific person. This person has a number of guests whom are going to be included in report. The report layout spells the information based on an everyday account meaning the data will display the information for each day differently because client buys a house for a specific date range. Each day has a specific rate for the property. Now  that you see the point, the problem is that for each day, it has it as 28 guests for each day and at the bottom, the report has a total for the specific booking Guest number. It has it as for 7 days booked the number of guests shows as 28. At the bottom it has the Report total as Guest: 28 * 7 = 196. when really the number is 28. How I would change the Guest field in Details to only show one 28 value for each day so the sum of all the booking will not be 196 in the report total? 

Answer 1

Hello,

How did you specify the expression for calculated the total guest in the report? If you want to count the distinct values for field "Guest", please refer to the following expression:
=CountDistinct(fields!Guest.value).

If I have any misunderstanding, please post a screen shot of the report designer sturcture and dataset with sample data, it benefit us for further analysis.

Regards,
Fanny Liu

---

Fanny Liu
TechNet Community Support