Invalid Bound Column Name
Posted 07 May 2012 - 10:58 AM
I am also VERY new to Forums (1st one ever)
So I am posting this serious question in the practice area to get acquainted with everything.
I have data that is summed (done with SQL) by hour by date. So for example 1/12/2012 hour 0(meaning Sum 12am-1am) would contain an integer of that sum. I am trying to make an aggregate report to give statistical data aggregating on Day of the week but still by hour. So for example the Minimum value for all Mondays between 12am-1am. I set up a day of the week group and within that made an hour group the group stucture seems to be working fine. In the HOUR group header I put an aggregation item attempting to provide some of the aggregate functions in the proper view of my data. I am getting errors stating "invalid bound column name". I have read through the documentation and help menus and it seems that the only criteria for a column binding is that it is unique. I have created unique names yet am still getting the errors.
please advise me as to how i can proceed I have exhausted my own researching options. Thank you in advance for all of your help.