Question:
Hi,
We have a stock report which contains 2 keysfigures. Actual stock and Projected stock. The key figures are displayed in the columns along with calendar week and calendar day (each week has day break down with total at end of each 7 days)
So structure of report looks like this:
WK40 WK41.....
10.10.2005 11.10.2005 12.10.2005.....
Actual Stock Actual Stock Actual Stock....
Material XYZ VALUE... VALUE... VALUE...
- If Projected stock is not hidden then I can see figures for both actual stock and projected.
-If Projected stock is hidden then no data is shown even if there are values for actual stock.
There are values for the Actual stock for some days of the week (rather than the amount being 0) but the query does not display them unless you are also looking at projected stock
The aggregation of stock is 'last value'
Actual stock is not a calculated figure
This seems to be related to the fact that there is no actual stock for the material on the Sunday of the week I was looking at.
I.e. for the last day of the period we want to report on.
Any ideas what could be causing this?
Thanks for your help.
Answer:
I have resolved the issue, it was to do with query properties
Thanks