Can you tell us which report. We can then give you a more precise answer.

Thank you for your reply. I am trying to work with "AR_AgedInvoiceReport" report.

Thanks again

Oh that is easy. scroll down to the selection grid and change the Operand on Customer Number from "All" to "Not Equal To" and in the first space enter in the customer numbers separated by a comma (little trick I learned at the Sage Summit). I would create a new form so you can save the customer selection.

I've used the comma separated list in selection criteria often, but using the Sort Field (or a UDF) might be easier to manage if it is a long list.

Thanks for your reply. so when you say  "selection Grid" is the "Select Expert" on the "Report" Tab in crystal report right? so I select that and add criteria  "Is not Equal to "  add value with "*" at the end so it will remove all customer start with that name.

Now the other problem I face is, as I mentioned  I modified this report by adding new columns, which shows "week start date" , "Week End Date"

and written a formula 

@wkblc

If {AR_AgedInvoiceReportWrk.Balance}>0

then 

{AR_AgedInvoiceReportWrk.Balance}

Place that formula under the new column. When I run the report it works fine. 

But trying to add total for that new column at the end of the report, so for that I have new formula 

@wktotal

Sum({@wkblc})

and placed in report footer. But somehow it does not calculate the correct value. On a crystal report side do not see anything wrong,. Any idea as why my total is wrong? Does it do anything special in canned report in SAGE?

Thanks again

Thanks for your reply. so when you say  "selection Grid" is the "Select Expert" on the "Report" Tab in crystal report right? so I select that and add criteria  "Is not Equal to "  add value with "*" at the end so it will remove all customer start with that name.

Now the other problem I face is, as I mentioned  I modified this report by adding new columns, which shows "week start date" , "Week End Date"

and written a formula 

@wkblc

If {AR_AgedInvoiceReportWrk.Balance}>0

then 

{AR_AgedInvoiceReportWrk.Balance}

Place that formula under the new column. When I run the report it works fine. 

But trying to add total for that new column at the end of the report, so for that I have new formula 

@wktotal

Sum({@wkblc})

and placed in report footer. But somehow it does not calculate the correct value. On a crystal report side do not see anything wrong,. Any idea as why my total is wrong? Does it do anything special in canned report in SAGE?

Thanks again

For your totals, preview the report and leave it open.  Then use DFDM to open the temp work table and review the raw data.  Structural changes to work-table based reports can be tricky without understanding how Sage prepares the temp data.

Thanks for your reply. I see, so in this case user needs to set that parameter every time they run the report. But the way I did user does not need to remember that as it was part of the original criteria.  so do you will it be a problem the way I did for this report to eliminate some customers?

Thanks again,

As Big Louie mentioned, a named report setting will save the selection grid.  (Use something other than STANDARD).

Hello,

Thanks for your reply. Yes I used  "CompanyModification" 

Regarding Totals, you mentioned use "DFDM"  Can you please explain how and what it is?

Thanks again.

When i tried to open it got this message.. Is that okay?

Thanks.

No, run for your life!  LOL  Standard message, just click OK and continue

Summing a formula in Crystal is not always possible.

Indeed.  You're just looking at temp data.  The warning is about using DFDM to edit data (which is not for novices).