Save Table-based reports to DASVIEW reports
Prior to DAS 6.0, if you created a report based on a table instead of a DASVIEW, you would not be able to add a join to your report at that point. DAS 6.0 lets you seamlessly convert your table-based report to a join-based report.
Quick Suppress Zeros
DAS 6.0 makes it easy to suppress rows that sum to 0. To suppress zeros for any report, click Design | Suppress Zeroes. You can check and uncheck this option to see your report with and without
summaries that sum to 0.
Quick Reports
• The Quick Reports user interface has been simplified and DAS now deduces more information from JDE Automatic Accounting Instructions (AAI’s).
• 6.0 also introduces a Job Cost quick report. The setup is similar to what is found in other Financial quick reports, but line item setup is done for jobs and by selecting specific ledger types.
Pin to Group Level
There is a new option “Always Group to this Level” when you right-click, which allows you to set the group level automatically.
Movable Group Column
Unlike in previous versions, it is now possible to move a Grouped Column anywhere in your report. It doesn’t have to be the leftmost column.
Bring-backs
Data Access Studio has a new feature called Bring-backs. This allows a user to right- click on cells that support drill downs and bring the relevant data back into the original report. Where drill downs are useful for viewing relevant data in the context of the target table, bring-backs allow the summarization and comparison of that data with data found in the source table. Just as with drill downs, users activate bring-backs by right-clicking on a cell and selecting from the list of valid associated tables. This allows users to troubleshoot reports and better analyze data. For example - focused on a cell under the grouping of Document Number and Document Type, the user can see that this cell is impacted by how the Company Constants are set up and the F0411 detail that would take a user into any related detail records linked to the related table, e.g. F0911.
Publishing Burst Report
With DAS 6.0 you can now seamlessly publish burst driver reports. This eliminates steps from the past where you had to re-hook the driver report to the target report.
Spacer Calculation
This new calculation lets you insert a column spacer between any column. Quick Calculation | System | Spacer
Burst Publishing
In 6.0, when you publish a Burst report, the publisher also publishes the dependent (target reports) automatically.
Page Break on Group Level
In 6.0, PDF and Excel data exports will now break on group level breaks. The page breaking occur on whatever page break you want.
System Variables (6.0.59)
The following global variables are now available to be used in all reports:
• SYS_USER_ID
• SYS_USER_Number (Address book number of signed on user)
• SYS_USER_Description
• SYS_USER_BusinessUnit (Per Address Book Master)
• SYS_USER_Company (Per Business Unit from Address Book Master)
• SYS_USER_Type
• SYS_USER_Environment
• SYS_USER_SignedOnRole
Improved Data Export (6.0.65)
• Fully supports the group column being in any location in the report. Before, it would only display on the left.
• TSV and CSV formats now support more than one-level of grouping.
• (6.0.79) Improved XML rendering especially regarding handling grouping of a report and ensuring consistency of the schema of the report between releases of DAS.
Custom Date Separator (6.0.75)
It is now possible to specify a custom date separator for any date column. This is useful in international situations where you need to create a report for user that uses a date format different from your own.
Custom Thousands Numeric and Currency Custom Format (6.0.82)
Burst to an Output Directory Improvements (6.0.82)
When configuring a burst to output to a file, it is now possible to dynamically specify the output directory name using report variables. In addition, while bursting, DAS will auto-create an output directory if the directory does not exist.
Auto-Run a Report When Launched From a URL (6.0.82)
To better integrate JDE E1 Pages, it is now possible have a report automatically run after it is launched using a hyperlink generated from the Published Report’s Folder Admin menu. Simply add ‘&-run’ to the end of the hyperlink.
Fixed Width Data Export of Summarized Data (6.0.94)
It is now possible to export summarized data (i.e. grouped data) in the Fixed Width export format as long as all the columns are ‘Pad’ calculation columns.
More Excel Output Format Types for Bursting and Automator (6.0.97)
It is now possible to export report data to XLSX or XLSB and the report presentation to XLSX and XLSM in addition to all of the formats DAS already supports in Bursting and Automator.
Access to the last time data was selected and retrieved in Presentations (6.0.107)
The last time and date data was selected and fetched from the database can now be accessed from the Excel presentation layer via two report level variables.