Hi,

We’re using Cloud 23R2 and have a problem using the schedule option under Order Report for any SQL report.  It works fine from the Quick Reports page, just not from Order Report.

Nothing happens if the Schedule Report option is selected.  The log shows only this:

09:00:25 DEBUG - CMD(1): Execute ReportOverviewList_ScheduleReportCommand for 1 record(s).

09:00:25 DEBUG - CMD(1): if({"expression":{"==":={"var":"record.ReportType"},"SQL"]}})

09:00:25 DEBUG - CMD(1): > "TRUE"

09:00:25 DEBUG - CMD(1): navigate({"url":"assistant/${ClientName}/ScheduleSqlReport"})

09:00:26 DEBUG - CMD(1): > "OK"

09:00:26 DEBUG - CMD(1): if({"expression":{"==":={"var":"record.ReportType"},"QUERY_DESIGNER"]}})

09:00:26 DEBUG - CMD(1): > "FALSE"

09:00:26 DEBUG - CMD(1): navigate({"url":"assistant/${ClientName}/ScheduleReport"})

09:00:26 DEBUG - CMD(1): > "OK"

09:00:26 DEBUG - CMD(1): Done ReportOverviewList_ScheduleReportCommand.

There is no subsequent GET request.  It looks like it’s trying to navigate to an incorrect URL  "assistant/${ClientName}/ScheduleReport" immediately after the correct option which is "assistant/${ClientName}/ScheduleSqlReport".

We don’t want to give all users access to the Quick Reports page and without the Order Report option we can’t see another way for a user to request a report so that it is emailed to them.

Is this a known issue for SQL reports or have we missed something?

Many thanks!

MMck