Report service (report builder)- when I select the specific date it does not return values

Question

Hi all, i have a problem with my reports, when i select a specific date on reprot builder, it's doesn't return values, but in others date it return normal values. In console of Google chrome, it's give me a "manifest.json" error.

has anyone had a similar problem?

Answer 1

Hi @Victor Silva

This sounds strange, what kind of date parameter did you create, did you use a calendar control or a drop-down list? Are you sure you have the corresponding data for this specific date?

As for the manifest.json issue, here's a link to a simple Chrome extension that allows Microsoft SSRS reports to render correctly: https://github.com/rmsy/SSRS-Fix/blob/master/manifest.json.

Hope this can help you.

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya

Answer 2

Does the date data have a time portion as well? Then a simple

WHERE DateColumn = @date

don't work, you have to use something like:

WHERE DateColumn >= @date AND  DateColumn < DATEADD(day, 1, @date)

Answer 3

Hi all, Apparently my problem is a conversion from format of the date. It's converted to utc, and after to local again.

i'm debugging yet, I'll be back soon with more information.

Thanks all