1 Reply Latest reply on Dec 3, 2018 9:33 AM by Joe Oppelt

    Issue in Parameter passing through URL

    srinija Jakkula

      Hi All,

       

       

      I have a requirement of passing parameters to SSRS Report from Tableau through URL action dynamically  . I have created below URL action using calculated fields as per SSRS URL format:

       

      http://ui1padb001xcb/SSRS2008_PROD/Pages/ReportViewer.aspx?%2fMarketing_and_eBI%2fReports%2feBI_Reports%2fTruck+Treatment%2fMonthlyTreatmentSummary&rs:Command=Render&P_MONTH=<Parameters.Month>&P_YEAR=<Parameters.Year>&<Office URL>&<Customer No. URL>&<Account URL>&<RDT URL>&<Truck URL>

       

      My Dashboard look like below:

       

      where Office URL = ‘Office=’+[Office] (calculated field which generate unique parameter for each value of office like office=ABC&Office=BDF etc.,)

       

      Year and Month are parameters and rest are quick filters.

       

      Here my issue is when 'All' is selected in the quick filters it is passing all values to the url and length of URL is exceeding the limit and also each value is getting repeated multiple times in the URL as below:

      http://ui1padb001xcb/SSRS2008_PROD/Pages/ReportViewer.aspx?%2FMarketing_and_eBI%2FReports%2FeBI_Reports%2FTruck+Treatmen…

       

      http://ui1padb001xcb/SSRS2008_PROD/Pages/ReportViewer.aspx?%2FMarketing_and_eBI%2FReports%2FeBI_Reports%2FTruck+Treatment%2FMonthlyTreatmentSummary&rs:Command=Render&P_MONTH=2&P_YEAR=2018&Office=OKLAHOMA&Office=OKLAHOMA&Office=OKLAHOMA&Office=OKLAHOMA&Office=OKLAHOMA&Office=OKLAHOMA&Office=OKLAHOMA&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&Office=KNOXCITY&O

      Is there any way that I can restrict passing all values to the URL when 'ALL' is selected in filters and also same value repeating in URL multiple times?

       

      Thanks in advance !!

       

      Thanks,

      Srinija

        • 1. Re: Issue in Parameter passing through URL
          Joe Oppelt

          You can build your URL in a calc field, and do some smarts in the logic to exclude that portion of the URL in the string.

           

          If you place the calc where you build your URL string on your DETAILS shelf, you can just use <Calc Name> as the URL in the action.

           

          To tell if your user has selected "ALL", make two calcs

           

          { FIXED : COUNTD([whatever dimension]) }

           

          This will tell you how many are in the database.

           

          Then make

           

          { EXCLUDE [First dimension on the sheet] (, [second dimensions on sheet], ... [Nth dimension on sheet] : COUNTD([whatever dimension]) }

           

          Then in the URL calc, compare the two.  If they are the same, the user has selected ALL.  If they are different, then you need to pass the list in the URL.