filename as caption name while exporting excel

[puneetagarwal]

Hi ,

Can we get the caption name/window title as a filename while exporting the excel.

Eg: if we make a current selection as companyname like 'abc' the window title shows as abc_report, now i want the excel exported should take the name as abc_report.

Is it possible?

Regards,

Puneet

[YoussefBelloum]

Hi,

Yes you can do it (maybe not for all types of objects), if we take a straight table:

on the general tab of the object => title of the object => =Getfieldselection(YOUR_FILTER)

like that when you export you will have your selection as a title

[puneetagarwal]

Hi Youssef,

Thanks , but its not working.

When we click on send to excel its saving the file-name as default/system generated.

Regards,

Puneet

[YoussefBelloum]

What is the object type you are using to do this export ?

[puneetagarwal]

As of now i'm using table box.

But tried with straight table as well . its not working.

Regards,

Puneet

[YoussefBelloum]

ok, can you take a screen shot on the title expression ?

[puneetagarwal]

This is what I have given in title expression

=GetFieldSelections(Product)

[YoussefBelloum]

Try to do : SEND TO EXCEL (via right click on the object) and not export

[puneetagarwal]

Yes, tried the same .

its not working.