Link to home
Start Free TrialLog in
Avatar of KavyaVS
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,DateFilter,AccountNumber,BranchID,Region 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
ASKER CERTIFIED SOLUTION
Avatar of Chris McGuigan
Chris McGuigan
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of KavyaVS
KavyaVS

ASKER

Thanks