Report Portal

• Ability to export OLAP, ROLAP, SQL and Dashboard reports to Excel XLSX format.
• Data Entry ability to save change history
• And much more. For more info click here.

• Firefox, Safari and Chrome support for all features
  
  
• OLAP Report
  • Calculated Field Dialog:
    • Enhanced Calculated Measure Builder
    • Locale option for SSAS 2005+
    • Solve order of calculated members
    • The ability to specify the calculated member on any dimension (not only measures)
    • Ability to specify the parent for non-measure calculated members
    • Ability to use a saved Name-Set to a create calculated member using the Aggregate function
    • Ability to save private Named-Set or calculated members visible to users who has created them
    • Data bars and Color Gradient Wizard
    • Advanced MDX Wizard
    • Advanced KPI Wizard
    • KPI wizard: non-empty cross join option
    • Calculated Member dialog - New formats: currency, #,#0.00 and #,#0.000
    • Calculated filed: Additional formatting: 0.00 and 0.000
  • Filters:
    • Calculations for Time Dimension Filter
    • Date Dimension function are improved by using MeasureGroupMeasures() and Measures.Members functions
    • New Date Formula: Previous [Level] previous [Parent Level]. Example: What was the profit for the previous month last year?
    • Trailing 12 months will show the months expanded (instead of aggregating them) when the dimension is on rows or columns
    • Ability to use a named-set as a filter
    • Multi select member "Milti" variable can now be changed in global OLAP Settings. This is useful when a dimension has a member with "Milti" id.
    • Multi-Select filter will show small 45 chars and up to three members instead of Multi-select
    • Calendar date picker Today button will select the most recent date with data that is not in the future
    • Filter Search: Option to reset or add to the current selection
    • Filter Search - Case sensitive checkbox
    • Filter Search - Show complete hierarchy of the member in the search results
  • Field List:
    • Ability to drag a dimension to add the default hierarchy for the dimension
    • Ability to right click on named-set or a calculated measure to edit or delete
    • Option to disable field list scrolling
    • Right Click to add to rows, columns or filter
    • Ability to drag attributes to measures for SSAS 2005+
    • Field List will sort Measure Group and Measures when this option is enabled: Admin > Settings > OLAP Report > Field List > Sort Field List alphabetically
    • Allow dragging of Measures, Hierarchies and Levels to the first position.
  • Charting:
    • Dual Axis Chart: min and max
    • Flash Chart: When the Language is Spanish the following number scaling convention will be used 'M,MM,MMM' (instead of ?K,M,B?)
    • Flash Chart Options
    • X and Y Axes labels will show hierarchy names
    • Option to show filters in the report subtitle
    • Option to show the report name in the report title
    • Chart background
    • Ability to hide chart Canvas
    • Number of horizontal lines can be changed
    • Ability to show the Legend at the bottom of the chart
    • Geo Chart Export will now bypass Popup blocker in IE Internet zone
    • Charting:
    • New Dual Line chart
    • "Rotate Labels" and "Slant Labels" is moved to Labels select box that also has Stagger, Wrap and ?None? options
    • Separator option - decimal and thousands separator
    • Scale - $15K vs. $15,000
    • Decimals - from 0 to 10
    • Force Decimals option (from 1.1 to 1.10)
    • When a dual axis chart is picked some duplicate option will be available: Prefix, Separator, Scale and Decimals
    • New chart options: X,Y Axis Labels - unchecked by default. Global settings can be changes by going to Admin > Settings > OLAP Report
    • Design Mode - Chart border is removed
    • Chart/Grid position toolbar button
  • Options:
    • Option to use Hierarchize MDX function
    • Options > Alternate Cell Color
    • Options > Expand table to 100%
    • Options > Dimensions tab > Range - for non-date picker (Useful for year to year or Month to Month)
    • Options > Dimensions tab > Sorting - for columns
    • New "Server Side execution" option useful when returning a large (500+) result set. This option is available via options dialog and via Stop-Go dialog that shows up when "Maximum Rows" number is exceeded.
    • "Row count warning" dialog will now check the column count (as well as the row count) and show the option to Top-100
    • Options > Show Measure Info - will show a definition of a measure based on a description in SSAS cube
    • Options > Summary: Sum will ignore child records and avg, min and Max will ignore parent records to avoid duplication
  • Conditional Formatting:
    • Data bars and Color Gradient
    • Data Bars. Size of the bar will depend on the size of the value.
    • Color Gradient. Color of the cell will depend on the size of the value.
    • When adding conditional formatting the newly added item will be selected
    • Conditional formatting for Gradient and Data bar types now supports negative numbers
  • Exporting:
    • CSV exporting
    • Ability to suppress the display of filter selections on PDF reports
    • PDF Export support for non-Latin fonts including Cyrillic, Chinese, Korean, Japanese, Thai, Arabic
  • Analyze:
    • Analyze in new window feature will copy only the selected measure
    • Analyze > New Window > Copy All Measures option
    • Analyze Dialog: Group by dimensions
    • Analyze Dialog: Hierarchies are grouped into dimensions
  • Themes :
    • Ability to apply Themes in design mode (Excel 2007 Style)
    • Pick theme toolbar icon can be made available in view mode and via admin > settings and report options.
  • OLAP Other:
    • Top N - Ability to create Top-N filter based on a column instead of a measure
    • Ability to add Filter description to the report description
    • In design mode when MDX is clicked and a report is opened the report is not executed and MDX panel stays open.
    • Enable Server formatting is now a global OLAP setting
    • Ability to right click to Rename measure and Dimension in the header
    • OLAP Cube Localization (SSAS 2005+) will be based on user Language settings.
    • Drillthough: Size will be remembered for each user
    • Abort action will also stop query on Analysis Services Server 2005 and up
    • Schedule toolbar button
    • Ability to display measure without a dimension selected on rows
    • Stop/Go over N rows/columns dialog will show the number of rows/columns
  
  
• Pie chart tree Report
  • Ability to scroll
  • Popup Dialog - Hierarchies are grouped into dimensions.
  
  
• Bar chart tree Report
  • Options > Chart tab > Format
  • Popup Dialog - Hierarchies are grouped into dimensions.
  
  
• New Report Type: Chart Grid
  • Drilldown support
  • Minimum height and width options
  
  
• Bubble Chart Report
  • Ability to select parent levels for the time slider via options dialog
  • New images for Play and Stop buttons
  • Bubble & Tree map Report: Ability to export data grid to excel
  
  
• OWC Report
  • Context Menu for Actions, Comments and Drillthough
  • Chart width, height, hide pivot table
  • MSOLAP provider will be picked automatically (Provider=MSOLAP.3 or MSOLAP.4)
  • Default connection type is changed to HTTP for SSAS 2005+
  • Options > Chart Colors
  
  
• KPI 2005
  • Show the full path of the target report
  • ?Go Back? link when a KPI is clicked
  
  
• KPI Report
  • Formatting will be derived from base report
  • Comment icon will be hidden when no comments
  • Go Back link for the target report
  • Improved KPI Report performance made possible by calling each OLAP report only
  
  
• Dashboard Report:
  • New option to add report option to an empty group
  • Sub-report names will be updated when the underlying report name changes
  • Dashboard Report will not show deleted sub-reports or reports user does not have access to.
  • Add New Tab removed from view mode
  • When entering design mode used is given option to: Create New Report or Open existing report
  • Ability to export to PDF (OLAP and SQL reports only)
  • Tab Options - possible number of groups is increased to 10
  • Refresh Rate option
  • Theme Picker
  • Filter selection can now exceed 2083 characters
  • Excel export: SQL sub-report with paging will export all pages
  • Ability to export report with user theme
  • PDF Export > Separate pages options will place each sub-report into a separate page
  • Dashboard report will now apply filters to a sub-report even when sub-report does not have the filters defined. This feature used to work only when sub-report was an OLAP report.
  
  
• ROLAP Report
  • New Option to hide records with no name
  • Easy way to add Degenerated Dimension
  • Sybase support
  • Support for calculated measure like: sum(p.total - p.internal_total_cost) / sum(nullif(p.total, 0)) as gross_margin
  
  
• Crystal report options
  • Crystal report options
  • ?Run on Load?.
  • Filter Columns
  • Label Setting
  
  
• Reporting Services
  • 2008 is now supported
  • Improved performance for displaying many reports
  • link to Report Builder
  • Support for Multiple parameters
  • New "Build URL" Button
  
  
• SQL Report
  • New report options:
    • Option to Run on Load when filters present
    • Option to specify number of "filter columns"
    • Option for label position (Let or Top)
    • Option to Freeze/Unfreeze header
    • Column formatting
    • Multiple result sets
  • Filter Enhancements:
    • Ability to use Default Value as an SQL Expression
    • New Filter Types (Date Picker, Compo, Combo Suggest, DB Lookup or Radio buttons)
    • New List Types: SQL, Table or Manual
    • List, Combo and Radio button filter types support "Manual" (not sourced for the database) List type
    • Ability to specify if a filter is Required
    • Ability to specify "Not Selected Label" for a filter
    • Textbox Mask
    • Filter Width
    • Yes/No value for checkbox
    • Toggle Filters (hide/show)
    • Filter SQL Builder > Default value expression help (visible only when Expression is checked)
    • SQL/Crystal Report > Filters > List Type > Shared. The shared filter SQL can be defined by going to: Admin > Shared Filter
    • In the filter designer, a filters dropdown can be used when report has more than one filter
    • Paging is reset to page 1 whenever a filter change occurs
  • SQL Report - Other:
    • Ability to sort results returned by a stored procedure
    • Clicking on a column multiple times will sort table in Ascending, Descending and No order
    • "Number of rows per page" is now saved with the report settings
    • Save button to be always visible
    • SQL Template-based Report in the view mode can be changed saved into a private folder
    • Hide chart when grid has no data
    • Chart: ?Switch axis? option
    • CSV exporting
    • SQL Builder (SQL Report, SQL Template Based report & OLAP Report) better keywords (like [Rule]) handling
    • Schedule toolbar button
    • SQL Template report: New ability to Group by Date part
  
  
• Data Entry
  • SQL based list provides a way to create a list what would depend on another list. For example, Cities list can depend on Country list selection. https://www.reportportal.com/flash/DataEntry_Depend.htm
  • Ability to see the bread crumb trail and use "go back" button to go to the previous form
  • Data Grid view will show binary image column
  • Ability to link a field to another data Entry forms. This link can be defined using the "Child Data Entry forms" panel (parent type).
  • Data Entry Validation form can use second connection
  • Enhanced binary image column support (ability to delete, etc.)
  • Search results stay within the left navigational panel
  • Date Format is now independent of the database date format
  • Ability to edit multiple records in data grid
  • Ability to add description at the top or the bottom of a Layout Panel
  • Default value expression help (visible only when Expression is checked)
  • New Column option: Apply Date Mask (for date type column only)
  • General Option: Search column
  • Grid Edit mode will update only changed records
  • New Data Entry form's name will default to the table name
  • Design mode, File type - File Name Column list will exclude itself from the list
  • Column Image type: Size (Height and Width)
  • Ability to have editable grid without an id column visible
  • Search will effect grid
  • Ability to select views for editing when Admin > SQL Report > Show Views is checked
  • Ability add a read-only Computed Column. For example Full_Name = First_name + ' ' + Last_Name
  • MySQL: Ability to use binary data type as text
  • Grid will use Theme
  
  
• Blog Report
  • New Blog Report Type
  • Blog > Subscribing to changes
  • Blog > Ability to place Report link, Report frame, Folder frame or an image.
  
  
• Wiki Report
  • New Wiki Report
  • Ability to create an HTML page using online HTML editor
  • Ability to place Report link, Report frame, Folder frame, filter frame or an image.
  • Allow other user modify and see the version history
  • Ability to draw simple shapes and arrow on top of an image
  • Height of the editor as height as the screen
  • Compare: During version comparison, ability to click on a left or right version
  • Wiki and Blog: rating widget for the HTML editor
  
  
• Hyperlink Report
  • Hyperlink Report
  • Hyperlink Report will update the link to file share from "\\" to File://
  • Hyperlink & File Upload > Icon Type
  
  
• Admin > Settings:
  • Site Settings > Date format to be used for Scheduler and Report Security admin pages
  • Site Settings > Date Format - will now work when database date format is different from application date format
  • Site Settings > Preload Phrases (faster but takes more server memory)
  • Security > Security Token > new option: Pass-though authentication
  • Security > Pass-through authentication: When NT password is not set group windows user name and password will be used
  • Security > Allow Role Connection updating - will hide/show the Connection tab under Admin > Roles
  • Security > Security Authentication Mode (Test) is improved
  • Security > Security Token > Pass-through authentication (For better SharePoint Integrations)
  • Security > Security Authentication Mode = Windows performance and security improvements
  • Report Tree > Sorting > Manual/Alphabetical
  • Report Tree > Default Report Id > ability to select folders
  • Report Tree > ?Show Private Reports on top? is changed to "My Reports" (Top, Bottom and None)
  • Report Tree > Reset Manual Sorting button
  • Report Tree > Inherit Parent permissions
  • Report Tree: Cache will be deleted when "Make forbidden reports visible" option is changed
  • OLAP Report > Click second time to bypass download blocking. Improved.
  • OLAP Report > Viewer Editing > Now unchecked by default
  • OLAP Report > Other > Cell double click will open first drill though action
  • OLAP Report > Current Date Formula Type = [Name | ID]
  • OLAP Report > Field List > Width
  • OLAP Report > Date Format - default format used in OLAP Report > Options > Dimension tab > Filter is date picker > Date Format
  • OLAP Report> Date Calculations - Calculated measures option
  • OLAP Report > New option for ?Time Dimension - Current Day? called: ?Last member that has value for selected measures?
  • OLAP > Time Dimension - Current Day = (None, Last member, "Last member that has value for any of the measures" or Formula)
  • Ratings > Show comments on the bottom of a report (applies to OWC, KPI and KPI 2005)
  • Ratings > Disable Favorite reports - when unchecked (unchecked by default) each user will the ability to add a report to Report favorites (starred) report that is visible only to that user
  • Password > Password expiration Warning
  • Password > Forgot password
  • Reporting Services > Version
  • Reporting Services > Authentication > Forms Authentication Support
  • New Header and Site Title Options
  • Login > Remember me on this computer
  • Version link e. SQL Report > Culture (Effects date and number formatting for SQL, ROLAP and Blog reports)
  • Email > Use IIS Pickup Directory - new option (Checked by default)
  • OWC > PTS (OLAP OLEDB Provider) Checking
  • Email. New options for User ID, Password, Port Number and to send test email.
  • OLAP Report: Exporting - Localize Excel Exporting option based on the browser locale
  • Password > Password expiration Warning
  • File > Max File Size (in MB)
  
  
• Admin > Connection:
  • XMLA Connection > Properties
  • Connection Timeout
  • New Connection Type: Reporting Services
  • XMLA Connection Type > Locale Identifier
  • XMLA Type > Build button is removed
  • New Disable button
  • Show number of report for the each connection
  • Mask password
  • Selecting a checkbox should select the connection if no other connection is selected
  • Admin now has the ability to change Connection Disabled text by clicking on edit icon next to the message.
  • Show reports for connection by click on he number of the port next to each connection
  • The password will not be hidden when the Database Type is ?Other?.
  • Select Driver for MySQL Driver (3.51 or 5.1)
  
  
• Admin > Role:
  • Ability to expand a role to see users
  • Ability to set Default Report Id
  • Available-Selected Connections tab
  • Lookup Windows Group
  • Ability to resize Available/Selected Users boxes
  
  
• Admin > Themes and Styles
  • Preview Section
  • Edit: ability to Import or Export Themes in XML format
  • 12 Themes
  • Edit > Reset All
  
  
• Admin - Other
  • Admin > Synch Users - adds user email
  • Admin > Synch users: arrange users alphabetically as Full Name (username)
  • Admin > ROLAP cube designer
  • Dimensions that do not have Join Columns set will be excluded from the Field List
  • Warning to delete Cube
  • Admin > Chart Color Palettes - new color templates
  • Admin > Filters > Ability to see reports used by the filters
  
  
• Admin > DB Admin
  • For SSRS, shows report properties, XML schema and connection info
  • For OLAP connections, shows cube schema definition and the dimensional data
  • OLAP connection > Each Database will now show "Sessions" - MDX queries currently running for Analysis Services Server 2005 and up and will provide the ability to stop them
  • OLAP metadata can be exported to Excel
  • Warning that hierarchy cardinality is very large
  • For SQL database:
    • Shows a tree map of a database to see which tables have data and how much
    • Shows Distinct count of a column to identify the dimensional cardinality
    • Shows Check Constraints
    • Shows Security (Tables, View, Columns, Functions, Stored Procedures)
    • Shows Statistics
    • Shows Sessions
    • Shows Index Usage
    • Shows Unique Constraints
    • Shows Database Properties: New info Date Created/Restored, Etc.
    • Supports export and import of table data
    • Allows an administrator to create, modify and delete: users, databases, tables, indexes, foreign relationship constraints, view, stored procedures, triggers and functions.
  
  
• Scheduler:
  • Unsubscribe feature (Admin > Email Template > Variables > ::Unsubscribe)
  • HTML Content Type and HTML Delivery type will show the report within email body.
  • Warning when Effective Date and Expiration Date are the same.
  • Ability to delete Lob Log
  • Ability to manage private subscriptions
  • Ability to expand Schedule to see and select jobs
  • New "Snapshot" Delivery type
  • More efficient way to run reports: Report will be executed only once if all users receive identical report without any security applied
  • URL Trigger VBS script
  • Style Theme can now be applied to Excel, PDF or HTML content type based on report or the receiving user theme setting.
  • Email will not be sent when the report has no data.
  • Better error description
  • Users list will exclude users that do not have emails set
  • PDF Export/Scheduler is limited to 1 GB size limit
  
  
• Report Tree:
  • Expand All will not expand Admin "My Reports" folder visible to admin users
  • Ability to delete folder that contains reports and subfolders for admin and writer users
  • Search capability
  • Report Search by Ratings, Comments and by Subscriptions
  • Right Click on a folder to get a URL to the folder contents. This can be used for URL SDK and the Dashboard.
  • Right click on any report in the view mode to design it (given you have permissions)
  • Right click on any report and select Hyperlink. The new dialog now lets you hide toolbar, filters, etc.
  • Right click on a folder to export OLAP and SQL reports to one PDF file (OLAP and SQL reports only)
  • Ability to right click in the white space below all reports to add a root folder (available to admin and writer users only)
  • Ability to click on a folder to see details of reports in that folder
  • Right click on folder: PDF will show only in view mode
  • Ability to right click on Snapshot to rename or delete it
  • Right click on SSRS report to view, add and delete snapshots
  • Import Report feature will allow updating
  • Copy Report: "Copy as Link" Option
  • Report Tree remembers expanded folders and scroll position
  
  
• Report Usage:
  • Now records execution End time
  • New usage reports: Current Users and Performance
  • New Usage Report: 7 most recent reports
  
  
• Other
  • Application is now optimized to be used by the Session State Server (see Web.config > sessionState setting). This can be useful for web farming. This is also useful for preventing users sessions form being lost when application pool gets reset or IIS is restarted.
  • PDF Export: margin is set to blank by default
  • Show Filter Empty behavior for Pie, Bar, Bubble, Dashboard and Tree Map reports will now depend on Application setting (Admin > settings > OLAP report > Show Filter empty items)
  • New Content Type for the Email Report feature: HTML (Email Body). This option allows for the report to be embedded inside of email. This feature is available for: OLAP, SQL, KPI, Pie-chart, Bar-chart, Tree-map, KPI-2005, ROLAP and SQL template based report types.
  • Design Menu is now organized into sub-menus (which can be managed by Admin > Selected report Types)
  • Report Comments: Ability to reply to a comment. The user replying to a comment automatically generates an email to author of the original comment.
  • User Security tokens (::UserId, ::UserName, ::NtUserId and ::Email) in User Filter Value
  • Export to Excel: file name will have underline(_) instead of space
  • Toolbar is changed to light blue background for most reports
  • An indication (a green pushpin with a note icon) that a report comment exists. Mouse over will show number of comments for the report.
  • Themes and Styles: FilterTable (and FilterTable INPUT) class will control the background color of the filter box
  • Login Attempts to always log data when the Usage Report option is on
  • In view mode, user who has edit access can now save the report in its original folder
  • Ability to send an email without saving report
  • Support for Vista, Windows 7 and Windows Server 2008
  • Localization: Unicode support
  • Improved Localization
  • A non-admin user can now right click and edit his/her reports
  • Design > Other > Manage Reports - ability to delete copy and move multiple reports or folders
  • Ability to save report in the view mode for non-admin to another public folder the user has publish access to
  • Multi-Language support for PDF exporting for subscriptions and dashboard
  • New API stored procedure to be used for Single Sign-On: GetSecurityTokenForUserPassword 'admin', 'password'
  • Save Report Dialog to ?Add Report? will be enabled when an exiting report is selected. The new report will be saved in the same folder as the selected report.
  • Security: Ability for an admin user to save report to a private folder

On January 23, Microsoft announced that it will discontinue offering standalone versions of PerformancePoint Server, its integrated performance management product. As part of that announcement Microsoft announced it will also stop selling the Proclarity Pro product which will have no future versions. When that occurs, there will no longer a dedicated Business Intelligence product; instead, Microsoft will simply offer BI as a set of services among others in Microsoft Office and SharePoint. With Microsoft?s shift to providing BI within Office and SharePoint, users will be able to accomplish only a limited range of analysis. However, ReportPortal offers full enterprise BI functionality in a single, complete and integrated suite that surpasses the basic capabilities to be found in Office or SharePoint.

XMLA Consulting Inc. is offering a special promotion for ProClarity customers looking to migrate to ReportPortal. Details can be received by emailing to sales@ReportPortal.com. The company is also providing complete technical assistance to users wishing to migrate to ReportPortal product.

• New Report Type: Moving Bubble
• New Report Type: Data Entry form
• .NET Framework 2.0 support
• SQL Server 2008 support
  
  
• OLAP Report
  • New chart options:
    • Round Edges
    • Ability to specify the data column for single column charts (Pie, Doughnut and Geo charts)
    • Bar Chart 2D, Bar Chart 2D, Horizontal Bar Chart 2D - ability to see bar label when only one measure is selected
    • Percent will be translated from decimal to 100 for Flash chart
    • Show empty as zero
    • Geo Map: Untargeted Bubble Chart (XML based; not currently exposed via UI)
    • Flash chart: expand width to 100%
    • ability to add prefix ($) or suffix(%) next to the value
    • Min and Max for Flash Chart
    • Funnel Chart
    • Geo Map - Enhanced chart selection dialog
    • Improved Geo UI Interface
    • Slant Labels
    • Right click on Geo Maps to export Map as image (OLAP Report)
    • Export Flash Chart via Right Click
    • Ability to switch chart axis
    • Decimal Value Formatting is set to 2
    • Ability to hide a row or change its color for a chart (right-click on the legend color - the option dialog will appear)
    • PDF Export for Flash Chart and MAP Chart
  • Drillthough:
    • Selected-Available for measures and attributes
    • Ability to order selected measures and attributes
    • Save Drillthough selection for a user
    • Show All columns option (SSAS 2005 only)
    • Context menu will be hidden when drillthough is disabled for the cube
    • Drill-through for multi-selected filters
  • New Application option:
    • hide empty
    • show calculated members
    • Export Excel ? popup blocker can be bypassed by clicking the export button again
    • to disable the Excel chart exporting
    • to turn paging on
  • Report option:
    • Not symmetrical option (Option > uncheck :Asymmetrical Expand") will force the duplicate rows to be merged (not just the first hierarchy)
    • to put Parent on the bottom in the expand mode (Hierarchize - POST option)
    • to have the field list open when opening an OLAP Report in view mode
    • to show MDX button in the view mode
    • Non Empty options icons
  • Top-N feature to have NonEmptyCrossjoin opton for Bottom N feature to exclude empty items
  • Cell context (Right click) menu. The menu provides the ability to analyze cell value using Pie-Tree, Bar-Tree, Tree-Map, Moving bubble chart or another OLAP report.
  • three toolbar buttons (Properties and Actions, Comments and Drillthough) are moved to the Cell context menu.
  • Add Percent - Non empty cross join option
  • Ability to see measure, hierarchy and level description in the field list on mouse over
  • Cell Comments - Date, Time and User
  • Sparklines
  • ?Add Percent? feature will default to the first selected dimension on rows
  • New ?OLAP connection? dialog: tree view style
  • Export Excel ? popup blocker can bypassed by clicking the export button again
  • Date Range Filter (accessible via Options > Dimension > Check Range and Filter is date picker)
  • Dim Search Dialog in Multi-Select mode. Ability to select multiple results by shift-click
  • Multi-dimensional named-sets are now supported
  • Ability to Editing Reports in the view mode if you are an editor
  
  
• Security:
  • Ability for an admin user to save report to a private folder
  • User Admin: Ability to resize Available/Selected Roles boxes
  • Roles Admin: Ability to resize Available/Selected Users boxes
  • Security Dialog: Ability to resize width
  • URL SDK: ability to login a user to ReportPortal with a token passed via the Query String
  • Pass-through Authentication can now work in conjunction with Windows and Mixed Security Authentication Modes. When Windows authentication is enabled on the login.aspx page, the application will prompt and save the user Windows password the very first time.
  • URL Integration SDK: Ability to login to ReportPortal from an external application using a Security token passed as a cookie
  • Ability to add/update a ReportPortal user from an external application using UpdateAppUser stored procedure
  • Support for Windows authentication. (Application > Settings > Security Authentication Mode). Mixed mode is also supported.
  • New Application Security Options (Admin > Settings > Password)
    • Maximum password length option
    • User must change of password at first login option
    • Password expiration option
    • Password history option ? to prevent users form reusing passwords
    • Block after N failed attempts option and the ability to unlock user via admin user page.
  
  
• Admin
  • Schema caching (Admin> Connections) for improved performance
  • Ability to change the OLAP connection for a role (Admin>Roles> Connection)
  • Ability to change and define chart color palette (Admin>Chart Color Palette)
  • Ability to set Filter Empty behavior for Pie, Bar, Bubble, Dashboard and Tree Map reports will now depend on Application setting (Admin > settings > OLAP report > Show Filter empty items)
  • Report Types: Ability to change the item order of the design menu
  • Settings - improved user interface
  • Settings ? Site Settings - SMTP Server
  • Ability to change the Help file location (Admin Settings > Site Settings > Help URL)
  • New Option: Report Name Size (Requires Report.ReportName column to be updated if it is to exceed 50 characters)
  • New Option to hide header left site image
  • Report Connection info is stored in the database table instead of XML report definition to allow easier administration
  • Email Report: Role Filter, Application Option for non admin/writer User to select emails based on his roles
  • Live Update: Ability to upgrade to the new build without overwriting the current files.
  
  
• Report Tree:
  • Connection Tree View for the report tree
  • Connections Tree View: user can click on a cube to design an OLAP report for the cube
  • Expand All will not expand Admin "My Reports" folder visible to admin users
  • My Reports will be expanded only on demand to improve the performance
  • Connection update dialog (report right click)
  • Ability to copy/move a report into a person?s private folder
  • Ability to cache the reports in the report tree to improve performance (Admin > Settings > Cache Report Tree)
  • Ability to Export and Import report definition to XML
  
  
• Ratings And Comments
  • All Reports: Ratings And Comments
  • Admin > Settings > Site Settings > Ratings section (4 new options)
  • In the report tree, Right Click on report > Comments. This page also shows some general report properties.
  • In the view mode of the all reports that have toolbar the rating and comments icons are on the far right of the toolbar.
  • Show user rating next to a comment ? new tab: Usage Log visible to admin and report designers
  • Application option would allow only admins and users authorized to edit the report see the comments. The person who created the comment will see it too.
  
  
• OWC
  • Context Menu for Actions, Comments and Drillthough
  • Better PTS Detection
  • Drillthrough for multi-selected filters
  • Export Enhancements
  • Allow Prop Toolbox for the chart
  • Snapshots creation no longer requires Temp folder
  
  
• Pie Tree Report:
  • Ability to scroll
  • Ability to refresh the report when it is first opened (options > Chart > No Refreshing)
  • Ability to retain the chart structure when filter is changed
  • base on absolute values when all values are negative
  
  
• Bar Chart Tree Report:
  • Ability to refresh the report when it is first opened (options > Chart > No Refreshing)
  • Ability to retain the chart structure when filter is changed
  • Option to set height and width
  
  
• SQL Report:
  • New Application option Admin > Settings > SQL report > Prevent Delete and Update
  • Ability to resize column and table names panels
  • Ability to select views (Application level option)
  • Feature to run the report immediately if a user filter value is defined.
  • SQL Template report is integrated into SQL report view mode
  • SQL Template report supports count and count distinct.
  
  
• ROLAP Report:
  • Geo Map - Enhanced chart selection dialog
  • %ProcessDate% gets updated with the current date if the Cube.LastProcessDate is not specified by the ROLAP cube aggregations process
  • Disabling ROLAP report type will also remove it from the admin menu
  • New Option to hide records with no name
  
  
• Dashboard Report:
  • New option to add report option to an empty group
  • New easier option to remove a group when hovering over an empty group
  • Ability to export sub-reports into single Excel file
  
  
• Scheduler:
  • Report Subscriptions for OLAP and SQL reports
  • history logs MDX and SQL
  • New Application Option: Allow report viewers and private reports to subscribe for self only
  • Ability to see log history details by double clicking on a list item
  • Job Name will default to the Report Name
  
  
• PDF Export:
  • PDF Export for OLAP, SQL and ROLAP reports
  • Option to set Landscape, Format, Margin and Font size
  
  
• Tree-Map report:
  • NonEmptyCrossjoin when using Bottom N feature to exclude empty items
  • Top-N feature
  
  
• Crystal report:
  • Crystal No longer requires Temp folder
  • Ability to resize column and table names panels
  • Ability to clear file cache
  
  
• KPI Report:
  • General UI improvement. Option to hide some columns and data
  • 4 sizes for Expanded Gauge
  
  
• File Upload:
  • Wait icon when uploading
  • Option to open uploaded files in view mode in Office client instead of client browser.
  
  
• User Filter Value:
  • User Filter Value (OLAP type) to have connection information (Admin > User Filter Value)
  • User Filter Value Role to have importance level (Admin>Role)
  • Hidden filter for OLAP report. Hidden filter remains hidden for report viewers and designer. The report designer does not have to link the report filter to the filter value.

• SQL Server Analysis Services 2005 Support
  1. Measure Groups
  2. Measure Display Folders
  3. Dimension Display Folders
  4. Drillthrough Actions / Advances Drillthrough Dialog
  5. SSAS 2005 KPI Support
  6. Perspective views
• OLAP Report
  1. Advanced Charting: over 30 chart types, printing, new options to control chart including: legend, margin, position
  2. Improved Performance
  3. Server side Formatting
  4. Calendar Picker for a dimensional filter
  5. Simplified Field List: checkboxes for measures, hierarchies and levels
  6. Ability to select measures on rows
  7. Ability to filter by measures
  8. Calculated Measure Info option exposes measure description or formula
  9. The Multi-Select button allows selecting more than one member at once
  10. GIS Chart - Shape File converter: ability to choose a Map Projection
  11. Ability to have a custom MDX to be preserved when a filter is changed
  12. Undo and Re-do toolbar menu buttons for the Drilldown mode
• New Dashboard report
  1. Web based WYSIWYG drag-and-drop designer
  2. Grouping reports by vertically or horizontally
  3. Multiple tabs
  4. Ability to have one or many filters for multiple reports
  5. Ability to define and apply different style themes
• OWC Report
  1. Automatic PTS 2005 detection and installation
  2. Cell Comments
  3. Relational connection supports
  4. Ability to Export to HTML and GIF
  5. Printing support
• Crystal Report
  1. Support for Crystal 8.0 and Up
  2. Enhanced look and feel
• New ROLAP Report
  1. Uses SQL OLAP functions (like: WITH ROLLUP) instead of MDX
  2. Supports SQL Server, Access, MySql, IBM-DB2, Oracle
  3. Allows designing a cube online
  4. Can consume aggregation data that resides in the source system reducing the cube processing time
  5. Provides better performance for viewing detailed data
• SQL Report
  1. Improved SQL Report Designer
  2. Supports SQL Server, Access, MySql, IBM-DB2, Oracle
• Other Features
  1. Ability to disable some report types
  2. Ability to specify friendly dimension names
  3. Ability to Export Reports/Users/Roles
  4. Enhanced Report Schema Editor
  5. Enhanced Report Tree: Context menu for managing reports and folders
  6. Private folder for each user
  7. Ability to define and use Email templates for sending emails
  8. Web folder support for Hyperlink Report
  9. Ability for define and apply the default filter values to any report based on role or user settings
  10. Enhanced Connection, User and Role admin pages

Report Portal URL Integration SDK is released. The SDK includes source code for a sample ASP.NET application that integrates with ReportPortal. The sample demonstrates how to securely integrate an external web application.

Report Portal MAP SDK Version 2.0 is released. The new features include:

• Installation Program
• Native ESRI SHP file support
• Map File (XML) editor allows changing information for each polygon entity
• Options dialog allows changing line color, width, Highlight color and opacity for template and files
• Ability to generate map files based on polygon based image maps.
• Image map can be located in a web page or a local file.

Tampa, FL - December 27, 2005 ? Version 2.1 of ReportPortal is released. It is now compatible with SQL Server 2000 and 2005. The new features include:

• OLAP Report:
  1. Support for asymmetrical MDX in Expand Mode
  2. Dimensional Search - ability to select multiple members
  3. Ability to hide non-empty items for the slicer. This feature makes slicers to be dependent on one another
  4. Enhanced performance
  5. KPI Wizard
  6. Additional Chart types: Column-Line Combination Chart, Radar Chart
  7. Frozen columns
  8. New NonEmpty Crossjoin Option
  9. Drill-down history is saved with the report
  10. Enhanced Zooming capability
• OWC Report:
  1. Auto OWC and PTS detection and installation
  2. Write Back support
  3. Ability to add a description
  4. Enhanced member search
• KPI Report:
  1. New Look and Feel
  2. Show Units (%, kilos, liters, pounds) next to the KPI value
  3. Ability to add a description
  4. Refresh rate for real time reports
  5. Use of Rows and columns instead of cell ordinal
  6. Five more icons in addition to smiley face
• Easier way to customize text via the Localize "Show Phrase Id" feature
• Uniqueness validation for report and user names
• Support for multiple XMLA connections and connection security
• NT User id and password for Roles
• Pie-Chart and Bar-Chart tree enhancements:
  1. Ability to add a free floating label
  2. Dimensional Slicers
• Data mining: Pie-Chart Tree for visualizing the Microsoft Decision Tree and Clustering models
• New Report Type: Bar Chart Tree for OLAP. Unlike pie tree, report supports multiple measures and negative numbers.
• New Report Type: TreeMap OLAP report
• Context sensitive help

Tampa, FL - October 28, 2005 ? ReportPortal 2.0 is now compatible with SQL Server 2005. The application still supports SQL Server 2000

Tampa, FL - January 31, 2005 ? Version 2.0 of ReportPortal is now released. The new features include:

• Consolidated installation process
• .NET support
• PieChart Tree Report - a new OLAP visualization tool
• Interactive Geo Map Charts
  1. Over 33,000 new maps
  2. Ability to drilldown to the US zip code level
  3. MAP SDK allows easy conversion and creation of new map chart

Tampa, FL - October 31, 2004 ? Version 1.5 of ReportPortal, the leading XMLA client application, is now released. The new features include:

• Greatly improved look and feel
• OLAP reports: Ability to drag and drop dimensions and levels on top of the data grid.
• OLAP reports: Improved Charting based on Macromedia Flash
• OLAP reports: Ability to add a custom Geo Chart
• OLAP reports: Advanced properties support for OLAP reports
• OLAP reports: Improved performance
• OWC reports: Administrator can now specify the OWC version (2000,XP,2003) fore application or for a user. User can specify his or her OWC version.
• Microsoft Reporting Services reports: ability to design reports online
• Enhanced paging for OLAP and SQL reports
• Ability for an Administrator to apply different Application styles
• Ability to bypass the login screen for authorized Windows authenticated users
• Ability to create an SQL Report based on MS Access, Oracle, etc.

Tampa, FL - June 21, 2004 ? Version 1.4 of ReportPortal, the leading XMLA client application, is now released. This anouncment is also published in September 2004 issue of SQL Server Magazine. This version is compatible with Microsoft XMLA 1.1 SDK. The new features include:

• Multi-language Support
• Ability to filter rows and columns with a conditional statement
• New Geo charts: World Map and USA map
• Custom Zoom Option
• New OLAP report options:
  1. Ability to hide empty Slicer members
  2. Ability to show/hide Field List in the View Mode
  3. Ability to show/hide Drop Area in the View Mode
  4. Ability to hide toolbar in the View Mode
• Integration with Microsoft Reporting Services:
  1. Ability to view RPT report via URL and SOAP API
  2. Ability to publish an RPT file

Tampa, FL - April 12, 2004 ? Version 1.3 of ReportPortal, the leading XMLA client application, is now released. The Version is compatible with Microsoft XMLA 1.0 SDK. The new features include:

1. New clickable charts: Cross-Measure Bubble chart, Scatter chart, Stocked Bar chart, Horizontal Bar chart
2. Print and Zoom capability
3. Sorting by Clicking on a Column Header
4. Ability to auto sum, average, min or max
5. Ability so save and reuse MDX named sets between OLAP reports
6. OLAP Write-back capability
7. Long report description
8. Ability to attach text comment to a cell
9. Crystal Reports 8.0 support
10. Key Performance Indicators (KPI) support
11. Ability to add a secure hyperlink
12. Report Usage Log and Reporting
13. Ability to assign Report Writers to designated folders
14. Ability to approve a report by one or many people before it can be published

Tampa, FL - December 30, 2003 ? Version 1.2 of ReportPortal, the leading XMLA client application, is now released. The Version is compatible with Microsoft XMLA 1.0 SDK. The new features include:

1. Drilldown mode (like in Excel) in which allows expanding items on a grid to display more detail about them while maintaining the current display of other items.
2. Ability to show multiple synchronized reports on single page
3. Ability to set the maximum time in seconds a query is allowed to execute
4. Level Depth Color Coding
5. Filter show member path on mouse over
6. Folder Level Security
7. Ability to change existing calculated fields
8. Ability to change existing conditional formatting

Tampa, FL - December 26, 2003 ? We are happy to announce that XMLA Consulting has become a member of the XMLA council. For more information on the XMLA council please go to http://www.xmla.org.

Tampa, FL - April 12, 2004 ? Version 1.1 of ReportPortal, the leading XMLA client application, is now released. The Version is compatible with Microsoft XMLA 1.0 SDK. The new features include:

• OLAP Reports:
  1. Slicing data with filters
  2. Dimension member search
  3. Mdx support
  4. Drill down by clicking on a row or column
  5. Interactive charts
  6. Printing capability
  7. Export to Excel
  8. Emailing a report
  9. Action support
  10. Member properties support
  11. Drillthrough to detail
  12. Records paging
  13. Cancel query execution
  14. Ability to show only top 10, 20, 50 records
  15. Sorting
  16. Ability to add a calculated members
  17. Ability to add percentages
  18. Conditional formatting
  19. Report security
  20. Snapshot creation
•  MS Office 2000 OWC (Office Web Components) reports
  1. Report creation
  2. Dimension member search
  3. Report saving
  4. Charts support
  5. Action support
  6. Member properties support
  7. Drillthrough to detail
  8. Snapshot creation
  9. Sql report
• SQL Report Creation
  1. Dynamic (Textbox, Dropdown and Checkbox) filters
  2. SQL support
  3. SQL tutorial
  4. Sorting
  5. Records paging
  6. Printing capability
  7. Export to Excel
  8. Emailing a report
  9. Snapshot creation
• Data mining report creation
• File upload support

Tampa, FL - August 15, 2003 ? Version 1.0 of XMLA Browser is released. The Version is compatible with Microsoft XMLA 1.0 SDK.

XMLA Browser 1.0 requires no client side software other the Internet Explorer 5 or higher. The application allows building dynamic olap reports and saving them. It also allows browsing Data Mining Models.