July 23, 2009 at 3:29 am
Hi
I Using Datetime parameters for check the querystring in SSRS 2005
Parameters are: rpFromDate and rpToDate
i am using following way
SELECT BILL_NO,BILL_DATE,BILL_AMOUNT FROM BILL_PROCESS
WHERE BILL_DATE BETWEEN '2009-07-01' AND '2009-07-23'
PARAMETERS ARE
SELECT BILL_NO,BILL_DATE,BILL_AMOUNT FROM BILL_PROCESS
WHERE BILL_DATE BETWEEN @rpFromDate AND @rpToDate
I am getting error if any way to avoid error to get result?
I am only want to use datetime parameter.
but i am used string for the date parameter getting answer is correct.
urjent pls
Gururajan.K
July 23, 2009 at 8:30 am
What is the error you are receiving?
Eli
July 23, 2009 at 4:31 pm
Is the BILL_DATE column in the database a datetime/smalldatetime datatype or a char/varchar datatype?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 23, 2009 at 11:00 pm
Hi Eli
This is the error i am receiving
An error occured during local report processing.
the value provided for the report parameter 'rpToDate' is not valid for its type
Gururajan.K
July 23, 2009 at 11:02 pm
hi Jack Corbett
I am using datetime datatype for the BILL_DATE in my database
Gururajan.K
July 24, 2009 at 6:47 am
How about the datatypes for your parameters? Are they date to datetime?
Eli
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply