Thursday, October 15, 2009

REP - 1213 frequency below its group

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.

3 comments: