Datalist filter value in report

 
1
0
-1

Hi

I have a datalist "recountlist" with a filter

I have created a report to download the flirted list to a PDF, however i want to be able to print the filter value in the report I have tried several Hash values, but none has worked Part_Number is the fieldname in column of the Datalist

1 - #datalist.html.ID[d-7922336-fn_Part_Number={partnumber}]#
2 - #datalist.html.ID[d-7922336-fn_Part_Number={Part_Number}]#


what value can be passed on as the hash variable to the report?


  1. Bastiana
    #datalist.html.ID[d-7922336-fn_Part_Number={partnumber}]#

    is not a valid hash variable I think, particularly {partnumber}

    When hash variable is not valid / failed to parse, they will stay in its original / unparsed form.

    1. What is "report"? Is it a List Menu or Form Menu or something else?
    2. Is the "report" mentioned created using Report Builder ?
    3. Where do you put the hash values?

    Any steps / screenshots to show how you are creating them and where it does not work would be good.

  2. Dumidu Roshan

    Hi thank you for your reply

    the report is created via Report Builder in the addon builders

    the has variable are added on to the report as html blocks as below

    for e.g. i have used <p> Total Lines: #datalist.size.recountlist#</p>  to get total number of lines in the report and its working . 

    i just wanted to get in the report what was the filter used to generate it



  3. Dumidu Roshan

    is there a way to parse the value of URL Request Parameter -


  4. Dumidu Roshan

    based on a forum post i tried

    #form.Stock.Part_Number[{d-7922336-fn_Part_Number.id}]# however it does not work, displaying the hash variable as text

    #form.Stock.Part_Number[{requestParam.id}]# seems to render but no value is displayed


CommentAdd your comment...

2 answers

  1.  
    2
    1
    0

    Finally got the desired result by using

    #requestParam.d-7922336-fn_Part_Number#

    d-7922336-fn_Part_Number is the URL Request Parameter from the datalist



    1. Dumidu Roshan

      now figuring how to change the report filename to change from uuid to same parameter, any report downloaded has the record uuid as the filename prefer to use the filtername to be clear when saving the file. anyone has any experience please let me know


    CommentAdd your comment...
  2.  
    1
    0
    -1

    how can you use filter? in datalist first, and print in report or not?


      CommentAdd your comment...