PC Review


Reply
Thread Tools Rate Thread

Crystal Reports .net text clipping problem

 
 
michele
Guest
Posts: n/a
 
      3rd Feb 2004
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


 
Reply With Quote
 
 
 
 
Philip Rieck
Guest
Posts: n/a
 
      3rd Feb 2004
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" <(E-Mail Removed)> wrote in message
newsuQTb.11893$(E-Mail Removed)...
> 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
>
>



 
Reply With Quote
 
Bob
Guest
Posts: n/a
 
      3rd Feb 2004
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" <(E-Mail Removed)> wrote in message
newsuQTb.11893$(E-Mail Removed)...
> 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


 
Reply With Quote
 
michele
Guest
Posts: n/a
 
      3rd Feb 2004
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" <(E-Mail Removed)> ha scritto nel messaggio
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> newsuQTb.11893$(E-Mail Removed)...
> > 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

>



 
Reply With Quote
 
michele
Guest
Posts: n/a
 
      3rd Feb 2004
....i've tryed it on different computers, but the problem still remains...

"Philip Rieck" <(E-Mail Removed)> ha scritto nel messaggio
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> newsuQTb.11893$(E-Mail Removed)...
> > 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
> >
> >

>
>



 
Reply With Quote
 
Bob
Guest
Posts: n/a
 
      3rd Feb 2004
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" <(E-Mail Removed)> wrote in message
news:P_QTb.10886$(E-Mail Removed)...
> 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.


 
Reply With Quote
 
Bob
Guest
Posts: n/a
 
      3rd Feb 2004
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" <(E-Mail Removed)> wrote in message
news:P_QTb.10886$(E-Mail Removed)...
> 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.


 
Reply With Quote
 
michele
Guest
Posts: n/a
 
      4th Feb 2004
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" <(E-Mail Removed)> ha scritto nel messaggio
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:P_QTb.10886$(E-Mail Removed)...
> > 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.

>



 
Reply With Quote
 
Bob
Guest
Posts: n/a
 
      4th Feb 2004
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" <(E-Mail Removed)> wrote in message
news:Ms8Ub.14308$(E-Mail Removed)...
> 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



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Crystal Reports export to text Liliputanac Microsoft VB .NET 7 30th Dec 2009 03:02 PM
Crystal Reports Does Not Display BLOB Field Correctly in IBlobField Control Using Crystal Reports for VS.NET 2003 Jeff Microsoft Dot NET 0 4th May 2006 09:21 PM
Problem with Crystal Reports schapopa Microsoft ASP .NET 3 26th Feb 2005 09:36 AM
Feed Text File Into Crystal Reports for .NET =?Utf-8?B?Y3JqdW5r?= Microsoft ASP .NET 1 17th Dec 2004 08:03 PM
Crystal Reports .net text clipping problem michele Microsoft Dot NET Framework 0 3rd Feb 2004 05:01 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:43 AM.