| Access Rights: Roles and Database | As a fundamental design change to the Ad Hoc role based security model as it applies to object and column access rights, only the roles with an association to the related reporting database are considered. Roles without a database association are not considered in determining access rights for objects and columns. This is a departure from the original design of role-based security in Ad Hoc where a user would receive the permissions associated with all of their roles. The previous design demanded that all of the roles associated with a user have their access rights set the same for the user to actually be restricted from objects or columns. |
| API: Recompile Reports Function | A new function, RebuildReport, has been added to the API. This function will use the metadata information contained in the report definition to rebuild the full report definition. This functions purpose is similar to the new Manage Reports utility found in the Management Console. |
| API: Six New Functions | Six new functions have been added to the Ad Hoc API; GetReportsAndFolders(UserID), AddObjectAccess(ObjectID, RoleID), RemoveObjectAccess(ObjectID, RoleID), AddColumnAccess(ColumnID, RoleID), RemoveColumnAccess(ColumnID, RoleID), GenerateSynchPackageXMLFromAPI(xmlPkg, sMessage). The sample application (ahInterfaceSample) has been modified to demonstrate these functions. The API is documented on DevNet. In addition, the API specification is distributed with the Management Console and can be found in the ahInterfaceSample folder. |
| Archive: Auto-Archive Feature | The ability to automatically archive scheduled reports has been added. If this feature is enabled in the Instance Configuration / Archiving dialog for the reporting database, the archive option and format will be set in the scheduling page of Ad Hoc and disabled to prevent changes to the functionality. Existing schedules must be resaved to adopt this behavior. |
| Charts: Label Format | Resolved an issue with chart label format. If no format was specified, the report defintion was saved with 'None' and the chart was not rendered properly. |
| Charts: Missing Scaling Attributes | Resolved an issue where the attributes related to X-axis or Y-axis scaling were not shown on the chart tab after the chart dimensions were changed. |
| Dashboard: Defaulted to Mobile | Resolved an issue where all dashboard definitions stored in a database were considered mobile dashboards when executed. |
| Data Objects: Primary Data Object | The ability to identify a primary data object has been added to the modify Data Objects page. The Use as Primary Object checkbox indicates that the data object should appear in the initial list of data objects available for selection on the Modify Data Source dialog in the Report Builder. If unchecked, the data object will only be displayed in the Modify Data Source dialog when a related object has been selected. The default setting is 'checked'. |
| Export: Scheduled CSV Reports | Resolved a report caching issue with multiple scheduled CSV exports. |
| General: Color Slider Visualization | Resolved an issue where the visualization effect of the color slider on a data table was lost when the report also contained a pie chart. |
| General: Dialog Formats | Resolved various height and width issues with dialogs related to display of long column names and browser differences. |
| General: Unique Folder/Report Names | The ability to enforce unique folder and report names has been added to Ad Hoc. On the Configuration / Application Configuration / Application Settings page the Unique report/folder name attribute will enable this check. If the instance has duplicate reports or folders, the user will be prompted to rename the duplicates. |
| Grouping: Misaligned Aggregate Columns | Resolved an issue where aggregate columns on a grouped report would appear under the wrong columns when row numbers were enabled. |
| Install: Removed Unnecessary Files | Resolved an issue where the installation process created unnecessary folders and files. |
| MC: Import Procedures | The ability to import stored procedures and functions from Sql Server schemas has been added to the Management Console. The procedures are treated as Data Objects within Ad Hoc. The wizard may be launched from the Report Database Management action group or from the Configuration Wizard in the Management Console. The Management Console Usage Guide provides detailed information related to the import of stored procedures and functions. |
| MC: Report Management | A new utility has been added to the Management Console to manage report definitions. Under the Tools action group is the Report Management action that identifies and removes orphaned report definitions and provides a mechanism to recompile reports. When schema changes label a report as broken, this new function provides a global mechanism for the resaving of the report definitions. |
| MC: SMTP Test | The SMTP Test dialog in the Management Console / Instance Configuration / Emailing action has been modified to include both To and From addresses. |
| Parameters: Metadata changes | To support the new 'Stored Procedure' functionality, the metadata schema of the ObjectParameters table has been modified to include ParamType, ParamName, ParamCaption, ParamDataType and ParamDirection columns. |
| Report Bldr: Animated Charts / Crosstab | Three new animated charts, Animated Bar with Crosstab, Animated Line with Crosstab, and Animated Area with Crosstab, have been added to the Report Builder. |
| Report Bldr: Charts and Date Aggregation | Resolved an issue with the date aggregation on a chart setting the format for the x-axis label. The format should automatically be set to 'none'. |
| Report Bldr: Columns in Grouping | Resolved an issue with the grouping dialog not showing all of the available columns initially when using IE8 and Firefox. |
| Report Bldr: Drill Subreport Format | Added the ability to control the table width in the subreports of drill style reports. The Table Width attribute on the Table Settings tab of the Report Builder allows the user to enter a value and scale that will be applied to the subreports. Setting the value to 100 percent will allow the drill style reports to emulate the 'full page' behavior found in earlier editions of Ad Hoc. |
| Report Bldr: IS NULL on Primary Object | Resolved an issue where an 'OR IS NULL' clause was added to the generated WHERE clause for the primary object on Left and Right joins. |
| Report Bldr: Links in Charts | Resolved an issue where the enabled links in a pie chart would prevent the pie chart from rendering properly. |
| Report Bldr: Missing Record Counter | Resolved an issue where the record counter was not displayed in the report when there were multiple display elements or exports also included in the report definition. |
| Report Bldr: Modify Data Source in IE9 | Resolved an issue where the data preview on the Modify Data Source Dialog would shift the buttons down in IE9. |
| Report Bldr: Nested Session Tokens | Resolved an issue with nested session tokens not being resolved properly for validation or data previews. |
| Report Bldr: Paging at Top, Bottom, Both | Added the ability to position the interactive paging controls at the page top, bottom, or both. This attribute is found on the Table Settings and Crosstab Settings tabs of the Report Builder. |
| Report Bldr: Resize Data Selection Lists | Resolved various issues related to list selection boxes not resizing properly with long data values. |
| Scheduling: Calculated Col as Ask Param | Resolved a scheduling issue with a calculated column used as an ask parameter. On the scheduling page the selection list of values to be used to set the parameter value would not be from the correct column. |
| Security: Custom Column Right | The list of rights has been extended to include the 'Right to add custom columns to reports'. This right controls whether the user is permitted to use the new summary row calculation and the custom column features. By default this new right is only given to the System Administration permission. |
| Sync: Chart Linked Columns | Resolved an issue with chart labels used as links not being synchronized properly. |
| Sync: Report Dependencies | Resolved an issue with the synchronization process not identifying the report dependencies (objects, relationships) properly. |