Crystal Report truncating filter

Yahoo Archive
1
Thanks everyone for their suggestions, but the problem was very strange and needed a very weird solution. It must have something to do with the fact that the report parameter filter field is in an XML format and requires calculated fields to extract the information. Everything look fine in Crystal with the string returned by the calculation, but Vantage trimmed the first and last characters. My solution was to add a character to the front and end of the string in Crystal and then trim them off. The results should have been exactly the same as the string I started with, and in Crystal it looked the same, but for some strange reason it got rid of the problem in Vantage.




________________________________
From: dupuismd <mark@...>
To: vantage@yahoogroups.com
Sent: Wed, February 3, 2010 4:16:04 PM
Subject: [Vantage] Re: Crystal Report truncating filter

Â
Is the field on an edge of the report? Maybe printer margins are causing the problem. Try a different printer or to pdf.

MArk D

--- In vantage@yahoogroups .com, "Dines, Tim" <tdines@...> wrote:
>
> Are you sure that there is nothing overlapping the field in your report
> design? Also check to make sure you don't have a format that trims
> characters on the ends.
>
>
>
> Tim Dines
>
> Information Technology
>
> Steel Parts Manufacturing, Inc.
>
> 801 Berryman Pike
>
> Tipton, IN 46072
>
> Direct: 765-675-5201
>
> Cell: 765-437-1402
>
>
>
> From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
> Of Steven
> Sent: Wednesday, February 03, 2010 2:42 PM
> To: vantage@yahoogroups .com
> Subject: [Vantage] Crystal Report truncating filter
>
>
>
>
>
> Vantage 8.03.407A Progress
>
> I have a Crystal Report that can be filtered by Customer. In the report
> I have a calculated field that shows the Customer ID of the Filter. When
> I do a print preview in Crystal or browse the data in the field in
> Crystal I see the entire Customer ID (NB0389), but when Vantage prints
> out the report I see B038. It drops the first and last characters. Its
> not a problem with the size of the field, it is plenty large enough to
> accomedate 6 characters.
>
> Anyone have any ideas on whats going on here?
>
>
>
>
>
> [Non-text portions of this message have been removed]
>







[Non-text portions of this message have been removed]
2
Vantage 8.03.407A Progress

I have a Crystal Report that can be filtered by Customer. In the report I have a calculated field that shows the Customer ID of the Filter. When I do a print preview in Crystal or browse the data in the field in Crystal I see the entire Customer ID (NB0389), but when Vantage prints out the report I see B038. It drops the first and last characters. Its not a problem with the size of the field, it is plenty large enough to accomedate 6 characters.

Anyone have any ideas on whats going on here?
3
Are you sure that there is nothing overlapping the field in your report
design? Also check to make sure you don't have a format that trims
characters on the ends.



Tim Dines

Information Technology

Steel Parts Manufacturing, Inc.

801 Berryman Pike

Tipton, IN 46072

Direct: 765-675-5201

Cell: 765-437-1402



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Steven
Sent: Wednesday, February 03, 2010 2:42 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Report truncating filter





Vantage 8.03.407A Progress

I have a Crystal Report that can be filtered by Customer. In the report
I have a calculated field that shows the Customer ID of the Filter. When
I do a print preview in Crystal or browse the data in the field in
Crystal I see the entire Customer ID (NB0389), but when Vantage prints
out the report I see B038. It drops the first and last characters. Its
not a problem with the size of the field, it is plenty large enough to
accomedate 6 characters.

Anyone have any ideas on whats going on here?





[Non-text portions of this message have been removed]
4
Is the field on an edge of the report? Maybe printer margins are causing the problem. Try a different printer or to pdf.

MArk D

--- In vantage@yahoogroups.com, "Dines, Tim" <tdines@...> wrote:
>
> Are you sure that there is nothing overlapping the field in your report
> design? Also check to make sure you don't have a format that trims
> characters on the ends.
>
>
>
> Tim Dines
>
> Information Technology
>
> Steel Parts Manufacturing, Inc.
>
> 801 Berryman Pike
>
> Tipton, IN 46072
>
> Direct: 765-675-5201
>
> Cell: 765-437-1402
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Steven
> Sent: Wednesday, February 03, 2010 2:42 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal Report truncating filter
>
>
>
>
>
> Vantage 8.03.407A Progress
>
> I have a Crystal Report that can be filtered by Customer. In the report
> I have a calculated field that shows the Customer ID of the Filter. When
> I do a print preview in Crystal or browse the data in the field in
> Crystal I see the entire Customer ID (NB0389), but when Vantage prints
> out the report I see B038. It drops the first and last characters. Its
> not a problem with the size of the field, it is plenty large enough to
> accomedate 6 characters.
>
> Anyone have any ideas on whats going on here?
>
>
>
>
>
> [Non-text portions of this message have been removed]
>