{"action":"created","issue":{"url":"https://api.github.com/repos/Microsoft/AL/issues/3378","repository_url":"https://api.github.com/repos/Microsoft/AL","labels_url":"https://api.github.com/repos/Microsoft/AL/issues/3378/labels{/name}","comments_url":"https://api.github.com/repos/Microsoft/AL/issues/3378/comments","events_url":"https://api.github.com/repos/Microsoft/AL/issues/3378/events","html_url":"https://github.com/Microsoft/AL/issues/3378","id":351990089,"node_id":"MDU6SXNzdWUzNTE5OTAwODk=","number":3378,"title":"Problem calling reports using task queues / scheduling","user":{"login":"FSharpCSharp","id":22373356,"node_id":"MDQ6VXNlcjIyMzczMzU2","avatar_url":"https://avatars1.githubusercontent.com/u/22373356?v=4","gravatar_id":"","url":"https://api.github.com/users/FSharpCSharp","html_url":"https://github.com/FSharpCSharp","followers_url":"https://api.github.com/users/FSharpCSharp/followers","following_url":"https://api.github.com/users/FSharpCSharp/following{/other_user}","gists_url":"https://api.github.com/users/FSharpCSharp/gists{/gist_id}","starred_url":"https://api.github.com/users/FSharpCSharp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/FSharpCSharp/subscriptions","organizations_url":"https://api.github.com/users/FSharpCSharp/orgs","repos_url":"https://api.github.com/users/FSharpCSharp/repos","events_url":"https://api.github.com/users/FSharpCSharp/events{/privacy}","received_events_url":"https://api.github.com/users/FSharpCSharp/received_events","type":"User","site_admin":false},"labels":[{"id":723436613,"node_id":"MDU6TGFiZWw3MjM0MzY2MTM=","url":"https://api.github.com/repos/Microsoft/AL/labels/investigate","name":"investigate","color":"fbca04","default":false}],"state":"open","locked":false,"assignee":{"login":"StanislawStempin","id":23653165,"node_id":"MDQ6VXNlcjIzNjUzMTY1","avatar_url":"https://avatars0.githubusercontent.com/u/23653165?v=4","gravatar_id":"","url":"https://api.github.com/users/StanislawStempin","html_url":"https://github.com/StanislawStempin","followers_url":"https://api.github.com/users/StanislawStempin/followers","following_url":"https://api.github.com/users/StanislawStempin/following{/other_user}","gists_url":"https://api.github.com/users/StanislawStempin/gists{/gist_id}","starred_url":"https://api.github.com/users/StanislawStempin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/StanislawStempin/subscriptions","organizations_url":"https://api.github.com/users/StanislawStempin/orgs","repos_url":"https://api.github.com/users/StanislawStempin/repos","events_url":"https://api.github.com/users/StanislawStempin/events{/privacy}","received_events_url":"https://api.github.com/users/StanislawStempin/received_events","type":"User","site_admin":false},"assignees":[{"login":"StanislawStempin","id":23653165,"node_id":"MDQ6VXNlcjIzNjUzMTY1","avatar_url":"https://avatars0.githubusercontent.com/u/23653165?v=4","gravatar_id":"","url":"https://api.github.com/users/StanislawStempin","html_url":"https://github.com/StanislawStempin","followers_url":"https://api.github.com/users/StanislawStempin/followers","following_url":"https://api.github.com/users/StanislawStempin/following{/other_user}","gists_url":"https://api.github.com/users/StanislawStempin/gists{/gist_id}","starred_url":"https://api.github.com/users/StanislawStempin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/StanislawStempin/subscriptions","organizations_url":"https://api.github.com/users/StanislawStempin/orgs","repos_url":"https://api.github.com/users/StanislawStempin/repos","events_url":"https://api.github.com/users/StanislawStempin/events{/privacy}","received_events_url":"https://api.github.com/users/StanislawStempin/received_events","type":"User","site_admin":false}],"milestone":null,"comments":6,"created_at":"2018-08-20T05:30:07Z","updated_at":"2018-11-07T15:46:25Z","closed_at":null,"author_association":"NONE","body":"We have a customer here for whom we wrote an extension. Within these, we offer the user the option of calling up a report dynamically. He or she can save the settings separately because the report is usually executed at night.\r\n\r\nHowever, we have identified a few problems that we do not see ourselves in a position to solve. This affects the execution sequence. If the customer executes a report from us, and we still have logic for initializing the request page in our report, then the planning settings are overwritten again. This is very unpleasant, because of course the result does not work. We have found a solution to this problem in our own reports. We have to ask within the RequestPage if we can use them. We can do this, for example, with the function \"UseRequestPage\". So we only have to execute the entire code if this option is \"True\".\r\n\r\nSo far so good. So we can intervene in our own reports. However, since we also use standard reports and cannot adapt them here, the archiving settings for these reports are repeatedly overwritten by the logic on the RequestPage, for example, and we cannot prevent it. The same applies to other settings that are overwritten by the program. Our customer is very angry here, because not all of his settings are applied, and the result is sometimes really different.\r\n\r\nSo I'm going to put my client's question here. When calling up a report via the task queue, would it not be possible to ensure that the request page logic does not overwrite the existing settings? In principle, one would only have to change the logic of the execution. First accept the options of the standard request page and then overwrite the desired parameters. So far, things have been going exactly the opposite way. In the on-premise world you have at least still the chance to intervene here, but that ends in the cloud world at the latest, because you don't get to the code positions here. So there must be some solution from Microsoft."},"comment":{"url":"https://api.github.com/repos/Microsoft/AL/issues/comments/436669058","html_url":"https://github.com/Microsoft/AL/issues/3378#issuecomment-436669058","issue_url":"https://api.github.com/repos/Microsoft/AL/issues/3378","id":436669058,"node_id":"MDEyOklzc3VlQ29tbWVudDQzNjY2OTA1OA==","user":{"login":"StanislawStempin","id":23653165,"node_id":"MDQ6VXNlcjIzNjUzMTY1","avatar_url":"https://avatars0.githubusercontent.com/u/23653165?v=4","gravatar_id":"","url":"https://api.github.com/users/StanislawStempin","html_url":"https://github.com/StanislawStempin","followers_url":"https://api.github.com/users/StanislawStempin/followers","following_url":"https://api.github.com/users/StanislawStempin/following{/other_user}","gists_url":"https://api.github.com/users/StanislawStempin/gists{/gist_id}","starred_url":"https://api.github.com/users/StanislawStempin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/StanislawStempin/subscriptions","organizations_url":"https://api.github.com/users/StanislawStempin/orgs","repos_url":"https://api.github.com/users/StanislawStempin/repos","events_url":"https://api.github.com/users/StanislawStempin/events{/privacy}","received_events_url":"https://api.github.com/users/StanislawStempin/received_events","type":"User","site_admin":false},"created_at":"2018-11-07T15:46:25Z","updated_at":"2018-11-07T15:46:25Z","author_association":"MEMBER","body":"Could you please provide sample AL code that works incorrectly? \r\n\r\nUsing the following code I could invoke the request page separately from running the report and the selected values were not overriden.\r\n\r\n```\r\npage 50100 RunReportOffline\r\n{\r\n    trigger OnOpenPage()\r\n    var\r\n        customerReport: report \"Customer - List\";\r\n        parameters: text;\r\n        outstr: OutStream;\r\n        savedReportFile: file;\r\n    begin\r\n        savedReportFile.Create('c:\\temp\\file.xml', TextEncoding::UTF8);\r\n        savedReportFile.CreateOutStream(outstr);\r\n        parameters := customerReport.RunRequestPage();\r\n        Clear(customerReport);\r\n        customerReport.SaveAs(parameters, ReportFormat::Xml, outstr);\r\n        savedReportFile.Close();\r\n    end;\r\n}\r\n```\r\n"}}
{"actor":{"display_login":"StanislawStempin"}}