Limiting no. of rows to be exported to Excel from Straight Table without using macros??

[#1]

Hi,

I want to use the Export to Excel feature/option in a straight table. However, I only want first 100 records to be exported.

Is there a way to achieve this without the use of Macros?

Any help will be highly appreciated.

Thanks,

Sanjeev

[abeyphilip]

Hi Sanjeev,

Couldn't you have a filter that will let you select first 100 records in the table and then you can do the export.

Or if you are fine to have only those 100 records in the straight table you can sort and limit the number of records using "Max Number" in Presentation tab.

rgds,

Abey

[#3]

Hi Abey,

Thanks for replying.

The issue is I need all the data to be displayed on the table. However, while exporting only I want to set a limit.

Eg: Say in my straight table I will filter and limit. Like top 200 customers. But, while exporting I want only list of top 100 customers to go to the excel file.

[sparur]

Hi.

you can't manage Send To Excel functionality without macro.

[abeyphilip]

Hi Sanjeev,

Try to have a list box with an expression field like below:

=if(aggr(rank(sum([Grand Total])),[Cust Name])<=100,'Yes','No')

In this case, the "Yes" in list box will include the top 100 customers based on "Grand Total". So selecting Yes will let you select top 100 in your straight table and then you can do the excel extract for the same.

Regards,

Abey