Search results for query: *

Is there a way to copy format in Crystal similar to Excel? I have a report with a lot of formulas and it takes me 90% of my time to format all the cells. Is there a way to speed this process up? I can't see a Copy Format option and when I try Paste Special, it's not like in Excel. How do you...

Thanks! You are absolutely right. Outer Join cannot work, because I am working on the table and its alias, so the same thing. If I limit the scope to payments only, automatically I get payments only in the main table. And so Outer Join will not change anything. I changed Select Expert and it...

In my report, I want to compare invoices with payments. All these info (all history) is stored in SQL table 'Debtors Operations'. First I ran a simple report with only one table (no links though) where I simply list all invoices (using Select Expert to list invoices exclusively). It works fine...

Nope, it does not work. I understand your logic and I have the '*' on the invoice side. I tried both Right and Left Outer Joints and I even changed the direction of the link. Still nothing. Maybe this is because I am working actually on the same table, the link goes from the table to its own...

Thanks! I didn't think about that, but it still does not solve my problem, although it is an excellent guide. You see, I don't have separate tables for invoices and payments. It's all in one table "Debtors Operations History". I have a field with 'document's number'. This document can...

By the way, in your formula #2 (which you correctly modified) you can simple put: WhilePrintingRecords; NumberVar X:=X+1 These are 2 lines instead of 3. :)

I think you are one step away fromt the solution. Place the Initial Variable (NumberVar X:=0) in the GRrup Header (as you did correctly), but you ALSO need to move your Ending Variable (NumberVar X) to the Group Header (NOT Report Header) I know it works, I use Running Totals in every report...

First of all, I am not sure if this is the right place in this forum to post, so appologies if this is not the correct section. I'm trying to design a report that would calculate interest and I cannot find a way to make it. I will kinda walk you through my logic, please read and perhaps people...