I need help! Does anyone know why I am getting <N/A> error in my “DowntimeMinutes” column of this report:
As you see from the screenshot the Dataset Viewer does display the column values of “DowntimeMinutes” but when I run the report I get the <N/A> in this column!
Here is the script that I am binding the table to:
If you export the window with the report and dataset filled and attach it to this forum thread I will take a closer look at it and see if I can find out why the DowntimeMinutes says N/A.
craigb is correct. The reason the column says N/A is because the format for the @Downtimemin@ variable is set to a date format. The format needs to be changed to numerical format
You can change it by double clicking on the text “@Downtimemin@” to make it highlighted. Then in the top right of the report designer select the “Format” tab, then select the “9.99” button. Then select a numerical format. And that is it, press the “OK” button at the bottom of the report designer.