locked
Passing parameters to reporting services report RRS feed

  • Question

  • Hi, i built a reporting services report using Visual Studio 2005. This is my query "SELECT     dbo.FilteredQuote.accountidname, dbo.FilteredQuote.name,dbo.FilteredQuote.quoteid, dbo.FilteredQuoteDetail.productidname,dbo.FilteredQuoteDetail.productdescription,
                          dbo.FilteredQuoteDetail.quantity, dbo.FilteredQuoteDetail.priceperunit, dbo.FilteredQuoteDetail.extendedamount, dbo.FilteredQuote.modifiedon,
                          dbo.FilteredQuote.accountid, dbo.FilteredAccount.accountid AS Expr1, dbo.FilteredAccount.primarycontactidname, dbo.FilteredAccount.telephone1,
                          dbo.FilteredAccount.emailaddress1
    FROM         dbo.FilteredQuoteDetail INNER JOIN
                          dbo.FilteredQuote ON dbo.FilteredQuoteDetail.quoteid = dbo.FilteredQuote.quoteid INNER JOIN
                          dbo.FilteredAccount ON dbo.FilteredQuote.accountid = dbo.FilteredAccount.accountid
    where dbo.FilteredQuote.quoteid=@quoteid"
    Then i created an ISV button on the quote form that calls the report server page, this is the URL used: "http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fBPS_MSCRM%2fQuotes" i need to pass the quoteid as a parameter. How can i do it?
    It's urgent!!!

     

    Thursday, February 7, 2008 11:37 AM