Running a report against Crystal Reports Server, permission issues?

Posted on 2011-05-04
Last Modified: 2012-05-11

Not sure if anyone has any good "tips" on my issue here, recently we are upgrading our custom ERP system's report server to a new OS, going from Windows 2003R2 SP2 to Windows 2008R2 x64 SP1.

One issue that I ran into is related to Crystal Reports XI R2 .NET 2005 Server (SP4) and trying to produce reports.

Basically, we have a Report Service (custom software) that is on the report server box, that accepts new jobs and processes them against the Crystal Reports, everything in the big picture works.

However the issue I am running into is, the crystal report produced (pdf) has different outcome depending on what user the report service is set to run under, if I give it a domain user (and setup group policy to enable logon as batch and logon as service) the end report is produced fine.

However, if I set the report service to run under "Local System" (which worked in our previous box) the report produced (pdf) has "bolded" headers where it should not, causing some lines in the report to overlap.

The strange thing is, the cause is controlled by the user the service process is running under, any clue as to why Crystal Reports would play nice with one and not the other?

Could it be that a service running under Local System that is talking to Crystal Reports does not work nicely, maybe limited access in some places where a network account would have better access.

All the files for the reports are local to that machine.

I don't think it has to do with the custom report processing software we have but something related to permissions/access in Windows 2008R2 where a network account works better than a local system account.

Just trying to identify the root cause as to what is failing when the service is ran under the local system account.

Any help or pointers is appreciated, thanks.
Question by:mirde
    LVL 8

    Expert Comment

    Local System just has access to the local system do the reports pull from different servers?
    LVL 100

    Expert Comment

    A permissions issue shouldn't change text to bold unless the report is set to do that.

    Is there conditional formatting on the fields in question?

    LVL 26

    Accepted Solution

    FYI, Crystal Reports XI R2 .NET 2005 Server is not "Crystal Reports Server".  Crystal Reports Server is a full featured, standalone application server. You have a custom solution that may incorporate parts of it, but isn't the same thing.

    I agree with steinmto's question - where are the reports stored?

    Also, have you installed the same printer drivers that existed on the prior server to the new server? Report appearance depends very heavily on the default or specified printer driver.  If you didn't install the printer drivers used by the reports on the prior machine then you're going to run into issues.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
    This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
    This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now