# \[BUG-14509\] Reporting Data Query: Column names with leading numbers drop the numbers

**URL:** <https://forum.inductiveautomation.com/t/bug-14509-reporting-data-query-column-names-with-leading-numbers-drop-the-numbers/26723>\
**Category:** Ignition\
**Created:** [July 19, 2019, 6:34pm UTC](https://forum.inductiveautomation.com/t/bug-14509-reporting-data-query-column-names-with-leading-numbers-drop-the-numbers/26723 "2019-07-19T18:34:49Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![AIO](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/aio/32/87549_2.png) [@AIO](https://forum.inductiveautomation.com/u/AIO)\
**Post date:** [July 19, 2019, 6:34pm UTC](https://forum.inductiveautomation.com/t/bug-14509-reporting-data-query-column-names-with-leading-numbers-drop-the-numbers/26723/1 "2019-07-19T18:34:49Z")

</div>

Hey folks,

Ignition 7.9.10

I’ve not done a ton of reporting, so I’m not sure if this is a bug or working as intended, but it has caused significant frustration for me this morning.

I’m currently trying to run a query that works just fine outside of the reporting environment, and find that columns that start with (or are entirely numeric) have any leading numeric characters dropped.

Here’s the Query:

```auto
Select
MAX(DateName(Month, T_Stamp)) [Month],
[2017] = round(sum(case when datepart(year,t_stamp) = '2017' then TotalDaily 
    else 0 end),0, 1),
[20Seven17] = round(sum(case when datepart(year,t_stamp) = '2018' then TotalDaily 
    else 0 end),0, 1),
[Twenty17] = round(sum(case when datepart(year,t_stamp) = '2019' then TotalDaily 
    else 0 end),0, 1)
from totaldaily
WHERE tag = 'meter'
group by DatePart(Month, T_Stamp)
Order By Case When month(t_stamp) <= month(GetDate()) Then month(t_stamp) +12
    ELSE month(t_stamp) END

```

And here’s a quick screenshot of the resulting data:

![Report_Columns](https://us1.discourse-cdn.com/inductiveautomation/original/2X/8/8768729be15e9e27ac188d12dfbf5e293f99bf7f.png)

You can see that the entirely numeric column name was dropped entirely.  
I can escape this issue by adding a leading alpha or space (punctuation does not work).  
Thoughts on what’s going on here?

Cheers,  
Andrew

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [July 19, 2019, 8:04pm UTC](https://forum.inductiveautomation.com/t/bug-14509-reporting-data-query-column-names-with-leading-numbers-drop-the-numbers/26723/2 "2019-07-19T20:04:40Z")

</div>

I’m not sure why it’s doing it, but I was able to replicate it. I’ll make a ticket – if there’s a technical reason why this needs to be this way we’ll update the docs, otherwise we’ll fix it. Thanks for catching this!