8 Replies Latest reply: Apr 5, 2016 6:20 AM by rameshbabu challa RSS

    dynamic report name in nprinting excel reports

    rameshbabu challa

      Hi,

       

      I tried to provide a dynamic to the excel report in NPrinting using Qlikview variable. But the variable cannot be evaluated and it returns the same expression as the result.

      ex: I have created a variable for Maximum available Year as below.

      vMaxYear=Year(Max(Ref_Date))

       

      The same variable is being referred in the report name and The report name appears as Report_Year(Max(Ref_Date)).

      But it should be displayed as Report_2016.

       

      Could you please assist me how to achieve this and let me know where I am going wrong?

       

      The screenshot is attached

       

      Thanks,

      Ramesh.