Dynamic File Name based on Entity Member.

Question

Hi Guys,

I am exporting a layout to the server, and I need the output file name to be dynamic based on the selected entity member in the procedure.

For example:

* If the Data Category is Entity and the selected member is Actuals,
* The generated file name should be: Actuals_Report.csv

Could anyone guide me on how to achieve dynamic file naming based on member selection?

Thanks in advance!

Akrem ABDELHAFIDH · Answer

Hi Michael,

I think dynamic substitution formulas such as @Entity  or @Date  are currently available only for Data Views for version.

I don’t think they can be used in FlexGrid in the version 14.

That said, it’s a good use case to test on version 15, just to confirm the behavior.

Best regards,

Akrem

Michael Gerrard · Answer

Hi Akrem, can this be used to rename uploaded zip files? We have a FlexGrid report with uploaded zips in a column, the user can, one-by-one, click the zip, but when it downloads, we would like to control the filename.

Best regards,

Michael

Akrem ABDELHAFIDH · Answer

hello @Yogesh Godghase

In Board 14.4, you can use the @Entity  substitution as title of the dataview.

Just to clarify: this works when you extract the Layout using the Export data to Excel option.

For example, if your selected Data Category member is Actuals, you can name your Data View like this:

@Data category Report

The output should then be generated dynamically based on the selected member, for example:

Actual Report.xlxs

This also works with other substitutions such as @Date , if you need to include the selected date/period in the file name.

Hope this helps!