User Support Forum

I'm trying to create a report that will show all expenses for a given fund number and a given account number and then sort all these transactions by payee and then total for each payee for the given period. I've looked through all the existing reports and can't seem to find anything. I have created ...

Ok then, let's have an informal poll: By a show of (virtual) hands, who would like to contribute custom reports they've created to a shared online repository? I'm in favor of the idea myself, but I'd like to get an idea of how successful this sort of thing might be. Has there been any development o...

Dish-Man wrote:can you use the pre-defined reports already written in the software and modify them to create your own custom report?

I believe I have seen some posts from the PowerChurch tech support in this forum indicating that you can't do this.

All eleven (11) fields are on the same row. There are no fields above or below each other. I have used the alignment functions to have the bottom of all fields on the same line. There are no boxes or lines around the fields in the Detail Section. The band height for the Detail section is NOT set to ...

I've been working on a series of reports and have been using some variables in nested IIF statements. I have to create approx 10 variables each time I do a new report. It would be great if PC could have global variables. This would allow us to use a particular variable in many custom reports without...

That is so cool. I will try it out. I guess one downside is that I have to create this for each report. Any way to create global variables instead of just local?

We're never satisfied, are we?

I don't think it is overlapping boxes or lines. I'll get a line of data and then I will get a blank line all the way across the page. The condition seems to be working (because it gets rid of the zeros), but the blank line is not going away. Is there any way I could send you the .pdf file? I think i...

I'm working on a report and am trying to eliminate blank lines. In the Detail Seciton of a Summary report I have eleven (11) fields. In each of thse fields I have the following expression in the 'Print only when expression is true:" field of the Print When window: sum_annualbud <>0 I have used this ...

I tried your suggestion. Here is the expression I tried to build: IIF(subacct=100,"Pastor",IIF(subacct=200,"Admin",IIF(subacct=310,"Wor", IIF(subacct=400,"Evan",IIF(subacct=500,"Cong",IIF(subacct=610,"Disc", IIF(subacct=690,"Educ",IIF(subacct=691,"Nur",IIF(subacct=695,"StuMin", IIF(subacct=696,"Pre"...

Seemed to fix it. Thanks for the promp help. I'm sorry for not searching for that text string in the first place. Would have saved some time.

When I go to run a custom report, I get a 'Cannot Generate Report' window with the following message. This report could not be generated because of the error: Alias 'PCPLUS' is not found. I press the 'ok' button and it sends me back to the 'Setup for Detai/Summary Layout Report' window. Funny thing ...

Thank you for the response! I hadn't thought of the variables idea - that's a good one.

I am looking for a way to test a variable for a particular value and then have the output be some simple text. For example, the following expression works good: IIF(PCPLUS.subacct="100","Pastoral","Administrative") However I have twelve tests to do. I could do a nested IIF statement but was wonderin...

Did you ever get a resolution on this issue? I think I have finally muscled my way thru and created the report I was looking for. There has been some discussion about sharing custom reports. I would try to explain thru a post but am afraid it would get too complicated. Let me know if you are interes...

I stumbled upon an answer in another, unrelated thread. I have not tried it out yet but thought I would post here since it is closer to my thread title: _________________________________ Cmonth is a function that returns the character month of a date expression. For example CMONTH(DATE(2005,6,1)) wi...