Site Search:
Sign in | Join | Help
4Penny.net

Crystal Reports

Notes, Tips and Tricks on Developing using Crystal Reports

October 2007 - Posts

  • Could not load file or assembly 'CrystalDecisions.ReportAppServer.ClientDoc

    Could not load file or assembly 'CrystalDecisions.ReportAppServer.ClientDoc, Version=11.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

    When deploying a Crystal-enabled web app to a new server.

     I solved this, but it was a long road. I develop web apps that use crystal reports. For the most part they go on my servers, so I don't have to worry (and remember about) Crystal server deployment. This link is to another post in this blog that has my Crystal references. There is a link to a page there that has 'server deployments'.

     In my latest issue, I had deployed the most recent server deployment (Crystal XI r2 sp2) but that gave me fits. It got better when I installed the original deployment (which was current when the app was written - Crystal XI r2). I still had to change a few of the version numbers, but that was the big hurdle.

    http://vstoolsforum.com/blogs/crystal_reports/archive/2007/01/25/crystal-xi-release-2.aspx

    Posted Oct 23 2007, 07:29 PM by Steve Gray with no comments

  • Grey Bar (or Green Bar, or Blue Bar) for Crystal Reports

    Often a report has so much data, it's hard to follow the line across the page. Customers ask me to 'put lines across the report so I can read it better, like Excel'

    I think a more effective technique is to alter the background color of every third line. Here is the code to do that:

    if int(RecordNumber/3)/2 = int(int(RecordNumber/3)/2) then crsilver else crWhite

    This uses the Crystal 'RecordNumber' variable to determine what line we're on, then runs a simple algorythm against it to give us silver or white for the background color. Place this code in the Section Expert, under the Detail. Click on the Color tab, then the code button and post this in.

     

     

     

    Posted Oct 10 2007, 11:32 AM by Steve Gray with no comments