Sage 100

 View Only
  • 1.  Crystal Reports exporting to specified XML format

    Posted 12-14-2019 15:15
    Client has a particular format corporate wants used when exporting to XML.  I can link it to my report and use it, but it doesn't pull Sage data.  I've been Googling but all of the Crystal links that sound useful are broken.  Anyone have a good link I can learn from?

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------


  • 2.  RE: Crystal Reports exporting to specified XML format

    Posted 12-17-2019 09:44
    Nowadays I use PowerShell for any XML needs, but I was hoping someone might have some nuggets about Crystal.

    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------



  • 3.  RE: Crystal Reports exporting to specified XML format

    Posted 12-17-2019 10:21
    I've temporarily given up on trying to get it to actually do it as a Crystal xml - instead, I'm just hard-coding the text fields needed (i.e. "<Company>", etc) in the report and exporting to Text and labeling it as .xml.  And it's working.  All of the reports I need for this client are VERY simple (no more than 10 fields), so this will get me by for now.  Luckily the client sent me all of the .xsd files, so I can cut and paste from there.

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------