URL Parameter

• sol

  SSCrazy

  Points: 2294

  More actions

  July 25, 2005 at 2:22 pm

  #110060

  I've got the parameter set in the URL, but the report isn't rendering the data.  Is there something I have to set for the Report Parameter?

  I've got:

  Default Value = "None"

  Available Values = "Non Queried"

  The prompt is still showing....could this be the issue?  If I copy from the URL the value I want to pass, then click View Report, it works.  I want the user to NOT have to do this.

  The SQL is:

  SELECT * FROM WPG WHERE   (WPG.WP_PID = @URLParam)

  The name of the parameter is URLParam.

  Thanks!

• ofir shoval

  Ten Centuries

  Points: 1278

  More actions

  July 26, 2005 at 12:29 am

  #577055

  if u want to hidden the prompt add the "rcarameters=false" 2 the URL like:

  "/ReportServer?/Reports/Daily&rs:Command=Render&rcarameters=false&FromTime=" & FromTime.Value & "&ToTime=" & ToTime.Value

• sol

  SSCrazy

  Points: 2294

  More actions

  July 26, 2005 at 9:09 am

  #577205

  Thanks ofir!  I'll try that.

  We may have gotten it to work.  I used the targetserverURL for the hyperlink, and the parameter worked.