Convert Classic report to Cloud

[rhadall]

Hi

Has anyone had any success converting an on premise classic report for use in Cloud? I've got a report that we run which shows us the quarter and year that we are due to replace assets.

I've tried to recreate in Cloud as we want users to access through cloud primarily now but I can't work out the custom code to use.

Thanks

[Jacob_H]

Hey Rhad can you share the on-prem SQL query that you are trying to recreate (if you are still having issues)?  I'm not official support but maybe I can take a crack at it

[FrankSc]

Hi rhadall, 

The approach is indeed different. 

In general, we recommend using existing reports as a reference and "steel" some code from there.

Most AI engines also do a great job in creating good reports with correct syntax if you provide the correct fields to add and describe with wich conditions.