<p>Good morning, all! So, we have run into a weird situation that we haven't seen before with one of our reports. A bit of background on the report:</p>
<p> </p>
<p><strong>It displays the inventory of our scrap yard at the moment the report is run.</strong></p>
<p> </p>
<p><strong>It only looks at the current fiscal year and open fiscal period (So today would be 2017 / 07, we run July -> June FY)</strong></p>
<p> </p>
<p><strong>We closed the old reporting period (6) and opened the new reporting period (7) yesterday afternoon.</strong></p>
<p> </p>
<p><strong>The report ran fine yesterday morning, but today it just displayed a blank table.</strong></p>
<p> </p>
<p><strong>I ran the report queries directly against the DB tables, and they returned the correct info</strong>.</p>
<p> </p>
<p><strong>The weird thing is, if I hard code the fiscal year and period into the query, it runs fine and populates the table. It just won't pass the info through the parameters......</strong></p>
<p> </p>
<p>We looked at other database areas that may have secondarily affected the data, but found nothing out of the normal.</p>
<p> </p>
<p>Any thoughts on this?</p>
<p> </p>
<p>Thanks,</p>
<p>Scott</p>
<p> </p>
