Thursday, February 16, 2012

Cross Tab Missing Column

Hi,

Have a bit of a strange problem here.

Am working with a colleague on a system which generates "simple" tables and cross tables, both using the same SQL views.

The "simple" tables show all the data correctly... When we come to the cross tabs however, something very weird happens. The x axis is for the section in the factory - for 14 out of the 15 sections the data appears perfectly, but for one column we get nothing, no data, no column heading, nothing. Looking at the info pulled back from the SQL views all the info is there as well.

If we change the data to point to a different section code, it quite happily appears on the report...

Anyone had anything similar, or any ideas as to what could be happening.

I have googled this and come up with nothing, have asked on another forum with no response - am rapidly pulling out what little hair I have left!Problem Solved...

Spelling error in the Select string....

Sorry !!!

No comments:

Post a Comment