index | search | no replies | posting guidelines | help login | register
Index » Products » ASP Report Wizard v2
search this forum:
:: Stored procedures and parameters :: (2)Post a New Message | Post a Reply
Aug 3 2006, 12:02 PM
 Stored procedures and parametersPost a Reply
 wballhorst

View this author's profile Send this author a private message

since: Aug 3, 2006
from: Mechanicsburg, PA

Is there a way to pass the input parameter values to a stored procedure based report at run time?

Below is the stored procedure I am testing with.  I need to create a report based upon this and then at run time, without user input, pass values for the 2 parameters and have the report display the result.  Can that be done?
  
CREATE PROCEDURE USP_GETCONSIGNLOCATIONINVENTORY
    (
    @P_LOCATION            NVARCHAR(255),
    @P_CATALOGSET        NVARCHAR(255)
    )
AS

    SET NOCOUNT ON

    SELECT    CLI.Location,
            CLI.PartNumber,
            CONVERT(VARCHAR, CLI.LastReceivedDate, 101) AS LastReceivedDate,
            CLI.QuantityOnHand,
            CC.[Description]
    FROM        ConsignmentLocationInventory CLI
    INNER JOIN    HarscoProducts_CustomCatalog CC
        ON    CC.PartNumber = CLI.PartNumber
        AND    CC.CatalogSet = @P_CatalogSet
    WHERE    CLI.Location = @P_LOCATION
    ORDER BY    CLI.PartNumber

GO


Aug 3 2006, 1:38 PM
 Re: Stored procedures and parametersPost a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

The best fix for now will be to just add another parameter to your stored procedure for LastDate as follows:

objWiz.UseProcedures = "USP_GETCONSIGNLOCATIONINVENTORY,@P_LOCATION='CYLTECH IL', @P_CATALOGSET='CylTec', @LastReceivedDate = '"& FormatDatetime(Now,2) &"'"

P/S: We are working very hard to fully support stored procedures.




-------------------------
Ghost
Pages: (1)   [1]

search this forum: