Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

141
Views
Passing multiple dynamic values from a web form to SSRS

I have inherited code that was written by someone else. The code takes a "number" and passes it to an SSRS report. I have modified the report to include 5 more alpha numeric strings that I need passed to the report. Here is the initial code:

var h = "SSRSRepBrowserParameters.aspx?rs:ID=b2d543c2-1cce-487b-a3c0-743baa5933e1&QuoteNumberParameter=";
var q = $('.HdrTitle').eq(1).html();
var x;
x = q.split(" - ")\[1\];
x = x.replace('.','');
x = x.replace(/^0+/, '');
x = x.replace('.','');
$("#btnPrintVendReq").ready(function(){ $("#btnPrintVendReq").click(function(){     
    window.open(h+x '\_self');});});

I surprisingly understand what the guy did using variables to make this:

\*\*class="HdrTitle"\> Quote Form - 00.019.000 \*\*

look like this:

19000

What I need to do is add 5 more dynamic values that are in the web form and append them to the URL passed to SSRS.

In the web form the values are FreeTextField_10...11...12...13...14 and will be passed into the URL as ItemNo1...ItemNo2...ItemNo3...ItemNo4...ItemNo5:

\*\*class="saveHistory Text" name="FreeTextField_10" id="FreeTextField_10" value="2764-06" \*\*

So if all that mess makes sense the end result I need the window.open to pass a URL that shows:

SSRSRepBrowserParameters.aspx?rs:ID=b2d543c2-1cce-487b-a3c0-743baa5933e1&QuoteNumberParameter=19000&ItemNo1=2764-06&ItemNo2=2764-06&ItemNo3=2764-06&ItemNo4=2764-06&ItemNo5=2764-06

I was actually impressed that I was able to figure out what I need and hard coding it works...but unfortunately the vales come from a web form and will change so it's the pesky variables that throw me off here.

Unfortunately I have not been able to come up with the correct syntax to successfully pass the variables to the report.

about 4 years ago · Juan Pablo Isaza
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!