[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 598
  • Last Modified:

Running a report against Crystal Reports Server, permission issues?

Hello,

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.
0
mirde
Asked:
mirde
1 Solution
 
steinmtoCommented:
Local System just has access to the local system do the reports pull from different servers?
0
 
mlmccCommented:
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?

mlmcc
0
 
Kurt ReinhardtCommented:
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.

~Kurt
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now