Forums

NEED A REPORT - Based on Head/Spouse status that have children

Last post 07-13-2009, 2:37 PM by mgoodell. 3 replies.
Sort Posts: Previous Next

     07-08-2009, 11:50 AM 14754

    NEED A REPORT - Based on Head/Spouse status that have children

    Getting a report for this might not even be the best way to do this. Here's what I need to do:

    We have one children's status that is child. Under that status is a substatus: child of reg.attender or member.

    Weekly, we update adult's statuses from infrequent attender to regular attender and vise versa based on their attendance. Once we do that however, their children's status needs to be changed too, either to child or child with the substatus child of reg. attender of member.

     So, I would like to get those children of newly changed status members into a group to do a mass action. I thought that at least I could get a report of all those who are of the status reg. attender who have kids, and then manually type those kids into a group to do the mass action. I cannot find a report that will give me that.

    Whether you have a report or you can suggest another way to do this, I would be very grateful!

    Megan

     07-08-2009, 12:55 PM 14756 in reply to 14754

    Re: NEED A REPORT - Based on Head/Spouse status that have children

    I dont think you need a report...  just do a query:  filter your query based on the status of the newly updated adults and run the search.  this should give you a temp group.  Select all names in that group using the select all box at the top of the list, then click on 'actions.'  under 'actions,' select 'view parents or children,' then select 'children of selected'... this will give you a new temp group, populated with all the kids of the adults you filtered for.  you can then do your mass action from this temp group.

     of course, your results will depend on whether you are using household postion for adults and kids the way F1 intended, ie: parents are either 'head' or 'spouse,' and kids are 'child'.

     hope this works for you... query is a great tool!


    - colleen

     07-08-2009, 1:47 PM 14757 in reply to 14756

    Re: NEED A REPORT - Based on Head/Spouse status that have children

    The P1000E report will also give you the names you need in a temporary group that you can then perform the view children of function using the actions menu.  if you are going to do this on a weekly basis it can save you time over query builder.

     Jeremy Jackson

     07-13-2009, 2:37 PM 14777 in reply to 14756

    Re: NEED A REPORT - Based on Head/Spouse status that have children

    THANK YOU! This makes it sooooo easy! I didn't know they had that nifty option right there in actions! Oh, this just made my day! Thanks!
View as RSS news feed in XML