I'm having no luck creating an Excel report. So far, everything I've tried returns no data. **Using a Query as the data source:** [upl-image-preview uuid=207d619d-83e8-4f09-a54f-35f1a294d581 url=https://www.awareim.com/forum/assets/files/2026-02-27/1772217898-929710-excel1.jpg alt={TEXT?}] **Using Determined at Runtime:** [upl-image-preview uuid=dce65eb5-8ab3-4d0b-a689-5dff7c9c474e url=https://www.awareim.com/forum/assets/files/2026-02-27/1772218025-605402-excel2.jpg alt={TEXT?}] **Using Determined at Runtime:** [upl-image-preview uuid=3de60765-cb26-426a-9f63-1ceecfec81bb url=https://www.awareim.com/forum/assets/files/2026-02-27/1772218093-103270-excel3.jpg alt={TEXT?}] None of these return any data.

No Luck Making an Excel Report

kklosson

I’m having no luck creating an Excel report. So far, everything I’ve tried returns no data.

Using a Query as the data source:

Using Determined at Runtime:

None of these return any data.

Shadow_XV

Hi kklosson,

Try LIST_TABLE_START instead of just LIST_TABLE

For your excel it should start like this (put the query in tilde quotes just to be safe)
«LIST_TABLE_START(OrganizationPositions)»«Position.Title»

and it will need to end like this, the last column in your table includes the list table end with the last attribute you want to display (I will just take the Position.Sworn as your last column)
«Position.Sworn»«LIST_TABLE_END()»

From my experience if anything in the attribute tags are misspelt or you are trying to pull an attribute that is not on the BO then it will either hang and keep loading forever until you kill the Aware server or it will just not pull through any data.

nhofkes

In addition to the previous comments, note also that ‘FIND OrganizationPositions’ is not a valid query. This should either be ‘FIND ALL OrganizationPositions’ or ‘FIND OrganizationPositions WHERE [Condition]’.

kklosson

I haven’t tried this yet because I went with a standard report. But your responses sound about right. Thanks all for helping, as usual.

kklosson

Well, no luck with any of this. The query is not fetching data. In this case, I’m using MS Word. I have a Candidate object with a child reference attribute of LegalNameChange. I run the report from the Candidate object. The report fills in Candidate attributes but no data for the LegalNameChange attributes where I am expecting two rows. The LegalNameChange query is basically ‘FIND LegalNameChange WHERE LegalNameChange.Candidate=Candidate’. This example is right out of the docs for the START_LIST_TABLE action. The report always saves and runs, just no data for LegalNameChange. As per the documentation, I also tried Candidate.LegalNameChange which also yielded no data.

The Test Log indicates both reference attributes are being found and fetched.

Jaymer

dont put it past aware to have a bug.
change the query so its not exactly the same as the BO.
also try in a cell by itself.

kklosson

Thanks. I tried both with no joy. As stated, the Test Log shows the correct two rows being fetched.
I will note that this relationship is maintained in the Candidate_ref table (constructed before I knew better), but in all cases, the queries are operating correctly and fetching the correct two records. Even when using Candidate.LegalNameChange as the query as shown in the docs.

kklosson

Still getting nowhere. Is ANYONE using LIST_TABLE or LIST_TABLE_START() in a V10 Excel or Word report? I cannot get either to produce any data. Is this broken? I can’t believe it is and no one has reported an issue. Seriously, I believe I am working exactly as the documentation prescribes. Does @aware_support3 have any thoughts on this?

nhofkes

Yes, I have successfully used LIST_TABLE_START() in a V10 Word report. However, in my Word file I included the FIND statement in the Word document itself, whereas it seems that you have the query in the process - based on the screenshot in your earlier post. So, if your report is run from the Candidate object, try to put in your Word document:
<<LIST_TABLE_START('FIND LegalNameChange WHERE LegalNameChange.Candidate=Candidate')>>

If that doesn’t work and your Candidate object has a child reference attribute of LegalNameChange, try the following:
<<LIST_TABLE_START('FIND LegalNameChange WHERE LegalNameChange IN Candidate.LegalNameChange')>>

kklosson

I did just have some success. Thanks!