Reports

HI,  I need to download a Ui page in site as a pdf doc, how can i achieve this. Eg:  I have a report in a page like showed above, By a click i need to download this page as a pdf.

Can any one explain how to generate PDF from reports with grid data.

One of the requirements requested from our team is to add print button to print the whole request information available in the interface by the end user. Could you please give us the best approach to do this task and what is your suggestions to achieve such these requests putting in your consideration that the interface is a combination of multiple interfaces each interface has its own rule inputs while some interfaces retrieve the data from web service and the others from record type in deferent representations and formats like grids, labels and so on

Hello, Its my first time working on reports. I am trying to generate a task report type and i am choosing context as tasks by process. I want to get a list of tasks in the process instance. However, everytime i open the report, i cannot see the latest instance details. I need to add it manually to view the details. Can anyone please help me understand if i am missing out anything?Thanks in advance!

Hi everyone,i am unable to call the process variable name in the report,it's showing error in the report if i call the process variablecan any one help me with it ,i have attached the image below,

Hello, I want to show percentage or numbers on pie chart instead of showing up with the legends. Can anyone please help me in this?  Also move the legends to bottom of pie chart. Currently it is showing up like this:  Attaching screenshot for reference: I want to replace with this:

Hello, I want to show data inside the pie chart and label outside below the pie chart. Can anyone help me in this? This is current figure: I want to achieve this: 

Hi Everyone, There is chart as shown above and the requirement is to have the labels displayed beside the count which is being displayed over the graph as shown below for reference. Can anyone please let me know ow can this be done? Note: Record data was used to populate this chart

Hi Everyone, We have a requirement to remove the unwanted data i.e., the data without value or zero value from the mouse hover as highlighted below from the chart. Can anyone please help us and let us know how this can be achieved? The highlighted values from the above screenshot shouldn't be visible to the user. Note: Record data is being used to populate this chart  

Thank you very much for your continued support.I would like to display only completed instances in the process report.I checked "Completed" in the report filter settings and saved it. However, I'm experiencing an issue where the process instances displayed include ones with a status of "Active", or only the status "Active" is displayed.Does anyone know the cause of the problem or have any hints on how to solve it?I would appreciate your help.Thank you in advance. いつも大変お世話になっております。プロセスレポートに、完了済みのインスタンスのみを表示したいです。レポートのフィルター設定で、「完了済み」にチェックし、保存しています。 しかし、表示されるプロセスインスタンスにはステータス「有効」が含まれる、あるいはステータス「有効」しか表示されないという事象が発生しております。問題の原因、あるいは解決のヒントをご存じの方はおられますか？皆様のお力をお借りしたく存じます。よろしくお願いいたします。

Hi Everyone, Is there any way to export data in local variable to excel? The Actual Requirement is 1. I have created some custom columns in Record Type 2. Generated an expression using Aggregation and stored the data in local variable 3. Created a Grid Report using the local variable 4. Now I need to enable download excel option for the data available in local variable But Appian is not allowing to enable showExportButton: true(), and getting below error. Thanks in Advance

I am facing some issues with the report in which , Whenever i refresh the page it is showing blank and the error. Please check below screeshot. Is there any way to solve this problem.

I am using process report. Recently I encounter the below error in the log. Can you pls advise on what would be the best option I should follow to remediate this issue without changing the default time limit? The report generation was cancelled by the system after 2224 ms.The time limit for generating a report is 2000 ms. (APNX-1-4275-008)

Hello Appian Community!We currently have the export to CSV enables on all of our reports. We did have our production environment go down as a user was confused and exported the same report 27 times which started a sync of those reports and took down our prod server for high memory usage.What came out of this were some questions, is there anyway to show to the user that they have selected the export to csv button like a loading bar? Currently when a user selects this button it appears nothing is happening and then a document will pop-up after several minutes once completed. The next issue is we are experiencing some pretty slow load times. If we were to export a csv report in our UAT environment with 5000 lines we are seeing it take roughly 10 seconds. With that exact same report in production for 5000 lines we are seeing roughly 15 minutes. Is there any way for us to investigate this export feature to understand why we are seeing such slow load times?  Thanks, Jordan

HI All, I need some support in the  Appian reports, wherein i trying to the display the columns charts based on the custom filter set outside of the chart configuration.Is it achievable , if so can you plz guide me the steps or the method to be followed. thannks and regards, manoj yadav

a!localVariables( local!statusFilter: null, /* docs.appian.com/.../Task_Report_Tutorial.html */ /* Basic steps to follow: */ /* 1. Create a Process Report object */ /* 2. Duplicate an existing process report, e.g. active_tasks */ /* 3. Create a Document constant for the report, e.g. TASKS_REPORT */ /* 4. Replace the value parameter of the refresh variable */ /* local!taskReportData with a process analytics query e.g. */ local!taskReportData: a!queryProcessAnalytics( cons!WSAACTIVE_TASKS_POINTER, query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1, sort: a!sortInfo( field: "c2", ascending: false ) ), filter: a!queryFilter( field: "c5", operator: "in", value: local!statusFilter, applyWhen: a!isNotNullOrEmpty(local!statusFilter) ) ) ), There is still code left, which is not effecting the above. The error as of now at : " local!taskReportData: a!queryProcessAnalytics ". In order to highlight the error , I ha

Hello All,Is there a way to track / get a count of number of nodes within the process models for each application that was created? I am currently reviewing all the applications that was created and I am stuck at this point during the documentation. I know there's a way in health check report to get the process model details which uses too many nodes but my task is to get node counts for each process model irrespective of max or min nodes criteria.  Any help?

We are trying to use the Export Data store entity to CSV smart service to generate a CSV which then gets SFTP'ed to an external location. We have a scenario where if there datastore entity doesnt return any rows, the CSV automatically generates a CSV with the header rows and the second row contains the text - "No data available due to empty data source, applied filter/selection criteria, or fields visibility". Is there any way we can have the CSV exported without this text in the second row? I dont find any options in the smart service setup, but if any of you have a non hacky way of working around this scenario it would be great.

hey hi  all,  I am facing an issue with the expression rule that extract the data subset from the task report which in turn, I need to showcase the tasks for the user action to perform the tasks but i unable to fetch the right data from the expression rule    from above code snippets and snap shot i want extract only "REVIEW PROCUREMENT REQUEST" which is dynamic display name but it show the node          name in the expression rule even though it takes it show the display in the task report. thanks in advance!!!                                                                                                                          &

Hello everyone, I have configured a Task report and use this to resume a User input task from My task list. When I resume the process from process instances then I am able to resume, but when I click on the task from My task list, it is showing "The Requested Task Is Not Available The task may have been deleted or completed by another assignee". What will be the possible solution for this error?

Hey appian community, In the highlighted portion of the graph below, I'm trying to figure out how to have the axis formatted for large numbers (Ex. 1000 should be 1,000). The measures used in the charts are already formatted correctly with the appropriate formatValue: Dollar, Integer, etc. The tooltips also display the formatted value correctly. My only issue is the axis of my charts. Please help me out, and thanks for your time. 

Hello, I have create a Process Task Report having as Report Context multiple processes. I used the a!queryProcessAnalytics to retrieve the data, the only problem is if in column "Assigned to" (tp!assignees) if I have multiple assignments (Group1 and Group2 or Group1 and User1) I won't be able to retrieve the tasks based on the loggedinuser and the groups that is member of (having only one assignee it works.) logicalexpressions: a!queryLogicalExpression( operator: "OR", filters: a!localVariables( local!groups: getgroupsformemberuser(user: ri!user), { a!forEach( items: local!groups, expression: a!queryFilter( field: "c1", operator: "in", value: fv!item, applywhen: not(rule!APN_isBlank(ri!user)) ) ), a!queryFilter(

I have created a "CRD column" in process report which is required to take the data from "CRD column" in User database table. I tried querying the data and indexed it but it's not populating the column with data in the process report. The column is populating null. Please suggest me alternate solution so that I can achieve this data populating. index(rule!CP_QRY_User( username:pv!username, returnCdt:true, pagingInfo:a!pagingInfo( startIndex:1, batchSize:1 ) ),"crd",null) i was using this expression to get data for respective column in CRD defintion in the process report.

Hello, Can anyone help me in this: How to hide these categories text(Qt1, Qt2, Qt3, Qt4) from column chart? Also, numbers/range(0-100) from y axis column? Note: For this column chart configuration, I am using records. Thanks

Hi everyone,  I'm having a grid field that shows data from a process model based report by using a!queryProcessAnalytics() query. I set up a manual refresh button that updates a reference local variable's value (local!refreshCounter), so that whenever user clicks the refresh button, the report value will be updated if there is any new active process task.  However, the process was not refresh unless I refresh the whole page (F5). I'm I doing it wrong? a!localVariables( local!refreshCounter: 1, local!datasubset: a!refreshVariable(value: a!queryProcessAnalytics( report: , contextProcessModels: , query: a!query( pagingInfo: a!defaultValue(ri!pagingInfo,a!pagingInfo(1,-1)), logicalExpression: a!queryLogicalExpression( operator: "AND", logicalexpressions: { a!queryLogicalExpression( operator: "AND", ignorefilterswithemptyvalues: true, filters: /*Status */