[Webinar] Learn how to a build a cloud-first strategyRegister Now


A subscript must be between 1 and the size of the array - Crsytal Reports 11

Posted on 2007-07-31
Medium Priority
Last Modified: 2011-10-03

I am getting the following error when I try to run a report, never this this before when I have run the report in the past, any ideas on what would be causing  it:

Errror = A subscript must be between 1 and the size of the array

And its happening on the formula: Split({MV_G_Staff_Payroll.title}, " ")[2]

Thanks in advance
Question by:patelajk
  • 2
LVL 77

Expert Comment

ID: 19599023
It means you have records where the title field does not contain a space. So index 2 does not exist.

Author Comment

ID: 19599224
do u know how i can find records with no space . as in have u got the sql.
LVL 77

Accepted Solution

peter57r earned 1000 total points
ID: 19599269
Create a formul field:
Ubound(Split({MV_G_Staff_Payroll.title}, " "))

Select records where this formula field is 1.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Integration Management Part 2
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses
Course of the Month20 days, 14 hours left to enroll

864 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