Fix for Field Overlap issues

[Former Member]

Post Author: vemi007

CA Forum: Publishing

Hi,

Is there a patch/fix available to prevent the field values NOT to overlap when the report is viewed using a Crystal Report Viewer. We are using RAS 11.

Our report designers designed the reports in such a way that they appear truncated but when a user who is viewing the report does a tooltip will see the full description, it works as intended in the crystal designer but not in report viewer after the report is published. If even selected "locl size and position" on the field as well as unchecked "Can Grow" option and still it does not work on the viewer.

Does anyone have/had the same issue.. can it be prevented or does a patch exist for this issue.

Thanks,

VRS

[Former Member]

Post Author: gouldjw

CA Forum: Publishing

Amazing! That worked like a dream for me. I didn't even need to restart any services! I just did a search through the registry for that key and set every instance I could find to "Yes". This issue had been occurring in both the DHTML and ActiveX viewers, and now it's gone!

Thanks for the great answer (no thanks to BO!).

--John GouldAvatar SoftwareNashville, TNwww.avatar-soft.com

[Former Member]

Post Author: mtv

CA Forum: Publishing

Unfortunately this does not appear to work for our situation since we are using the merge modules instead of a full installation of Crystal Reports/Business Objects Server. After a month of back and forth discussion, the best solution presented to us by B.O. support was to check 'can grow' with number of lines set to 1, and with respect to exporting to Excel, exporting 'data only' gets us the full values of the field, while losing column headers and other text from the report in the process. Here's to hoping they fix this bug so that it will work for all types of deployments with no special circumstances or hoop-jumping necessary.

[Former Member]

Post Author: myhat2u

CA Forum: Publishing

http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do;jsessionid=06517966F03974385...

It's a registry hack, and YOU MUST RE-BOOT the server after this!

For XI Release 1 deployments:

In both the HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 11.0\Crystal Reports\SavedData\ and the HKEY_CURRENT_USER\Software\Business Objects\Suite 11.0\Crystal Reports\SavedData\ keys, set the TruncateClippedFieldStrings key value to "Yes".

For XI Release 2 deployments:

In both the HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 11.5\Crystal Reports\SavedData\ and the HKEY_CURRENT_USER\Software\Business Objects\Suite 11.5\Crystal Reports\SavedData\ keys, set the TruncateClippedFieldStrings key value to "Yes".

After modifying the registry keys, perform the following steps to ensure that the Page Server and Report Application Server are running under a domain account:

Click Start > Programs > BusinessObjects 11 > BusinessObjects Enterprise > Central Configuration Manager. The Central Configuration Manager appears.

Right-click Crystal Reports Page Server and click Stop.

Right-click Crystal Reports Page Server and click Properties. The Crystal Reports Page Server Properties dialog box appears.

In the Log on as section of the Properties tab, clear the System Account check box and enter a valid domain account user and password. The user name should be in the format domain\user.

Click Apply then click OK.

Right-click Crystal Reports Page Server and click Start.

Repeat steps 2-6 for the Report Application Server.

[Former Member]

Post Author: myhat2u

CA Forum: Publishing

Out of desperation I e-mailed a North American salesperson at Business Objects the following:

"I feel the need to go outside of normal support channels for an issue I'm having with your software. Please go to: http://technicalsupport.businessobjects.com/cs/forums/11506/ShowThread.aspx#11506

for an explanation of the problem that I and others are having. Your normal support in India can't come up with a solution for this computer bug. I'm hoping someone on my side of the world can look at this."

Let's see what happens.

[Former Member]

Post Author: myhat2u

CA Forum: Publishing

This could be a problem for me then, as well. My users also export to Excel quite a lot.

I am current on service packs and the behavior is still there, but I don't know if any hot fixes since then will correct this. On another area of the businessobjects.com website I got the impression that this behavior is now considered "normal", even though it did not exist in Crystal Enterprise 8. My tech support call to India did not help... I was repeatedly told that I needed to correct this by using a formula and truncating characters, which is ridiculous.

Business Objects needs to recognize this as the software bug that it is and correct it!

[Former Member]

Post Author: gouldjw

CA Forum: Publishing

I hate to keep posting on this, but I don't think this solution is going to be acceptable to my client. The fields now look good on the web page, but when I export to Excel, which is very common for my users, the field values are completely cut off, so only what's displayed on the page is appearing in Excel. Before, the whole field was being exported correctly, but of course, in the viewer, we had the whole text overlap problem. Surely there must be a solution for this -- a hot fix or something?!

[Former Member]

Post Author: gouldjw

CA Forum: Publishing

Oops, never mind. I didn't see the solution until after I posted. I'll try the "can grow" thingy now.

[Former Member]

Post Author: gouldjw

CA Forum: Publishing

I am having the same issue. Have you found a fix for this or has BO support responded in any way? I'd love to use the new ActiveX viewer, but can't figure out how to do that without the Crystal Report Server, so DHTML is my only option. This formatting issue, though, is making that an unattractive option as well.

[Former Member]

Post Author: myhat2u

CA Forum: Publishing

No need for a patch, although I do consider this a bug even if Business Objects doesn't.

The fix is to check the "Can Grow" box for the offending field, then specify the maximum number of "grow" lines as one ("1"). I spent days on this with tech support in India and all they could recommend was that I create a formula that chops off X number of characters. That was time wasted. I found an obscure reference to something like this happening to a previous RAS version on the businessobjects.com website, and it looks like it applies to Business Objects Enterprise XI as well (that's what I'm working with, anyway).

Good luck to you if you're unfortunate enough to be getting "help" from India!

[Former Member]

Post Author: mtv

CA Forum: Publishing

We are experiencing the same difficulty with Crystal Reports XI Release 2. We have multiple reports with text fields that are designed to truncate which appear properly in the Crystal Report designer preview and in a PDF exported from the CrystalReportViewer .Net control, but overlap the adjacent fields when viewed in the CrystalReportViewer and also when printed using the ActiveX printmode option. We attempted the same solutions regarding 'lock size and position' and unchecking 'can grow' to no avail. Perhaps someone from Business Objects knows if this can actually be remedied or if a patch is currently being developed?