Personalization, Customization and Productivity Tools

[Biotone]

I am having problem adding a sub-report that will read the MEMO files in AR.  We have shipping instructions on customers and in our old 3.71 system I could pull the memo info to the pick ticket and print it out if the MEMO code matched.  Now when ever i try to create the parameter field in Crystal and I run a pick tick print it retrieves not customer no or Customer Div. and it will prompt me for this informatoin.

Since the pick ticket is using a work file can anyon help me.

My goal is to print special instructions on the pick ticket or ? using the memo code SHIPPING from the AR_Customer Memo.

[VKZIMM]

You did not say what version of Mas90 you are running.

When you create the Sub-report for the AR_CustomerMemo file, you need to link the AR_CustomerDivision and Number from

the Picking sheet work file to the AR_CustomerMemo fields.

In the Subreport, in your selecton Formula, you want to select the Memo code you want to print.

[Biotone]

I am sorry, MAS200 4.4.04

As for the linking in the sub-report.  I think I have done this.  I just keep getting a prompt to enter the Div and Cust. No.?

Sub report - Database is AR_CustomerMemo

{AR_CustomerMemo.ARDivisionNo}={?P-SOHeader Division}
and
{AR_CustomerMemo.CustomerNo}={?PSOCustomerNumber}
and
{AR_CustomerMemo.MemoCode}="SHIP

[VKZIMM]

You do not want parameters in your subreport.

In your main report, click on Edit...Subreport Links

On the left side select the PickingSheetWrk fields for ARDivision and CustomerNo and make sure in the bottom of the window

that they are matching to the AR_CustomerMemo fields

Then in your subreport you should have the following and change to your MemoCode

{AR_CustomerMemo.ARDivisionNo} = {?Pm-SO_PickingSheetWrk.ARDivisionNo} and {AR_CustomerMemo.CustomerNo} = {?Pm-SO_PickingSheetWrk.CustomerNo} and {AR_CustomerMemo.MemoCode} = "SHIP"

[Biotone · Accepted solution]

Thank you Thank you Thank you

I had not seen this feature..I guess I still have a lot to learn when it come to Crystal.  I love it, just not sure how to do everything I need to.

Anyway the solution worked fine for me, I was trying to create the Parameter manually..I guess it will not work the same when you do that or I think I would have to link them using the sub-report link..

Thank you

Solution is good.

[Biotone]

I am very sorry but now when ever i print this, I get 10 lines printing for a sales order that has only 1 line...?

[Biotone]

I think Ihave resolved this by checkinfg for the Sequence Number at the group level for the detail record, but for some reason it still seems to only find 1 record the this memo type, I will review futhure but if you have any suggetions please send them my way..

I am not quit on board as to how this file and sub-report mix.

Scott

[VKZIMM]

In what section of the Main report do you have this sub-report?

What is your record selection criteria in the sub-report?

[Biotone]

I have the Sub repoprt in Group Header 1, and record selection in the sub reeport is {AR_CustomerMemo.CustomerNo} = {?Pm-SO_PickingSheetWrk.CustomerNo} and {AR_CustomerMemo.ARDivisionNo} = {?Pm-SO_PickingSheetWrk.ARDivisionNo} and {AR_CustomerMemo.MemoCode}="SHIPPING"

It finds the memo and prints correctly but will print the detail line 13 times.

[VKZIMM]

Group Header is on the Warehouse code.

Why don't you try adding the subreport to the bottom of the Page Header?