cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Reports gridvalueat is out of range

former_member548403
Participant
0 Kudos

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Kenshin,

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

-Abhilash

former_member548403
Participant
0 Kudos

I actually took a different approach. Thanks for the comment, though!