Recent content by aaronburro

woops, caught me with my pants down :eek:

Alright. thx for the attempted help, lbass :-/

nothing personal, but it just sounds like the data entry isn't consistent, you know? I mean, it doesn't make sense that the same call would be handled on two different account numbers. So, the only solution I can really pose at this point will give you a summation of "down time" for each...

so, there are only 2 possible visits per call?

Well, the only other thing I can think of will only work if the different accounts have the same callnumber for the calls in question. Unfortunately, since my database doesn't allow me to do this, I can't experiment with it and I can't tell you for sure how it works. But, the solution would be...

ok. as I see it right now, then, your request is kind of impossible with your current report's setup. The reason is that Crystal doesn't let you perform a summary on a summary. Is it possible that you could move the national accounts group below the call number group?

i hate to ask so many questions, but I'm still a bit confused on this. I'm going to call the time between the end of visit1 and the start of visit2 the "down time." 1) Am I to understand that you need to sum all of the down time for a call? 2) Am I to understand that the time is stored in...

OK, I'm thinking that your report looks like this, right? Contract Type Call Number Records And so, you are wanting to sum all of the time between visits?

I am assuming that by "sum at the group level," you mean "sum for the entire report." If that is the case, then just take out the {CALL.CALL_NUMBER} and that will figure it for the entire report. however, I doubt that is what you actually want. What exactly is this formula trying to accomplish?

bttt

synapsevampire, your suggestion works for the [@Invoice(s)] formula. it also seems to work fine w/ the "pay up" line as well. great work, as usual!

yeah, that might be a tad confusing. [@Invoice(s)] is a formula that I made that prints either "invoice" or "invoices," depending on if there are multiple invoices. [Table.amountOwed] is just the balance info for an unpaid invoice, and that displays a number, as it should. As far as the field...

Yep, absolutely certain that I didn't add a return. Are you ready for something wild? It only seems to add this mysterious newLine for the first field in the line of text (no <enter>'s). IE, all fields after the first one work fine. This seems to include formulas as well. So, I got a...

Yes, lbass, its all in the same text box.

ok, that link was for how to get the help file working :D what happens is that the text just doesn't wrap around the end of the text block correctly, and it has problems specifically where database fields are inserted. thus, in my example above, there might be plenty of room for the entire...