I have created a DUNDAS gauge within SSRS 2005, which work properly, it display the count value based on a table... The report uses a parameter which allows user to select School Class Type; based on the parameter the DUNDAS Gauge will show the count of students within that Class.... But when there is no data in the table based on the specific parameter, the gauge shows the default 367 number, how do i remove this? Thanks

any helps please?

I have created a DUNDAS gauge within SSRS 2005, which work properly, it display the count value based on a table... The report uses a parameter which allows user to select School Class Type; based on the parameter the DUNDAS Gauge will show the count of students within that Class.... But when there is no data in the table based on the specific parameter, the gauge shows the default 367 number, how do i remove this? Thanks Hi Sam233, Since it has a default value when there is no data, you could also control this number to display zero based on some expression utilizing the IIF function. Such as =IIF(Isnothing(Fields!data.value), 0, Fields!data.value) Thanks, Challen Fu