choose fields from report

[Tfa]

hello this is my problem i have a report that brings to many fields and i want to export some of them to an excel file does anyone has an idea of how to do that ?
is thinking of something like a second report that by clicking the label of the field s you could get the names of the fields to an sql string then use them to extract them to an excel file but i don't know how to do that

 

[Ranman256]

you use a query, not a report, then in the macro use
import/output
transferspreadsheet "query",.....

 

[Tfa]

the problem is that i have the report ready and on top of that report i want to choose some of the fields and export them to excel
my problem is how do i get the name of the fields so that i can create the query that will get me the results that i want
for example my report has the fields ID,Name,Surname,Telephone i want the user to choose the fields that he likes from the report and excract it to an excel file