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.
Use the selection grid on the printing screen. Sometimes a UDF in the right table can add to this grid.
When that is not possible, a runtime parameter (in the rpt) is the only option. It will not affect the work table contents, only the report output.
Can you tell us which report. We can then give you a more precise answer.
Good Morning!
Always appreciate your help. I will try your suggestion and let you know if any other questions.
Thanks again.
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.
*Community Hub is the new name for Sage City