Solved

Crystal Rpts - String length is less than 0 or not an integer when exporting report

Posted on 2010-09-08
2
3,399 Views
Last Modified: 2012-05-10
Good morning,

We have just designed a new report to pull information from our SQL database server. I am able to pull the information correctly by setting a period and refreshing.

Problem occurs when i try and export "all" of this report to PDF. It will start to export and reach about 11% of completion and then the below error will appear.

Crystal Reports - String length is less than 0 or not an integer when exporting report.

I have tried exporting just the first few pages and have been sucessful. But doing an export on all pages brings up this error.

Please advise how I can resolve this problem. Im a bit of a noob when it comes to crystal reports, so step by step help would be most appreciated.

Many Thanks.

Additional Information:

Using Crystal Reports Version 11.0.0.895
Using SQL 2000
0
Comment
Question by:ampike
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 11

Accepted Solution

by:
Larissa T earned 500 total points
ID: 33628695
somewhere in your sql you are using string functions that
does not have correct parameters or string is null

for example
declare @str varchar(10)
set @str ='123'
select substring(@str,  1,charindex('4',@str)-1)

Crystall does not like nulls in strings

Try to run query you use in Crystal in SQL and see result set
0
 

Author Closing Comment

by:ampike
ID: 33629288
Thats exactly what is was.

Thank you for the quick response and the help.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question