General

General

How do I filter data in a dashboard based on a user or Group?
Applicable Versions: 5.50.0034 onwards To apply a User or Group filter you set up a column (data or calculated) that contains data that matches the user...
Wed, 11 Apr, 2018 at 2:51 PM
How do I refresh the parameter query? If I add a new record to a lookup on the system, I need to refresh in dashboard drop down parameter?
There are two options that are available to you. The first is to set the lookup to not cache data on the client. This is set on the Options Tab of th...
Wed, 11 Apr, 2018 at 3:35 PM
How to find your data file(s) to send to a support representative.
Applicable Versions: All When you raise a support issue, the support representative will often ask you to send through a dashboard, report or query, and...
Thu, 22 Mar, 2018 at 3:55 PM
Boolean 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 Microsof...
Mon, 26 Mar, 2018 at 11:30 AM
Can 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 vi...
Mon, 26 Mar, 2018 at 11:08 AM
Can 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 "...
Fri, 23 Mar, 2018 at 12:25 PM
Can 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 demonstrate...
Fri, 23 Mar, 2018 at 12:27 PM
Can 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...
Mon, 26 Mar, 2018 at 11:06 AM
Can 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 re...
Mon, 26 Mar, 2018 at 11:02 AM
How do I create drill down reports?
Applicable Versions: 3.00.0040 onwards Drill down reports allow you to display detailed information in child reports that are visible by clicking on hyp...
Mon, 26 Mar, 2018 at 11:32 AM