Dynamic Report Name -Remove Cycle field variable in Dynamic name list (Nprinting Nov 2020)

[prathapg1959]

Hi Team,

I am not able to remove cycle field value populating in Dynamic report name .Please suggest to remove cycle field value from dynamic report name.

Ex : 

Sl.No	PRODID	PRODNAME	SALES
1	P01	Laptop	60000
2	P02	Printer	20000
3	P03	Scanner	30000

Cycle field is 'PROD ID' and Dynamic Report name field is 'PRODNAME'. When I generate the reports, Getting report filename as 'P01-Laptop.xls' but expected output is 'Laptop.xls'. Please find below screenshot. Please suggest to remove highlighted default cycle field variable in Dynamic name.

[Frank_S · Accepted solution]

@prathapg1959

Try this...

• In the 'field to cycle' drop down, select 'Product Name' from the drop down rather than product ID.
• Remove the Product Name variable from the Dynamic Name.

[Lech_Miszkiewicz · Accepted solution]

Obviously you are using ID to ensure unique values as Product names may not be unique. In such case I would try to load Product Name as dual with the numeric value being ID into your data model and follow by Franks suggestion which is correct and only solution at the moment!

cheers

[prathapg1959]

Hi Team,

Thanks for your suggestions. It is resolved.