SQL Server Performance

Passing Parameters Through Query String

Discussion in 'SQL Server Reporting Services' started by Arzo2000, Sep 27, 2005.

  1. Arzo2000 New Member

    I am trying to pass a date as a query string parameter through the URL:
    ex: www.someserver.com/reports/Report.aspx?EndDate=12/31/2005

    Is it possible to grab the query string 'EndDate' and display it on the report using SQL Reporting Services?

    If I can't do that, is there a function that I can use that takes a date parameter and adds/subtracts days from that date and displays the result on the page as part of the header?

    Thanks in adavnce.
  2. Madhivanan Moderator

    Do you want to Extract only EndDate=12/31/2005 from the QueryString?

    Madhivanan

    Failing to plan is Planning to fail
  3. liorlankri New Member

    I have si,ilaqr problem: how to input paramater in the sql report?
  4. Madhivanan Moderator

    In your Front end application cant you pass parameter like this as that of Crystal Reports?

    Report.parameter(0)="somevalue"

    Madhivanan

    Failing to plan is Planning to fail

Share This Page