SQL Server Performance

URL Parameter

Discussion in 'SQL Server Reporting Services' started by bubberz, Jul 25, 2005.

  1. bubberz New Member

    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!
    bubberz, Jul 25, 2005
    #2

  2. Madhivanan Moderator

    In Crystal Reports, you can use

    CR.ShowpopupMenu=False

    from the Front End

    See if you are able to simulate the same in Reporting Services

    Madhivanan

    Failing to plan is Planning to fail
    Madhivanan, Nov 5, 2005
    #2

  3. bubberz New Member

    Thanks for the info!

    I got the URL parameter figured out.
    bubberz, Nov 7, 2005
    #2

  4. Madhivanan Moderator

    Well. Can you tell us how you solved it?

    Madhivanan

    Failing to plan is Planning to fail
    Madhivanan, Nov 7, 2005
    #2

  5. bubberz New Member

    I wish I could....but am not too sure how I got it to finally work.

    I went through the "Hitchhiker's Guide" over and over till I got it right.

    Thanks!
    bubberz, Nov 10, 2005
    #2

Share This Page