date parameters remove null valued groups

[javedi]

Hello

I'm new to SSRS and SQL and am having trouble in a report to show the groups with null values when date parameters are introduced.

The report shows the null values as 0.00 as required without the date parameters.

Below is the dataset used.

DataSet1
SELECT WDF_MATERIAL, COALESCE (SUM(ACTUAL), 0.00)AS Tonnage
FROM adhoc.VIEW_WASTE_MASTER_FULL
WHERE (REPORT_GROUP = 2) AND (MON_DATE BETWEEN @Start_Date AND @End_Date)
GROUP BY WDF_MATERIAL

Does anyone have any ideas as to what I'm doing wrong?

Thanks,
Javedi

 

[MarkSweetland]

The dates would only filter the selected data down to the desired date span. If no records are returned with NULL that would mean there were no records containing MON_DATE between the start and end date.

May have to give an example of your data and expected results...


Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach