Sage 100

 View Only
Expand all | Collapse all

How Do I Clear the Crystal Rewports Cache?

  • 1.  How Do I Clear the Crystal Rewports Cache?

    Posted 06-30-2020 17:25
    How do I clear the Crystal Reports cache.  User is getting some strange printing going on with a form code they have used for successfully for several; years.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------


  • 2.  RE: How Do I Clear the Crystal Rewports Cache?

    Posted 06-30-2020 17:34
    I believe "C:\ProgramData\Sage Software\Cache\MAS 200" and its sub folders are what you are looking for.

    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------



  • 3.  RE: How Do I Clear the Crystal Rewports Cache?

    Posted 06-30-2020 17:37
    Thanks David.  It that on the server or the workstations, and do I delete everything in the folder?  Any risk of damaging anything?

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 4.  RE: How Do I Clear the Crystal Rewports Cache?

    Posted 06-30-2020 17:47
    Doug - That folder structure is on the workstations. It should be safe to rename that on a given workstation because it will get recreated during Print/Preview. However I don't know if it will actually solve the problem. There is already logic during print/preview to check the date/time of the cached .RPT and overwrite it if necessary. I'm thinking the strange printing may be more related to data or a change in remote RDS or Citrix printer driver.

    ------------------------------
    Alnoor Cassim

    Accounting Systems, Inc. (ASI)
    Email: alnoor@asifocus.com
    Orange County, CA
    ------------------------------



  • 5.  RE: How Do I Clear the Crystal Rewports Cache?

    Posted 06-30-2020 17:53
    Thanks Alnoor. I don't see that folder structure on the workstation.  I know that Crystal is rendered at the workstation and I tried having the user print pick tickets (truck delivery tickets for tomorrow morning) at a different computer and it didn't make a difference so I suspect something else is going on with the network or the print queues or something driver or print server related.  Of course they don't print them until the end of the day and now it's an emergency.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 6.  RE: How Do I Clear the Crystal Rewports Cache?

    Posted 06-30-2020 17:55
    Edited by Beth Bowers 06-30-2020 17:55
    @Alnoor Cassim - I can say from personal experience on MULTIPLE client sites - that logic doesn't always work.  I've made updates to reports or forms and the client still gets the old one when they print until we clear the cache.​  AND the frequency of those errors is increasing.

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



  • 7.  RE: How Do I Clear the Crystal Rewports Cache?

    Posted 06-30-2020 17:56
    @Beth Bowers  Can you please confirm the location of the files I need to delete.  I don;t see that folder structure on the workstation.  They are using 2016 standard.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 8.  RE: How Do I Clear the Crystal Rewports Cache?

    Posted 06-30-2020 18:08
    Doug - 

    On my own personal Sage Standard, I show Crystal Reports in C:\Users\MYUserName\AppData\Local although the names are modified to include some other data, so not sure if it pertains to Standard, or not.
    Title


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



  • 9.  RE: How Do I Clear the Crystal Rewports Cache?

    Posted 06-30-2020 18:12
    Thank you @Beth Bowers and @Kevin Moyes  ​​​

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 10.  RE: How Do I Clear the Crystal Rewports Cache?

    Posted 06-30-2020 18:10
    Search the local workstation drives for *.rpt

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 11.  RE: How Do I Clear the Crystal Rewports Cache?

    Posted 06-30-2020 17:58
    Edited by Alnoor Cassim 06-30-2020 18:05

    Doug - I believe the Cached RPTs are used for Advanced not Standard. BUT just in case make sure you turn on the File Explorer option to Show hidden files, folder, and drive since C:\ProgramData is a hidden system folder.

    @Beth Bowers​ Hmm good to know! 




    ------------------------------
    Alnoor Cassim

    Accounting Systems, Inc. (ASI)
    Email: alnoor@asifocus.com
    Orange County, CA
    ------------------------------



  • 12.  RE: How Do I Clear the Crystal Rewports Cache?

    Posted 07-01-2020 14:02
    Hmm, am I the only one who's not privy to this?  It's not ringing a bell.  I most often will just reinit the applicable Crystal wrk files whenever there's funky printing happening.  I don't recall ever having to address the 'Crystal cache', but I suppose it's entirely possible I just don't remember.

    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------



  • 13.  RE: How Do I Clear the Crystal Rewports Cache?

    Posted 07-01-2020 14:16
    You are not alone.  I was not aware of a separate "Crystal Cache".  We've always dealt with the reinitializing the work files like when WO travelers get jammed up.  You checked the form code itself that it didn't get corrupted?  Create a new form code from copy?

    ------------------------------
    alan niergarth
    Velosio LLC
    ------------------------------



  • 14.  RE: How Do I Clear the Crystal Rewports Cache?

    Posted 07-01-2020 14:23
    This is news to me, also.

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------



  • 15.  RE: How Do I Clear the Crystal Rewports Cache?

    Posted 07-01-2020 15:00
    What I have seen at one location is that I made mods to the report and the person testing could not see the changes.  @Alnoor Cassim says there is supposed to be date checking so the most current version is always used, but that was not happening.  I could see the report in the cache.  After clearing the cache, without further changes to the report, it printed correctly for the client, as well.​

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



  • 16.  RE: How Do I Clear the Crystal Rewports Cache?

    Posted 07-01-2020 15:12
    Beth I was working at Sage when the feature to cache reports was put into play (also I believe the RPT files in C:\Users\MYUserName\AppData\Local those with the GUID in the filename are created by the Crystal Reports designer itself for it's own purposes and not a Sage thing)

    The design spec at the time from way back when was to not only check if the client side cached RPT was missing but also check its date to see if it was older than the one on the server. But I never checked the code to see how it was actually done. So I'll put that on my To Do list and report back.

    ------------------------------
    Alnoor Cassim

    Accounting Systems, Inc. (ASI)
    Email: alnoor@asifocus.com
    Orange County, CA
    ------------------------------



  • 17.  RE: How Do I Clear the Crystal Rewports Cache?

    Posted 07-01-2020 15:16
    @Alnoor Cassim - it seems like this may have gotten broken at some point, because I've only had it happen in the past few years, but it's happening with more frequency​

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



  • 18.  RE: How Do I Clear the Crystal Rewports Cache?

    Posted 07-08-2020 20:36
    Has this issue been resolved or is no longer urgent @Doug Higgs?​

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------



  • 19.  RE: How Do I Clear the Crystal Rewports Cache?

    Posted 07-08-2020 21:53
    Yes.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 20.  RE: How Do I Clear the Crystal Rewports Cache?

    Posted 07-09-2020 14:55
    Thread moved to Sage 100 Community.

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------



  • 21.  RE: How Do I Clear the Crystal Rewports Cache?

    Posted 07-15-2020 12:13
    Addt'l info from other post.
    https://community.90minds.com/communities/community-home/digestviewer/viewthread?GroupId=121&MessageKey=bf1bdd16-221f-48ac-a9ba-d8b473b6c00b&CommunityKey=a46f78b7-9da0-4283-a1b3-1411c4d44ef7&tab=digestviewer&ReturnUrl=%2fbrowse%2fallrecentposts

    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------