argument #2 of 'GridValueAt' is out of range
I am getting this error in my crosstab.
argument #2 of 'GridValueAt' is out of range
The crosstab is comparing pounds sold for an item in the years 2014 and 2013. looks like this
STORE #1 2013 2014
800JJ 3 4
801qq 5 6
STORE #2 2013
800FF 4
I guess the problem lies in there are no sales in 2014 for item 800FF, so no header for 2014, how would I fix that?
argument #2 of 'GridValueAt' is out of range
The crosstab is comparing pounds sold for an item in the years 2014 and 2013. looks like this
STORE #1 2013 2014
800JJ 3 4
801qq 5 6
STORE #2 2013
800FF 4
I guess the problem lies in there are no sales in 2014 for item 800FF, so no header for 2014, how would I fix that?
Last Comment
Where do you use the formula?
What formula are you using?
mlmcc
What formula are you using?
mlmcc
ASKER
i have a formula called dates that gets the date range.
I have a formula called Year which separates the dates into their respective years.
I am using the calculated member to get the difference between 2014 and 2013, and that is when I am getting the error.
I have a formula called Year which separates the dates into their respective years.
I am using the calculated member to get the difference between 2014 and 2013, and that is when I am getting the error.
The formula is used in the crosstab?
I don't have CR2008 on my machines at home. I will check it out at work
mlmcc
I don't have CR2008 on my machines at home. I will check it out at work
mlmcc
ASKER
Yes, this is in a crosstab.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Alright, that looks like it works. Had to add quote marks around 2014 and 2013 but it looks to work.
Thanks.
Thanks.
In my report they years were numbers so no " ". If yours are strings then the " " are needed.
mlmcc
mlmcc
Crystal Reports
Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.
36K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Not sure how to solve that. Will have experiment with the crosstab and some data like you have.
mlmcc