Hi,
I’m trying to report donations for the month with donor’s source no in rows and donation detail in columns on the rows of the donor.
To get the Donor’s Source No. (Cell $D8) I’m using the following NL statement…
=NL("Rows","item ledger entry","Source No.","Posting Date",PostDateMonth,"source Code","Donations")
To get the donation detail (starting in cell $G8), I’m using the NL statements below on the Donations-Rows-Columns sheet. I get only the first entry for each source no in the donation detail section.
=NL("Columns","item ledger entry",,"source code","Donations","Posting Date",PostDateMonth,"Source No.",$D8)
I included a sheet (Donations-Rows-Rows) showing what I get when I use “Rows” instead of “Columns” in the NL Statements above. I added a sheet showing what I would like the results to look like.
Thanks!
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi,
I didn't look at the attachment yet, but from what you are stating I would say the problem is in the location of the NL(Columns) function.
You want to create a grid like report, so there are 3 elements needed: the rows, the columns and the data on the crossing of row and column.
The NL(Rows) is in D8, so the NL(Column) should be in G7 to get the data in G8
Although the report is about something completely different, this example shows what you need.
rmw -
Jet Reports Historic Posts Thanks!
Please sign in to leave a comment.