Hi,
I am trying to generate excel document by using the a!exportDataStoreEntityToCsv(). Below is my code snippet:
load( local!exportDocId, local!errorMessage, { if( isnull(local!exportDocId), a!linkField( labelPosition: "COLLAPSED", links:a!dynamicLink( Label: "Export Inactive Users Details to Excel", saveinto:{ a!exportDataStoreEntityToCsv( entity: cons!VW_EPMT_EWR, selection: a!querySelection( columns:{ a!queryColumn( field: "ewr_number" ), a!queryColumn( field: "name" ), a!queryColumn( field: "active" ) } ), documentName: "EWR Grid Record Data", saveInFolder: cons!EWR_FOLDER, onSuccess: a!save( local!exportDocId, fv!newDocument ), onError: a!save( local!errorMessage, "Error in Exporting File" ) ) } ) ), {} ), if( not(isnull(local!exportDocId)), a!linkField( links:a!documentDownloadLink( Label:"Download Excel File", document: local!exportDocId ) ), a!textField( value:local!errorMessage, readonly:true ) ) })
Now when i am clicking on the link in design interface, it gives the below error:
Interface Definition: Expression evaluation error: An error occurred while executing a smart service: Error accessing data store entity: VW_EPMT_EWR. Please contact a system administrator for additional details. (APNX-1-4505-026).
Could anyone please help me out by identifying the mistake. Any help will be appreciated.
Thanks,
Anandita
Discussion posts and replies are publicly visible
Starting Excel in safe mode. Disabling COM add-ins. Disabling Excel add-ins. Moving files from startup folders used by Excel.Click File > Options > Add-ins.Select COM Add-ins, and click Go.Clear all the checkboxes in the list, and click OK.Close and restart Excel in normal mode (not in safe mode).
Regards,
Will