report on MAS200 notes field with Crystal 8.5

[fumbles]

This is likely a very rookie question, but I am very out of my area of experience.

I'm using MAS200 for ERP at a distribution company. I am trying to use Crystal 8.5 to generate a report that will show the detail of various notes stored on the customer, item, po records etc.

I am not very familiar with crystal. I can make all of the fields visible in the report except the memo detail. Am I looking in the right place for the notes detail ie. APP_CustomerMemo Header. It has a field for Memotext and crystal will browse the first few characters of the detail but when the report refreshes nothing shows - not even the first few characters that showed up in the browse.

In my old Foxprp world - the detail would have been stored in a separate file. Is that what is happening here?

Thank you for any ... Help!

Steve

 

[Blorf]

What version of Mas are you using?

If 3.X, I will assume that Mas stores the memo field using multiple records, each with a max of 254 charachters, since thats the max size that Crystal 8.5 will accept.

The customer notes will probably have multiple records also, not just a 1 to 1 relationship, so make sure you have a group for the memo, not just in the header or what not, or you will only get one record.

Hope this helps,
ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.