Solved

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

Posted on 2010-09-08
2
3,347 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
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server Generate Scripts Fails 5 36
Convert formula to max at a specific date by month 18 22
Unable to Uninstall Visual Studio 2015 7 28
Tsql query 6 22
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
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.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

825 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