Multiple gridrowcolumnvalue Problem

[davisprogrammer]

Hi-

I have a long report I built in CR 11.5. I am now looking to upgrade that report to CR 2008 SP3. It is very weird, but i get the annoying "code unsupported" message when I try to run the report in the newer version of CR(I use SQL SERVER 2008 R2 btw). The report dies when it gets to my crosstabs. My crosstabs have two different row formulas, one column, and two summary fields. To format it, I use gridrowcolumnvalue three times since the data is very complex. This works grand in cr 11.5, but in CR 2008 it dies and I have no idea why. It always dies on the second gridrowcolumnvalue (even if I switch the order) so it seems like maybe you're only allowed to use gridrowcolumnvalue one time a formula now?
There's a snippet of code below. Thanks for your help.


If gridrowcolumnvalue("@FORMULA1") = {@Grades}
and gridrowcolumnvalue("@FORMULA2") = "Girls"
and gridrowcolumnvalue("@FORMULA3") = "Admin"
THen
... and so forth

 

[davisprogrammer]

Ok, on more investigation, it seems that I can't have a gridcolumnvalue() = a formula (like @grades) above. Is this not supported in CR 2008?

Thanks.

 

[lbass]

I would be surprised if that is the case. There is a known issue in opening earlier versions in CR2008 when there are crosstabs in report footers that make use of the formatting formula areas for manual running totals using variables, e.g., to force decimals in percentages. I've had to remove them and use CR2008 features--otherwise I get the 'Not supported' error.

On the other hand, I have used the formula areas in a report created in CR2008 without a problem, so I'm not sure whether it was the type of manual running total I was creating or whether it had something to do with actually creating it from scratch in CR2008 versus opening an existing report that already had the variables built in (not sure why that would matter). I haven't tested this carefully enough to say.

Anyway, I would first ask whether you are using any variables within the formatting formula areas, and if so, delete them and see if the report works. Then try rebuilding them or research the 2008 features that might accomplish the same thing.

If you are using variables in this way, I could try to find the reference in the SAP website for this issue.

-LB

 

[davisprogrammer]

Thanks LB. Yes, the formulas were doing analyses that weren't available in Cr 11 (not sure if they are now supported) and then the results were formatted depending on where the formula was in the table.

I'll go through and delete and redo and see if that helps.

 

[lbass]

What I was referring to was using variables in formatting formula areas for crosstabs in XI (which works in XI), but which results in "not supported" error messages in CR2008.

-LB