Home
Analytics
invalid bound column name issue
JVilardi
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.
Justin
Find more posts tagged with
Comments
Tubal
<blockquote class='ipsBlockquote' data-author="'JVilardi'" data-cid="100104" data-time="1336490897" data-date="08 May 2012 - 08:28 AM"><p>
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.<br />
<br />
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.<br />
<br />
Justin<br /></p></blockquote>
<br />
Can you upload your rptdesign?<br />
<br />
I'm not familiar with the error, but it should be something simple. It's looking for a binding that doesn't exist I would think.
JVilardi
<blockquote class='ipsBlockquote' data-author="'Tubal'" data-cid="100114" data-time="1336500063" data-date="08 May 2012 - 11:01 AM"><p>
Can you upload your rptdesign?<br />
<br />
I'm not familiar with the error, but it should be something simple. It's looking for a binding that doesn't exist I would think.<br /></p></blockquote>
<br />
Please find my file attached. I am very new to BIRT so the file is extremely basic at the moment.
Tubal
<blockquote class='ipsBlockquote' data-author="'JVilardi'" data-cid="100115" data-time="1336501489" data-date="08 May 2012 - 11:24 AM"><p>
Please find my file attached. I am very new to BIRT so the file is extremely basic at the moment.<br /></p></blockquote>
<br />
It looks like you've got a table within a table. It's fine to do this, and is common, but it doesn't look like that's what you want in this case. If it is, then you would just need to bind the data you want to work with to your inner table.<br />
<br />
Currently, all of your data columns are bound to your outer table (you can see them in the 'bindings' tab in your property editor window when you have the outer table selected.<br />
<br />
Your aggregation is in your inner table. You don't have any data bindings in your inner table. So it's looking for a binding called 'IDBR1' on your inner table, and there isn't one. And that's why it's throwing the error.<br />
<br />
I'm not exactly sure what you're trying to get, but you might be able to get rid of the inner table, and just use a week and an hour group in your outer table. That way you'll have all your bindings available to aggregate one.<br />
<br />
Hopefully that helps?
JVilardi
<blockquote class='ipsBlockquote' data-author="'Tubal'" data-cid="100117" data-time="1336505435" data-date="08 May 2012 - 12:30 PM"><p>
It looks like you've got a table within a table. It's fine to do this, and is common, but it doesn't look like that's what you want in this case. If it is, then you would just need to bind the data you want to work with to your inner table.<br />
<br />
Currently, all of your data columns are bound to your outer table (you can see them in the 'bindings' tab in your property editor window when you have the outer table selected.<br />
<br />
Your aggregation is in your inner table. You don't have any data bindings in your inner table. So it's looking for a binding called 'IDBR1' on your inner table, and there isn't one. And that's why it's throwing the error.<br />
<br />
I'm not exactly sure what you're trying to get, but you might be able to get rid of the inner table, and just use a week and an hour group in your outer table. That way you'll have all your bindings available to aggregate one.<br />
<br />
Hopefully that helps?<br /></p></blockquote>
<br />
<br />
That was very helpful I now know how to look for and add Bindings to tables.<br />
<br />
I followed your advice and removed the 2nd table and added a 2nd group to the main table. I am getting the data I want now but the formatting is not as expected. What I am looking to have is something like this...<br />
<br />
DoW (eg. Sunday, Monday, Tuesday etc)<br />
HOUR MIN<br />
0 DATA <br />
1 DATA<br />
2 DATA<br />
3 DATA<br />
4 DATA<br />
5 DATA<br />
...<br />
23 DATA<br />
<br />
DoW (The day after the one above)<br />
<em class='bbc'>*Same format as above by hour with data*</em><br />
<br />
what I am seeing is this format.<br />
<br />
DoW<br />
0 DATA<br />
<br />
Next DoW<br />
0 DATA<br />
<br />
...etc through the 7 days<br />
<br />
DoW<br />
1 DATA<br />
<br />
...etc through the 7 days.<br />
<br />
Can I achieve the formatting I am looking for with 1 table and 2 groups?<br />
<br />
Thank you for all of your time and effort.<br />
<br />
Justin
JVilardi
<blockquote class='ipsBlockquote' data-author="'JVilardi'" data-cid="100120" data-time="1336507548" data-date="08 May 2012 - 01:05 PM"><p>
That was very helpful I now know how to look for and add Bindings to tables.<br />
<br />
I followed your advice and removed the 2nd table and added a 2nd group to the main table. I am getting the data I want now but the formatting is not as expected. What I am looking to have is something like this...<br />
<br />
DoW (eg. Sunday, Monday, Tuesday etc)<br />
HOUR MIN<br />
0 DATA <br />
1 DATA<br />
2 DATA<br />
3 DATA<br />
4 DATA<br />
5 DATA<br />
...<br />
23 DATA<br />
<br />
DoW (The day after the one above)<br />
<em class='bbc'>*Same format as above by hour with data*</em><br />
<br />
what I am seeing is this format.<br />
<br />
DoW<br />
0 DATA<br />
<br />
Next DoW<br />
0 DATA<br />
<br />
...etc through the 7 days<br />
<br />
DoW<br />
1 DATA<br />
<br />
...etc through the 7 days.<br />
<br />
Can I achieve the formatting I am looking for with 1 table and 2 groups?<br />
<br />
Thank you for all of your time and effort.<br />
<br />
Justin<br /></p></blockquote>
<br />
<br />
Sorry For the hasty response. It looks like i accidently introduced a 3rd grp instead of a 2nd. By removing the extraneous group I now have the formatting and data as expected. Thank you very much for your help on this issue. This forum is a very powerful resource for learning this tool and I will be a frequent user and hopefully one day will be able to return the favor of assisting others. Thank you.
Tubal
You should be able to, depending on how your data is being returned from your dataset.
It looks like your grouping may be backwards right now.
Group 1 would be your DoW, group 2 would be your hour.
Since you don't want the details within your hour, and you only want the aggregation, you would delete your detail section, and only have your group 2 footer with the aggregations in it.
So you would really only need 2 lines in your table to show your data:
Group 1 Header: [DOW]
Group 2 Footer: [HOUR] | [Aggregation 1] | [Aggregation 2] | etc......
JVilardi
<blockquote class='ipsBlockquote' data-author="'Tubal'" data-cid="100122" data-time="1336509287" data-date="08 May 2012 - 01:34 PM"><p>
You should be able to, depending on how your data is being returned from your dataset.<br />
<br />
It looks like your grouping may be backwards right now.<br />
<br />
Group 1 would be your DoW, group 2 would be your hour.<br />
<br />
Since you don't want the details within your hour, and you only want the aggregation, you would delete your detail section, and only have your group 2 footer with the aggregations in it.<br />
<br />
So you would really only need 2 lines in your table to show your data:<br />
<br />
Group 1 Header: [DOW]<br />
Group 2 Footer: [HOUR] | [Aggregation 1] | [Aggregation 2] | etc......<br /></p></blockquote>
<br />
I formatted My table as you detailed above. I am getting information that appears to be correct, but when fact checking it, it is not accurate. I did a simple test using Min Max and Avg of my dataset. In my example I used data from sundays at hour 0 (meaning the hour between midnight and 1am). I had 15 instances of data within my database, however the aggregation information only accounted for the first 3. I am not sure why it might have stopped at that point. any thoughts? As always thanks in advance for your help.
