11/25/2024 9:23:36 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss upgrading SalesLogix from version to version. View the code of conduct for posting guidelines.
|
|
|
|
Crystal Report Gotcha's
Posted: 14 Jan 09 10:39 AM
|
I wasn't sure if this should be in Reports or Upgrades, but since this issue appeared after an upgrade, here it is:
I recently upgraded a SLX LAN system from 5.2 to 7.5, which involves updating the connection method on all custom reports and saving them in the Crystal XI format.
I immediatley got a complaint that a certain customer form would not printing the address line. I tested the report, and it worked fine for me, so I asked for the specific record that was not printing properly.
It turns out this report contained a text box with text & databse fields in it. The Address line looked like this:
Address: {ADDRESS.ADDRESS1} {ADDRESS.ADDRESS2}
The record I did my first test with had a Suite No in address2. But I found that if address2 was null, the whole line was suppressed, and City/State appeared directly under the Account Name. I have not seen this before, Normally in this circumstance, a null would not be a problem.
The solution was to replace address2 with a formula field:
If isnull({ADDRESS.ADDRESS2}) then " " Else {ADDRESS.ADDRESS2}
Note the space in " ". If I used "" the whole line would be skipped. Appearently you need a space at the minimum for the line to print.
Are there other Report gotchas? |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|