Unable to figure out select statement for Reports

Kaushal_Didwan1 · 10-11-2019 01:37 AM

I have a table with lot of entries and their status as A, B, C, D

I am trying to get report daily based on the status of records such as

Status: A
<record 1>
<record 2>
<record 3>

Status: B
<record 4>
<record 5>
<record 6>
… etc

Can anyone help me out with the select and filters statement which is required in report template.

Thanks,

1minManager

You could instead create a table view grouped by Status and ordered by Record number

Otherwise if it has to be a report, read this first then come back with any more specific questions - https://help.appsheet.com/en/articles/961746-template-start-expressions

Simon@1minManager.com

Phil

We do not currently support “group by” in Reports.

One alternative is to include a series to Start expressions where each Start expression and its related table displays value for one status code value. For example, if you have four status code values, you would specify four Start expressions.

Kaushal_Didwan1

Can you give me example of 1 start statement because i am not able to figure out how to write it out.

Kaushal_Didwan1

So this is the start and select statements I am using…

<<Start:SELECT(ProductionSheet[Design Status], [Design Status]=”AAA”)>>
Design Name: <>
<>

The error I am getting is:

Workflow rule ‘Design Status’ action ‘Action 1’ Body template. Start expression ‘SELECT(ProductionSheet[Design Status][Design], [Design Status]=”Dye Program Not Given”)’ should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the ‘Key’ column of the referenced table.

Steve

What part of that error message don’t you understand?

You should use FILTER() rather than SELECT() in your <<Start>> expression.