Printing is slow for only specific functional profiles

SOLVED

Hello,

I have a very peculiar problem that we have struggled with off and on since we upgraded to v12 in 2020.Some of our users report that SOME of the Crystal reports they print take a very long time to load. I have finally narrowed it down to functional profiles. I will print the same document under one functional profile to PREVIEW and it takes 5 seconds. If I change my user to another functional profile and keep everything else the same, it takes 50 seconds. I tried all kinds of elimination of variables--removing access codes from the functional profile, updating the Report Groups, etc. I would think if it was an access issue then the report wouldn't print at ALL, not that it would print slowly. I recently fixed it for some users by recreating a brand new functional profile and adding in the authorizations by hand. This worked for 2 months until someone on my team ran the "Site Functional Validation" function overnight, and then nearly everyone had slow printing on 2 documents they print regularly. Recreating their functional profiles resolved it for 1 report, but not the other one!

I also removed the "Access Site" authorizations on the 2 reports in the Report Dictionary to eliminate this as a possible cause, to no avail.

Has anyone experienced something similar?

Parents
  • +1
    verified answer

    Hi- I assume that you are running Sage standard reports?  We don't use the out of the box reports however have found that they do include the function table in many of them.   I would suggest to take the standard report, copy it and remove the function table and any filters or parameters associated with the table.  This may resolve the report issue instead of recreating profiles which is a nightmare in itself.  The table is AFCTFCY.   Hope this helps.  Good luck.  Christine

Reply
  • +1
    verified answer

    Hi- I assume that you are running Sage standard reports?  We don't use the out of the box reports however have found that they do include the function table in many of them.   I would suggest to take the standard report, copy it and remove the function table and any filters or parameters associated with the table.  This may resolve the report issue instead of recreating profiles which is a nightmare in itself.  The table is AFCTFCY.   Hope this helps.  Good luck.  Christine

Children