Bootstrap

#Query Builder

Version 5.4.40

クエリービルダー 修正 – B3:E9999 は問題ありませんが、B3 などの単一セル オフセットが入力されると、システム Excel テーブルでデータセットの最後の数行が失われます。欠落している行の数は、開始行オフセットから 1 を引いた値と一致します。 スタジオ 修正 – テーブルのライトバック プロパティ「ライトバック URL パラメータ」が機能せず、入力した値が失[...続きを読む]

Version 5.4.36

クエリービルダー 追加 – 期間 フィルタリングと出力期間の両方の書式設定オプション。以前の期間では、常に年と期間番号を使用して書式設定されていました (例: 2022/009)。 1 年に 12 期間があると仮定して、月名を使用できるようになりました。会計年度開始を指定して、期間 1 を正しい月にマッピングすることもできます。たとえば、英国は 4 月開始なので、2022/001 は 2[...続きを読む]

Version 5.4.24

Query Builder Add – Filter option to return the description when filter on Value Lists instead of the code.  This is helpful when the code is not descriptive enough for the user or when displ[...続きを読む]

Version 5.4.22

Query Builder Fix – Company/Business level filters that reference filter mapping #[….] in Excel would raise a error when creating or editing Drill downs or Unions.

Version 5.4.18

Query Builder Add – Lookups are generally by default limited to 1000 rows but this can now be overridden by using the Change row limit checkbox.  Note the Change row limit will only show when[...続きを読む]

Version 5.4.10

Publisher Fix – Improved refresh list performanceAdd – Addition references tags to get Product attributes like Description, Author and Version e.g. {*Product.Description.<productCode>} or {*[...続きを読む]

Version 5.4.6

Site Setup Fix – License Check did not work on Remote Connections Studio Add – Schema – Import Value Lists Security Roles Fix – When Creating new Security Roles the initial field detai[...続きを読む]

Version 5.4.2

Form Designer Add - Data Type Encrypt Publisher Add – Security – Report menu with generates a report with all the security details of each published report.   This includes what us[...続きを読む]

Version 5.3.54

Security Roles Fix – Company or Business Unit security roles were being applied to all users instead of the target users and groups which means it was too strict.  Now only applies to the use[...続きを読む]

Version 5.3.52

Query Builder Fix – Sub Queries when combined with Reporting Rows would under rare cases not adjust their filters correctly if moving from a filter in list of more than two <<A,B,C &nbs[...続きを読む]

Version 5.3.42

Query Builder Fix – Drill Through did not respect output custom widths when set.Add – Expression can now reference the current product dictionary directly via tags instead of the Dictionary Functi[...続きを読む]

Version 5.3.32

Query Builder Fix – Filters with Sub Queries based on NOT IN logic !<in> worked correctly until there was only one item in the list and then it would set the where clause to equal that one i[...続きを読む]

Version 5.3.26

Query Builder Fix – Filters when set to Single would sometimes drop the << part of a multiple value filter list.  E.g. <<A,B,C upon reopening the queryAdd – Expression to calculat[...続きを読む]

Version 5.3.6

Query Builder Fix – Filtered Outputs and Dynamic Outputs did not work correctly on the SunSystems Ledger FilterFix – Filter Sub Queries that return no results when mainly dealing with Dates or Per[...続きを読む]

Version 5.2.132

Query Builder Add – Period offsets now have after offset support similar to dates Scheduler Fix – files path that used environment variables like %TEMP% did not always work. Web Chann[...続きを読む]

Version 5.2.128

JavaScript Fix - Lib_sys.rlContent.Post and Lib_sys.rlContent.Get timeout (millseconds) was not working and would always timeout after about 120 seconds.var timeout = (2700*1000);var =result [...続きを読む]

Version 5.2.124

Query Builder Add – Expression to create KPI Boxes with drill throughs and background images. See  HtmlKpiBox(<Title>,<Title CSS Style>,<Big Value>,<Big Label>,<Big[...続きを読む]

Version 5.2.106

Publisher Add – Themes has new setting to override the Title Colour.  Fix – Chart / Treemap height did not work. Scheduler Add – Default global Themes are applied when saving as qu[...続きを読む]

Version 5.2.102

Site Setup Add – Support for Azure AD Multifactor Authentication and Sign on Windows.  Note that if you cancel the Microsoft sign on window you can still sign in with the Sharperlight Window.[...続きを読む]

Version 5.2.93

Query Builder Fix – Sub Query filters using a in clause with two items would be resolved as a SQL between instead of a SQL IN.  e.g.  <in> A,B  <<A,B   If the [...続きを読む]