Solved

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

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

930 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now