Allright folks thumbs up here comes our first KED entry for newbies.
REP - 1213 frequency below its group
Now this can be very annoying error to newbies. You can not just put the fields in repeating frames where they don't belong to.
If you have created 2 or more groups in a query and try to put field of say group1 , in a repeating frame of group2 which lets assume is top level group. You invited this error.
Here lets take an example.
Refer a figure you want your employee table report grouped by department_id and manager_id.
But you only take department id in the upper group and manger id is still in lower group.
While you are creating a parent frame with these 2 fields , you get an error we are talking about just before you run the form
Remedy is simple you have to pull the manager id in upper group. Now real life scenarios wont be that easy. But basics and facts are the only things we should stick to.
Hope I am not confusing though.
Thursday, October 15, 2009
Subscribe to:
Post Comments (Atom)
Thanks for this. It doesn't solve my problem, but helpful anyway :)
ReplyDeleteREP-1203: Field 'F_1' references invalid column.
ReplyDeleteproblem exists still!
ReplyDelete