Installation and Technical Issues

[kkirby-indmar]

Hello everyone. I am working with MAS 500 7.3 and Crystal reports 10. I am trying to edit the generic report that prints when you print a work order. I have everything the way that I want it, except for one thing. It is displaying the labor steps in our routings. I have edited the selection criteria to only show type of "M" which for us is materials, but it still is pulling the labor steps. It is almost like it is ignoring any selection criteria that I have entered directly into the crystal report.

Can someone tell me how to tell this report to ignore these labor steps?

Any help would be greatly appreciated!!!

[oyama]

I also had some strange filtering experience with some report. My solution was to hide those lines with "Section Expert." Not the most efficient, but it did what I neede to do.

[RDCushing]

Sounds like a "bug" that should be reported to Sage. However, the solution offered (editing the Crystal Report itself) is likely a good work-around for you.

[manookian]

If you set the selection criteria in the RPT file the report application will overwrite this. In order to ensure the proper data is used the application will instruct the report engine to set the selection filter to the session id used to gather the data. See example below from vendor listing:

    If (ReportObj.lRestrictBy("{tapVendListWrk.SessionID} = " & ReportObj.SessionID) = kFailure) Then
        GoTo badexit
    End If

[RDCushing]

I believe the suggestion made for changes to the RPT file was not to change the selection criteria but, rather, to suppress (hide) rows of data that MAS 500 is failing to properly select out of the data set.

[oyama]

Yes, that is what I meant.