Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Crystal Word and VFP
Message
 
To
14/06/2000 05:57:18
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00379874
Message ID:
00380258
Views:
18
Hello Walter,
thanks for your help, I have now grasped the basics of how to do this, this is where I'm at so far.
    1) User starts an instance of word ( not from VFP ).
    2) Creates a new doc from my template ( code.dot ).
    3) Code.dot has a button on it with "Import Crystal Report" as its caption.
    4) The Click event of the button calls a module PKTest containing this code:
          
    Sub PKTest()
    Dim oCR,oRep as Object

    Set oCR = CreateObject("CrystalRuntime.Application")
    Set oRep = oCR.OpenReport("myfilename.rpt")
    
    oRep.EnableParameterPrompting = False
    oRep.ExportOptions.FormatType = 14

    oRep.ExportOptions.DiskFileName = "anyname.doc"
    oRep.ExportOptions.DestinationType = 1

    oRep.Export(False)
    Documents.Open("anyname.doc")

End Sub
what I would like to do is, firstly populate the first page of the document with Fox data, e.g. user enters an order number into a textbox on the Word form which calls my VFP server and this in turn populates the pre defined fields on the document( I pretty well know how to do this ), then directly import the Crystal Report output onto a second page, if this is not possible have you any ideas on how it may be done another way, if this is taking too much of your time don't worry about it and thank you very much for your help


Regards

Pete
Regards,
Peter J. Kane



Pete
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform