Query Filter Issue with Open in Excel

(0) Share

Report

Posted on by Samantha73

3,263

Hi Guys

I have created a query on item table and published to the Item list page using query category. All works when viewing the report in browser, however when opened in excel , column that has the filter gets removed and all other columns misalign. Filter is something like below on the item tabel:

filter(Location; Location)

{

ColumnFilter = location = const('East');

}

I'm wondering if there is another way to filter item table (this is the first table in the query so not sure how to use DataItemTableFilter

Thanks

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

AliHamza 175 on at

Like (0)

Report
Copy link

Link copied!

Hi Samantha,

This will work for you:

dataitem(ItemTable; Item)

{

DataItemTableFilter = Locations = CONST('East');

column(column1; column1)

}

OR
you can add the following code to the OnBeforeOpen trigger of the query object to change the filters
currQuery.SETFILTER(Location, 'East);

Please Verify the answer if your question has been answered. This helps other forum users.

regards,

Ali Hamza

Was this reply helpful? Yes No