KavyaVS
asked on
Setting Parameter Values SSRS Sql2008R2
I am using the stored procedure in the SQL Report(SSRS Sql2008R2).The stored procedure has following parameters.
(@StartDate As DateTIME ,
@EndDate As DateTIME,
@DateFilter As Varchar(MAX),
@AccountNumber AS VARCHAR(10),
@BranchID VARCHAR(500) = 0,
@Region VARCHAR(200) = 0, @OrderBy VARCHAR(100) = 'POSTDATE DESC',
@LogProgress INT = 1,
@LogError INT = 2)
The procedure returns data in sql server management studio using parameters @StartDate 1/1/2011,@EndDate 10/5/2011,@DateFilter POSTDATE BETWEEN '01/01/2011' AND '10/05/2011'
@AccountNumber 0000123456, @BranchID ('-1'), @Region 0, @OrderBy POSTDATE
In Sql Report I set the parameters DataTypes as Date/Time,Text,integer.
I am entering the same values(the values used in Sql server management studio) for StartDate,EndDate,DateFilt er,Account Number,Bra nchID,Regi on and Order_By parameters while report is running.
It is not returing any rows.Empty report is showing up.I am assuming something wrong in giving parameter values for the following parameters.
DateFilter: POSTDATE BETWEEN '01/01/2011' AND '10/05/2011'
BranchID: -1
Region: 0
Order By: POSTDATE
I entered the above values in Text Boxes.
Is there any other way to set the above parameters so that it returns the data.
Thanks
(@StartDate As DateTIME ,
@EndDate As DateTIME,
@DateFilter As Varchar(MAX),
@AccountNumber AS VARCHAR(10),
@BranchID VARCHAR(500) = 0,
@Region VARCHAR(200) = 0, @OrderBy VARCHAR(100) = 'POSTDATE DESC',
@LogProgress INT = 1,
@LogError INT = 2)
The procedure returns data in sql server management studio using parameters @StartDate 1/1/2011,@EndDate 10/5/2011,@DateFilter POSTDATE BETWEEN '01/01/2011' AND '10/05/2011'
@AccountNumber 0000123456, @BranchID ('-1'), @Region 0, @OrderBy POSTDATE
In Sql Report I set the parameters DataTypes as Date/Time,Text,integer.
I am entering the same values(the values used in Sql server management studio) for StartDate,EndDate,DateFilt
It is not returing any rows.Empty report is showing up.I am assuming something wrong in giving parameter values for the following parameters.
DateFilter: POSTDATE BETWEEN '01/01/2011' AND '10/05/2011'
BranchID: -1
Region: 0
Order By: POSTDATE
I entered the above values in Text Boxes.
Is there any other way to set the above parameters so that it returns the data.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER