?
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,507 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

770 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