?
Solved

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

Posted on 2010-09-08
2
Medium Priority
?
3,595 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 2000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

650 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