Report Builder Expression/Script Box Documentation

Hello Kwsthx ,

From what I have been able to find so far, Report Builder only supports the TemplateItems["Cell"].BackGround.Color method as shown in the examples in the shipping templates. I am checking to see if there are any other supported methods or attributes and will update this post with anything else I can find. 

Hi Howard, and thanks for the reply.

As a follow up or possibly alternative to the previous question, is there a way to display query results using SQL (or LINQ) into a custom report? I would like to use Report Builder and call the queries from a Script Box or Text Box expression, but documentation on Report objects is very limited.

I've used the MassHunter QA query option and have successfully written test queries, and I'm sure there are other ways to call/display the queries, but Report Builder has the added benefit of making other objects easily customizable.

Thanks in advance Howard!

Hi Howard, and thanks for the reply.

As a follow up or possibly alternative to the previous question, is there a way to display query results using SQL (or LINQ) into a custom report? I would like to use Report Builder and call the queries from a Script Box or Text Box expression, but documentation on Report objects is very limited.

I've used the MassHunter QA query option and have successfully written test queries, and I'm sure there are other ways to call/display the queries, but Report Builder has the added benefit of making other objects easily customizable.

Thanks in advance Howard!

Kwsthx ,

There is currently not a way to directly run SQL or LINQ queries in Report Builder. If you are not able to create a similar binding in Report Builder then you could investigate using the SDK and Python based reporting. While you cannot directly use SQL or LINQ queries in the Python reports, it should be possible to create a "SQL like" query in these reports.