User Support Forum

I created a custom report from the Activity section of Powerchurch. Is there any way I can include data from Visitations? I don't see them in the options under "Edit Output Fields". The purpose is to provide our Elders with a list of members who we suspect haven't attended church in a while. We are ...

You could have this: m.headFN = IIF(pers_no=1, ALLTRIM(firstname_b),m.headFN) m.secondFN = IIF(pers_no=2, ALLTRIM(firstname_b),m.secondFN) m.parents = m.headFN + m.secondFN m.parents would be what is output onto the report The problem you are having with your variables as you listed is you are addi...

We have a service where we can create the report for you. Prices start at $120 and this report would probably be quoted at that price. At this point, I can't write any more of the report for you out of fairness to others who pay for the service, but I can offer support and guidance on the report th...

Create a variable to assemble the top line names and then output it as the top line in the family group footer. Ok.. I put this code in the variable. With this same set up as the m.children (initial value etc). ALLTRIM(lastname_a)+", "+IIF(pers_no==1, ALLTRIM(firstname_b), "error")+IIF(pers_no==2, ...

You are on the right track. The syntax for IIF ( I nline IF ) is as follows: IIF(thing to check for, if that is true do this, otherwise do this) You are getting into some more complicated stuff here, but the logic breaks down the same way that my earlier explanation did. Start with what you want to...

OK, on the Report Properties screen on the Variables tab, there are two fields: Value to store and Initial value . Initial Value should be "" and Value to Store should be the expression I mentioned previously. The third field Reset Value Based On should be set to your family group (lastname + first...

The expression that you have on the report is the expression that should be in your m.children variable. The expression that should be on the report output is: IIF(NOT EMPTY(m.children),"("+m.children+")","") Ahhh. Ok. I made the switch. Now it shows the parentheses around one name. No comma and no...

Zorak wrote:Take a new screenshot of the Report Designer window and we'll take a look.

Fur sure!
https://www.dropbox.com/s/qatf6jwm2gyd0 ... d.PNG?dl=0

Thank you!

I ran the report and it still looks the same. The children are still on separate lines. :/ In the original screen print you shared, you had the firstname_b field in the Detail band. Remove that (if you haven't already) and put the m.children field down in the group footer with the address and phone...

That sounds very logical :) I would love to try it. This might sound like a dumb question... how and where do I create a variable? Thank you so much for your help! This Knowledgebase article may help. Review step 6 , it shows how to create a variable for use. https://www.powerchurch.com/support/224...

That sounds very logical I would love to try it.

This might sound like a dumb question... how and where do I create a variable?

Thank you so much for your help!

Hello! I am familiarizing myself with Custom Reports. I am not familiar with all the functions and am having a hard time finding a function that will help me list a group on the same line right after the other with commas and parentheses. Our church is so large, we need to use all the space we have ...