Hello,
Is it possible for change the work table selection criteria? Because I have modified on of the canned report and in the modified version I would like to eliminate some of the customers. Any advise/help as how to achieve that?
Thank you.
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
Thank you so much..
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
Indeed. You're just looking at temp data. The warning is about using DFDM to edit data (which is not for novices).
It's came out just blank
Browse (folder icon top right) to find the file name, in the company folder / module folder / tagged with the username/date/time for your Previewed report. Sort by date modified and it should be at the top of the correct folder.
(I thought this would be obvious from my screenshot...).
*Community Hub is the new name for Sage City