# Report Not Displaying SQL Values **URL:** \ **Category:** Ignition\ **Created:** [February 16, 2015, 6:57pm UTC](https://forum.inductiveautomation.com/t/report-not-displaying-sql-values/9713 "2015-02-16T18:57:37Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Samn265](https://avatars.discourse-cdn.com/v4/letter/s/cab0a1/32.png) [@Samn265](https://forum.inductiveautomation.com/u/Samn265)\ **Post date:** [February 16, 2015, 6:57pm UTC](https://forum.inductiveautomation.com/t/report-not-displaying-sql-values/9713/1 "2015-02-16T18:57:37Z")
I need help! Does anyone know why I am getting \ 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 \ in this column! Here is the script that I am binding the table to: Here is the report designer data: Any advice is greatly appreciated. Thanks I am using Ignition 7.7.2 (b2014121709) [MES\_2015-02-16\_2054\_partial.proj](https://us1.discourse-cdn.com/inductiveautomation/original/2X/b/bcf354ec3abd04c9e70699264b6c61760c629e4d.proj) (66.4 KB) ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/9/9a46e93c0d17676b4f5fda78501a0fa6c62cede1.jpg) ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/3/3446056da591ddc9f6a7bfbfa2a3690f2e032130.jpg) ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/4/4245a54c36a5e3e03df8bc7e83589c35024fb727.jpg) ---
**Author:** ![nmudge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nmudge/32/3394_2.png) [@nmudge](https://forum.inductiveautomation.com/u/nmudge)\ **Post date:** [February 16, 2015, 11:20pm UTC](https://forum.inductiveautomation.com/t/report-not-displaying-sql-values/9713/2 "2015-02-16T23:20:27Z")
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. Sometimes the report viewer can be tricky. Best, ---
**Author:** ![craigb](https://avatars.discourse-cdn.com/v4/letter/c/9f8e36/32.png) [@craigb](https://forum.inductiveautomation.com/u/craigb)\ **Post date:** [February 16, 2015, 11:51pm UTC](https://forum.inductiveautomation.com/t/report-not-displaying-sql-values/9713/3 "2015-02-16T23:51:58Z")
Have you accidentally set a format for that column. I just tried for example, set a number to date format and it displays N/A. ---
**Author:** ![Samn265](https://avatars.discourse-cdn.com/v4/letter/s/cab0a1/32.png) [@Samn265](https://forum.inductiveautomation.com/u/Samn265)\ **Post date:** [February 17, 2015, 3:17am UTC](https://forum.inductiveautomation.com/t/report-not-displaying-sql-values/9713/4 "2015-02-17T03:17:15Z")
I exported the window and also data I was using in the SQL server. See my post for the additions. [DatasetExportedfrom SQL.csv](https://us1.discourse-cdn.com/inductiveautomation/original/2X/1/1f6568d8347c3d64c4a63d6abd16040b85071da2.csv) (7.24 KB) [MES\_2015-02-16\_2054\_partial.proj](https://us1.discourse-cdn.com/inductiveautomation/original/2X/b/bcf354ec3abd04c9e70699264b6c61760c629e4d.proj) (66.4 KB) ---
**Author:** ![nmudge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nmudge/32/3394_2.png) [@nmudge](https://forum.inductiveautomation.com/u/nmudge)\ **Post date:** [February 17, 2015, 3:40am UTC](https://forum.inductiveautomation.com/t/report-not-displaying-sql-values/9713/5 "2015-02-17T03:40:47Z")
I took a look at your window. 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. Best, ---
**Author:** ![SeanT](https://avatars.discourse-cdn.com/v4/letter/s/df788c/32.png) [@SeanT](https://forum.inductiveautomation.com/u/SeanT)\ **Post date:** [February 17, 2015, 1:24pm UTC](https://forum.inductiveautomation.com/t/report-not-displaying-sql-values/9713/6 "2015-02-17T13:24:38Z")
Is there something wrong with the timestamp columns also? Look at the funky dates in there! ---
**Author:** ![Samn265](https://avatars.discourse-cdn.com/v4/letter/s/cab0a1/32.png) [@Samn265](https://forum.inductiveautomation.com/u/Samn265)\ **Post date:** [February 17, 2015, 3:26pm UTC](https://forum.inductiveautomation.com/t/report-not-displaying-sql-values/9713/7 "2015-02-17T15:26:01Z")
Thank you craigb and nmudge. You were correct; I was using the wrong format. You guys are great… Thanks again! Sam ---
**Author:** ![nmudge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nmudge/32/3394_2.png) [@nmudge](https://forum.inductiveautomation.com/u/nmudge)\ **Post date:** [February 17, 2015, 3:26pm UTC](https://forum.inductiveautomation.com/t/report-not-displaying-sql-values/9713/8 "2015-02-17T15:26:43Z")
You are welcome!