Jeremy Fredrich

Is there a way in ART to show the SQL to a user setup with a normal user role? Or can I create a new role where the user can view the report setup (SQL) but cannot create or change an existing report? I am on ART 6.22.

I am using ART 6.22 with a report type of "Update Statement". I have a report that uses 1 datasource parameter and 2 LOV parameters all chained. The fourth parameter is for the client to enter a varchar. I want to preload it so I created a LOV report and assigned it to the "Default Value Report" (chained). The value does not load. If I change the forth parameter to be a "LOV Report" (removing the "Default Value Report" value), the value is displayed but not editable. Am I doing something wrong?

Users are pasting in numbers with spaces. I want to prevent spaces and non-numeric data. I did get the following to work. var maskOptions = { regex: "\d*" };

Would you show me a simple example of using a mask on a parameter that only allows numbers?

I am using ART 6.22 with Oracle 19C. I have found that the conditional job types are running the report twice. I proved this by creating a simple function to call that will insert a timestamp into a table and return no results. When I execute the report manually, it works as expected (1 row inserted) and nothing returned. When I execute it from a job, 2 rows are inserted. I got around the issue by switching the job type to Email (Inline). Is there a work around for the conditional types?

That did the trick. Thanks!

Sure. It only is displaying column names to prove the issue.

I ran the same query as a Tabular report and it works fine. The horizontal scrollbars show up.