So would I use something like <foreach view="Invoices"> ((Adjustments_History.AdjdRefNbr.RefNbr)) </foreach>? And do I just put that right...

I did that, and it did fill in the holes. However, now there are a lot of repeated lines. Would you know how I could get around that?

Thanks for the help!

My set up is much different than yours. I do not have that arrow you are talking about. Do you know how you got yours to look like that by any chance?...

Thanks, Tim, this helped me set up the approval map. I'm still struggling on getting the email notification to work along with it. I'm doing test repo...

The first picture shows the break and the second is the following page where it continues the report.

It's because of the page setting. I should fix my first comment above and say that it is adding random page breaks on the print screen. Even if I set ...

Cash-by-Period-Example.xlsx The data on the left is from the account by period project, and it does not let me call to its Data class directly, so I...

JHPO999999.rpx

This worked perfectly! Thank you so much!

The account's reference number is 22158. So when joining the tables, I should put Ref Nbr as the parent field and 22158 as the child field?

Sorry for all the posts, but I determined that it is because my credit memos do not have a due date, so they cannot fall under any of the categories a...

Update to my issue. The balance column is subtracting the memos, but the bucket columns are not. Was there a step that I possibly missed to avoid this...

Thanks Tim, this was a lot of help. However, instead of subtracting the credit memos, they are just being ignored in my inquiry. I copied the formulas...

How would I go about turning this inquiry into a dashboard widget? I would like to create a chart showing the totals of each period, but I do not know...

Yes, your formulas in the other discussion worked for this. Thank you!

What would the visible formula for the 12 month example you used above look like?

Is it possible to have this exact same thing, except be able to specify the interval you would like it to show? By this I mean, say I specify a start ...

It worked! Pretty bulky but this is how it turned out, Concat(Left(Cstr((([POOrder.UsrPoints]*[POOrder.UsrPointValue]-[APInvoice.CuryLineTotal])/([POO...

I tried the same thing, and % symbol only shows up if I leave the schema field empty and let it be 8 decimal places. If not, the entire column goes bl...

This was a lot of help, but I'm still looking to know how to put a percentage sign in the column with the numbers, since I don't believe there are any...