I ran the Stored Procedure in SSMS and put the same Parameters that I used in SSRS and got results but still no results in SSRS. See screenshot from SSMS....

Thank you for all your feedback, I truly appreciate it as I am trying to teach myself as much as I can about SQL and SSRS. I am the only...

This is the only WHERE statement in the Stored Procedure.

where @JCCo=JCCH.JCCo and JCJP.Job >= @BeginJob and JCJP.Job<=@EndJob

I do not get any errors when I run the report, just blank with no data. See screenshots attached here. Thank you for your help!

Yes, the Stored Procedure executes successfully in SSMS. When I run it in SSRS, I get no data returned.

Where else can I look or are there scripts to run to help find out what is causing the IO_COMPLETION waits? That is what our main issue is, I believe.

From...

I appreciate all the feedback, it is very helpful, as I am a SQL novice.

Yes, please send me the script in regards to indexes and then we can analyze the...

The missing indexes still seems like this could be an issue for latency. Does anyone agree? How could we end up with so many missing indexes? Would fixing these indexes...

Havin extremely high IO_Completion waits is what made us think it was disk IO.

I think turning off the Query Store will help alot. Now just need to figure out what...

Sorry my post is confusing. I wasn't really sure how elaborate on it. Yes, we are having performance issues and it mainly looks like disk IO latency. We have checked...

We have looked at our SAN and run diagnostics and there doesn't appear to be any hardware issues. I am more of a hardware/networking guy and SQL novice, so if...