AML Report Exported as Excel Doc
Good day all. I have a customer that wants to export a list of all documents in Aras to an Excel document. Is it possible to do this with an Aras report? I have tried searching & it seems that all...
Forum Discussion
Chris,
Thank you for the quick reply. I have tried the Query Builder, but have not had any success with it. It only seems to give me information on the current document I am in. I'm sure I am missing something.
I believe that the team that is asking for the report is blanking out the Page Size & then exporting to Excel, but with over 46,000 documents, they have to do it in chunks.
When I try to create a Self Service Report for this, I receive a runtime error. Not sure if this is due to our licenses not being updated (I'm trying to fix that, but our server is not connected to the internet).
I was thinking about a custom method, but haven't gotten there yet.
Hi Nathan,
You might want to check out the Opening a TGV with a Method section of the advanced blog post. Most of the TGV examples you'll find will add the TGV as a relationship tab to an item. When you do this, the item you are looking at is used as a filter for the query, so you will only see results that are related to that current item. When you open the TGV with a method, it opens up the query to instead get all of the results in the database.
With 46,000 documents, you may run into the same issue of needing to do it in chunks though. A method will probably be your best bet. If you do end up writing a method and you're new to .NET, you can check out this doc which contains an example of how to use the standard .NET libraries to create a File.
Chris
Chris,
You rock!. Thanks for the info, I will check it out.
