How can we help?
Find a clear answer, or a friendly human.
Explore the knowledge base
80 articlesAll my charts are not displaying, just showing blank space. The issue started in late December 2015.
Applicable Versions: All A Windows Update from 29th December 2015 will cause issues stopping Charts being displayed in the Dashboard Designer Client. The update ( KB3132372) will be listed as a varient of, or similar to :- Security Update for Internet Explorer Flash Player for Windows 10 (…
Read article →End Users › GeneralA particular dashboard I have published is slow to open in the web. How can I improve this?
Applicable Versions: 5.50.0103 and above The time a dashboard takes to load in the web, or mobile apps is affected by the amount of data the server must load to render that dashboard. Obviously reducing the number of objects on a dashboard, or reducing the amount of data the query returns will…
Read article →End Users › GeneralAre Report Drill-downs available on Mobile Devices?
Applicable Versions: 5.50.0200 Onwards Report Drill-downs do not work with mobile devices.There are no plans to implement this in the future. Drill downs are interactive and as such are best withing Dashboards rather then reports.
Read article →End Users › GeneralBoolean fields and boolean calculated fields display as 0 or -1 in the report designer. How can we change that to True or False?
Applicable Versions: 2.01.0152 onwards If your query returns a field with a boolean (logical) data type, it will be displayed using the default Microsoft format, that is 0 for false and -1 for true in a report. There are two ways you can overcome this behaviour to display either true or false…
Read article →End Users › GeneralBusiness logic query fails with error message “Communication layer message. Error marshalling or Unmarshalling (8408) (7175)" whilst running via the Progress AppServer Internet Adaptor (Aia)
Applicable Versions: All The AIA configuration in the unbroker.properties file contains a setting called soReadTimeout. This setting defaults to 240, and is described as; Specifies the amount of time, in seconds, the Aia adapter will wait for a response from an appserver before sending a…
Read article →End Users › GeneralCan I add a subtotal to a report with Groups?
Applicable Versions: All Adding subtotals and totals to a report is a common task that is made easy with the DataPA Reports Summary Field object. The video below gives a demonstration of adding a sub-total to a report.
Read article →End Users › GeneralCan I combine freeform and business logic subjects in a single query?
Applicable Versions: 2.01.0152 Onwards This article uses business logic functions. For more information on creating business logic functions, see "Can I create a query that runs a Progress function on the server to retrieve data?". Using Multi-Subject Queries, you can combine any number of…
Read article →End Users › GeneralCan I combine more than one subject in a single query?
Applicable Versions: All With Multi-Subject Queries, DataPA allows users to combine more than one subject in a single query. The video below demonstrates how to create a report using two subjects.
Read article →End Users › GeneralCan I create a report based on an existing query, rather than having to create a new query for my new report?
Applicable Versions: All DataPA is designed to allow you to share queries easily between the different applications on your desktop. If you have a query, and would like to create a new report using that query as a starting point, you can simply create a report based on that query. The video…
Read article →End Users › GeneralCan I create summary queries in DataPA?
Yes, DataPA in V4 now supports summary queries. These enable you to use your subjects to create summarised ""cubes"" of data which are processed on the AppServer and only the summarised results being passed back to the client application. The summary queries also have the ability to identify…
Read article →End Users › GeneralCan I limit number of records that I retreive when I run a query or report in DataPA?
Applicable Versions: 3.02.0032 onwards From version 3.02.0032 onward you can enter the number of rows you want a query or report to retrieve. To do this run the report or query as normal and in the run query wizard just prior to the query running you can now select ""Return All Rows"" which will…
Read article →End Users › GeneralCan I specify the data location for DataPA to use as a command line switch?
Applicable Versions: 3.02.0035 onwards From version 3.02.0035 onwards you can use a command line switch to set the data location that DataPA should use for that session. This is done by using the /d and /x switches. You must enclose the data location you want to use in double quotes. So for…
Read article →End Users › GeneralCan I use an inner join with a multi level query in DataPA?
Applicable Versions: 3.02.0032 onwards From version 3.02.0032 onwards an inner join can be used in a multi level query in DataPA. To use an inner join instead of an outer join (which is the default behaviour) you must highlight the child subject in the tree and check the inner join box located…
Read article →End Users › GeneralCan I use a query created when I create a report in other applications like Excel?
Applicable Versions: All DataPA is designed to allow you to share queries easily between the different applications on your desktop. If you have a report, and would like to use the query behind that report in Excel, you can easily share that query. The video below demonstrates how to share a…
Read article →End Users › GeneralCan the DataPA Excel Add in work with a 64bit version of Office?
Applicable Versions: Prior to Version 6 Prior to Version 6. DataPA does not support pure 64bit operation required for 64bit Microsoft Office. Applicable Versions: Version 6 onwards A new 64 bit DataPA Excel Add-in was introduced in Version 6.0.
Read article →End Users › GeneralDashboard problems with large result set - resulting in OutOfMemory exceptions.
Applicable Versions: 4.05 onwards System.IO.OutOfmemory error messages with a dashboard that returns a lot of data a consequence of a 32 bit process performing various simultaneous functions on a large dataset. The dashboard is doing a lot more than Excel with the dataset. In addition to…
Read article →End Users › GeneralDoes DataPA OpenAnalytics have a vunerability to log4j exploit?
We can confirm that there is nothing in DataPA OpenAnalytics itself that uses log4j. OpenAnalytics is built on .NET technology, and does not use Java. There may however be some vulnerabilities in the Progress architecture stack that DataPA OpenAnalytics connects to. For details more, Progress…
Read article →End Users › GeneralEmail from the Scheduler is not working
Applicable Versions: All The following link to the online Help manual shows the Mail settings screen Emails not being sent out is not necessarily an issue with DataPA. To track down possible causes the following items would be a good starting point. Check the Scheduler log file, and/or the…
Read article →End Users › GeneralError message attempting to access DataPA - Unable to de-serialise server security data.Additional error: Failed to open stream, array passed was empty
Applicable Versions: 4.05 onwards If an Error message is displayed when attempting to access DataPA and this is happening on more than one client there may be an issue with the service. As an initial step to resolution Start and Stop the DataPA Enterprise Service on the server.
Read article →End Users › GeneralHow can I add a dynamic image to a report that is loaded from a filename defined in a field?
Applicable Versions: All It is possible use images on a report dynamically loaded from a URL stored within a database. To achieve this of the report designer, follow these steps: Start DataPA Reports and create a report using a query which contains the field with the URL for the image. Add an…
Read article →End Users › GeneralHow can I change the visibility of fields on a report based on the value of a Parameter?
Applicable Versions: All Versions Sometimes you might want to show of hide a field on your report based on the value of an parameter. This can be achieved by adding the parameter to the report's Page Header then adding some script to the OnFormat event of the report Detail section This script…
Read article →End Users › GeneralHow can I easily change my DataLocation so that my setup is stored centrally on an AppServer?
Applicable Versions: 2.01.0152 and above In most corporate environments, you will want to store your setup files centrally on an AppServer so they can be controlled centrally. To do this you will need to change your DataLocation to point to an AppServer (see "How do I store my setup centrally on…
Read article →End Users › GeneralHow can I get page numbers to restart for each group on my report?
In order to achieve this some of the properties of the page number field need to be changed. This KB entry assumes that you have grouping on your report and have a page number situated in the Page Footer section on your report. In the design window of DataPA Reports select from the menu View >…
Read article →End Users › GeneralHow can I improve the performance of dashboards embedded in my application?
See A particular dashboard I have published is slow to open in the web. How can I improve this?
Read article →Still looking for an answer?
Ask our help assistant, or get in touch with the team.
Email support@support.helpdesk.inmydata.ai ↗