468,491 Members | 1,991 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,491 developers. It's quick & easy.

Crystal Reports .net text clipping problem

Hi, i have in my crystal report viewer .net a multiline field. When i
preview the report, the text in the field is clipped on the right, so some
words are invisible... i'm going mad; i've searched on the crystal decision
site but without success.
Please help me,
thanks
Michele
Nov 20 '05 #1
8 3536
We had an identical issue... yours may be caused by something else, but we
found that this had to do with the printer driver used. Apparently,
Crystal's engine uses some internal string measurement to wrap the words,
then uses the printer driver measurement to display them. Not much fun.

Another fun fact for us was that the difference was not the printer drivers
for the printer *used* to print out the report, but the drivers for the
default printer on that computer.

Good luck!

"michele" <ma********@oggiweb.com> wrote in message
news:Du*******************@twister1.libero.it...
Hi, i have in my crystal report viewer .net a multiline field. When i
preview the report, the text in the field is clipped on the right, so some
words are invisible... i'm going mad; i've searched on the crystal decision site but without success.
Please help me,
thanks
Michele

Nov 20 '05 #2
Bob
Crystal Reports has a couple of issues that may be contributing to your problem:

1. Blob fields are truncated under certain circumstances
2. Crystal is not WYSIWYG

First go for the simplest possible solution and make the field bigger to see if
the text shows up. If it is still missing you're looking at a truncation issue;
try casting the returned data as a different data type (text if its varchar,
varchar if its text) in your query and also take note of the character position
of the truncation. If it's 255 characters and nothing you do will fix it you
need to embed the truncated field into another by dragging and dropping it into
a blank text item. This is the official fix to a known bug in the full-blown
product, I don't know if it will work for the deisgner in .Net but my guess
chances are good. If that fails there is also a Crystal update to all .Net
components that was released some time after VS.Net 2003, you may or may not be
able to obtain it without a license from the Crystal website. If you manage to
manually download these components I think it's just a simple matter of
replacement and registration at the physical point of storage and in the GAC,
use Dependency Walker to help you with registration issues.

Bob

"michele" <ma********@oggiweb.com> wrote in message
news:Du*******************@twister1.libero.it...
Hi, i have in my crystal report viewer .net a multiline field. When i
preview the report, the text in the field is clipped on the right, so some
words are invisible... i'm going mad; i've searched on the crystal decision
site but without success.
Please help me,
thanks
Michele


Nov 20 '05 #3
Ok, now i try, but my problem occurs even with only one line of text:
for example

text "sette a
murare, placca" not showing

|

|
Pulsantiera completa di trasformatore, scheda elettronica, cassette a
murare, placca
1 o 2 tende separatamente.


"Bob" <no*****@nospam.net> ha scritto nel messaggio
news:OG**************@TK2MSFTNGP12.phx.gbl...
Crystal Reports has a couple of issues that may be contributing to your problem:
1. Blob fields are truncated under certain circumstances
2. Crystal is not WYSIWYG

First go for the simplest possible solution and make the field bigger to see if the text shows up. If it is still missing you're looking at a truncation issue; try casting the returned data as a different data type (text if its varchar, varchar if its text) in your query and also take note of the character position of the truncation. If it's 255 characters and nothing you do will fix it you need to embed the truncated field into another by dragging and dropping it into a blank text item. This is the official fix to a known bug in the full-blown product, I don't know if it will work for the deisgner in .Net but my guess chances are good. If that fails there is also a Crystal update to all .Net
components that was released some time after VS.Net 2003, you may or may not be able to obtain it without a license from the Crystal website. If you manage to manually download these components I think it's just a simple matter of
replacement and registration at the physical point of storage and in the GAC, use Dependency Walker to help you with registration issues.

Bob

"michele" <ma********@oggiweb.com> wrote in message
news:Du*******************@twister1.libero.it...
Hi, i have in my crystal report viewer .net a multiline field. When i
preview the report, the text in the field is clipped on the right, so some words are invisible... i'm going mad; i've searched on the crystal decision site but without success.
Please help me,
thanks
Michele

Nov 20 '05 #4
....i've tryed it on different computers, but the problem still remains...

"Philip Rieck" <st***@mckraken.com> ha scritto nel messaggio
news:Oj**************@tk2msftngp13.phx.gbl...
We had an identical issue... yours may be caused by something else, but we
found that this had to do with the printer driver used. Apparently,
Crystal's engine uses some internal string measurement to wrap the words,
then uses the printer driver measurement to display them. Not much fun.

Another fun fact for us was that the difference was not the printer drivers for the printer *used* to print out the report, but the drivers for the
default printer on that computer.

Good luck!

"michele" <ma********@oggiweb.com> wrote in message
news:Du*******************@twister1.libero.it...
Hi, i have in my crystal report viewer .net a multiline field. When i
preview the report, the text in the field is clipped on the right, so some words are invisible... i'm going mad; i've searched on the crystal

decision
site but without success.
Please help me,
thanks
Michele


Nov 20 '05 #5
Bob
Hmmm.

Make a new, simplified report to reproduce the issue and take note of when this
happens and when it doesn't. Is it only this field, or do you see the problem
with all fields of that data type? Does it matter where in the report the field
is located? Does it only happen when you have carriage returns in the data? What
does your query look like?

Bob
"michele" <ma********@oggiweb.com> wrote in message
news:P_********************@twister2.libero.it...
Ok, now i try, but my problem occurs even with only one line of text:
for example

text "sette a
murare, placca" not showing

|

|
Pulsantiera completa di trasformatore, scheda elettronica, cassette a
murare, placca
1 o 2 tende separatamente.


Nov 20 '05 #6
Bob
Also - I'm sure you've already done this, but in case you haven't, make sure the
field's 'can grow' property is set to true.

Bob

"michele" <ma********@oggiweb.com> wrote in message
news:P_********************@twister2.libero.it...
Ok, now i try, but my problem occurs even with only one line of text:
for example

text "sette a
murare, placca" not showing

|

|
Pulsantiera completa di trasformatore, scheda elettronica, cassette a
murare, placca
1 o 2 tende separatamente.


Nov 20 '05 #7
Yes! I've tryed to make a simplified report with only the problematic
field.. and it works... so how can i fix it in the complex report?
Thanks
Michele
"Bob" <no*****@nospam.net> ha scritto nel messaggio
news:uJ**************@TK2MSFTNGP10.phx.gbl...
Hmmm.

Make a new, simplified report to reproduce the issue and take note of when this happens and when it doesn't. Is it only this field, or do you see the problem with all fields of that data type? Does it matter where in the report the field is located? Does it only happen when you have carriage returns in the data? What does your query look like?

Bob
"michele" <ma********@oggiweb.com> wrote in message
news:P_********************@twister2.libero.it...
Ok, now i try, but my problem occurs even with only one line of text:
for example

text "sette a murare, placca" not showing

|

|
Pulsantiera completa di trasformatore, scheda elettronica, cassette a
murare, placca
1 o 2 tende separatamente.

Nov 20 '05 #8
Bob
If your simple report works yet the complex one does not, try adding to the
simple report until it breaks, or take away pieces of the complex report until
it works. It may take some work, but eventually you'll nail down the cause of
your problem. Let us know how it works out for you.

Bob

"michele" <ma********@oggiweb.com> wrote in message
news:Ms*******************@twister1.libero.it...
Yes! I've tryed to make a simplified report with only the problematic
field.. and it works... so how can i fix it in the complex report?
Thanks
Michele

Nov 20 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Stephan | last post: by
3 posts views Thread by Gheaci Maschl | last post: by
7 posts views Thread by p | last post: by
3 posts views Thread by Milan Todorovic | last post: by
17 posts views Thread by Peter Proost | last post: by
reply views Thread by Gilberto Avila | last post: by
6 posts views Thread by G. Stoynev | last post: by
3 posts views Thread by gieforce | last post: by
reply views Thread by theflame83 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.