Report Subscription - date

[Kevin79]

I have a subscription to a report for Endpoint Protection that shows infected computers. The report only shows the date range from when the report was initially created. How do I get it to show a "floating" range (the past 10 days)?

[GarthMJ]

You will need to edit the report and setup the prompts to have the floating 10 days.

[Kevin79]

How do I do this?

[GarthMJ]

Edit your prompts queries and added Getdate and Datadiff to them to get the results that you are looking for.

[Kevin79]

Ok, I must be dense, but where do I add these values? 

[GarthMJ]

In the datasets for the prompts.

Have you every edited a SSRS report before? if not then you should look at that first. there are a few good books on the subject. Mine being one of them.

[Kevin79]

No I have not. Do I need to book about SQL reporting or Configuration Manager reporting?

[GarthMJ]

Personally I would look for one on CM reporting. Why because it will show you the details on using SSRS with CM.

 

This is the one I wrote so I'm bias but I think it is good and it will work for all version of CM. https://www.amazon.com/System-Configuration-Manager-Reporting-Unleashed/dp/0672337789/

 

 

 

 

[Kevin79]

Ok thanks. I will see about ordering a copy.

[GarthMJ]

If you love it, please review it on Amazon. Heck, I'm sure that @Niall, would be ok with you reviewing it here too.

If you have question about it, I'm always around.