[mfw_user_group] Re: Crystal reports

  • From: Niall Loftus <Niall.Loftus@xxxxxxxxxxxxx>
  • To: mfw_user_group@xxxxxxxxxxxxx
  • Date: Fri, 9 Feb 2001 10:15:13 -0000


Have you tried using a sub report with the link as the CustOrd and the Order
number.  I have used this solution to overcome a similar type of problem.
Using the Store and Fetch variables routine you can pass data back from the
sub report to the main report.


        -----Original Message-----
        From:   john.king@xxxxxxxxxxxxxxxxxxxxxxxx
        Sent:   Thursday, February 08, 2001 1:19 PM
        To:     mfw_user_group@xxxxxxxxxxxxx
        Subject:        [mfw_user_group] Crystal reports

        Hi everyone=2E

        I thought I might kick off with a little difficulty I have with
        The Job Progress enquiry in Shop Floor Control shows a line giving a
        or PR number for subcontract ops=2E (We use routing method)=2E
        Now I know the cross reference is held in the Order Master table
        CUSORD which is a concatination
        of the shop order number and the relevant operation=2E So you will
find a=20=
        600000 or 700000 series order with a ten digit field in CUSORD
        refers back to the Sop Order=2E Now this field isn't indexed so I
        create a link in Crystal using its linking wizard=2E If anyone knows
a way=20=
        of creating a link so that I may effectively reproduce the job
        enquiry using crystal, I would be very grateful for some tips=2E


        John King, Systems Manager
        E-mail: john=2Eking@faireymicrofiltrex=2Eco=2Euk

        The message in this transmission is sent in confidence for the
        of the addressee only and should not be disclosed to any other
        If received in error please remove this message from your system
        and advise the sender at the address shown=2E
        Unauthorised recipients are requested to preserve confidentiality=2E
        Fairey Microfiltrex Ltd=2E
        Company registered in England No: 1179763=2E Registered Office:
        Fareham Industrial Park, Fareham, Hampshire, PO16 8XG, England=2E
        Tel: +44 (0) 1329 285616  Fax: +44 (0) 1329 822442

Other related posts: