Forum

This content is now out of date.

Visit Our Community

Data grouping generated odd SQL statement

I created a virtual table with a column for Contract_Expiry_days'. In the report builder, I selected the field and choose the option
'Group Data'. It failed to generate the results. I checked the generated SQL statement and notice a line inserted by YF. I highlighted the text in yellow. Any idea why?


Forum image
The error was because some of the rows in the computed column were empty. We resolved this issue by excluding those rows
The error was because some of the rows in the computed column were empty. We resolved this issue by excluding those rows
Hi Guest,

I'm glad to hear that you were able to solve this issue. I was testing this late last week and I wasn't running into the same problems that you were describing.

I'm happy to hear that you figured it all out.

Kind Regards,

Dustin

Thanks for trying Yellowfin

Please complete the form below to request your copy of Yellowfin today.