Reporting using variables getting error

[iam_mansoor]

Hi All,

Tried to include variables in the list report but got below error. Also checked the variables for the values which is not empty and not break/container.

Syntax Error or Access Rule Violation detected by database (Unknown column 'sc_item_option.value' in 'field list')

But though I can add around 25 variables into the list. Is there any restrictions with the count ?

Thanks in advance.

-Mansoor

[Kalaiarasan Pus]

Create a HI ticket.

[theman]

I also encountered this error "Unknown column 'sc_item_option.value'". I did a bunch of testing and discovered it wasn't specific fields or acl's causing the error , but it was a limitation on the number of variables columns that can be pulled into the report. The magic number is 29 variable fields maximum, then any number of actual table fields can be added to that 29.

[Julie Leung2]

Thank you @theman for figuring out the magic number and posting this.  It saved me a lot of time investigating, because I'm including in my report variables that have been made active=false, and I was concerned that that was causing the problem.  Your post helped me quickly confirm the real problem and not waste time chasing red herrings.  Thank you!

[Rob89]

This was very useful information and saved me from doing a lot of inclusion / exclusion of variables trying to determine whether a variable was breaking a List report.  I know this post is aging but thought it useful to others to advise my testing in Washington DC found the maximum number of variables that may be included in a List report is 28.