Skip to Content

Crystal Reports gridvalueat is out of range

I have a report that has two parameters (years) and if a user selects, for example, 2013 - 2015, then I have to make the report generate the yearly difference in each year. Since the only parameters are the begin year and end year, I have to do something for the middle year. The parameters are strings and when I try this to get the middle year, I get the "gridvalueat is out of range" error. The formula I'm using is:

GridValueAt(CurrentRowIndex, GetColumnPathIndexOf({?year2}), CurrentSummaryIndex) - GridValueAt(CurrentRowIndex, GetColumnPathIndexOf( Totext(tonumber({?year2}) - 1 ) ), CurrentSummaryIndex)

It's the GetColumnPathIndexOf( Totext(tonumber({?year2}) - 1 ) ) that's causing the error... Help, please?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 19, 2017 at 03:48 PM

    Hi Kenshin,

    Could you also attach a screenshot of where the difference columns have been inserted for each year in the Crosstab?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded