Date Parameter

hi All
I am quiet new to sql reporting so would really appreciate some help. I am
using this with CRM 3.0
I want to do a report where user can select a to date and a from date to see
all completed phone calls. However both the to and the from are based on one
field called actualend.
Actual end is a date time field but in the layout tab i have used the function
=Format(Fields!Phone_Call_Completed_Date.Value,"dd-MM-yy") to format this
into just a dd-mm-yy value. Now i want to create a paramater where user can
select a start date and an end date to report. Can someone please guide me
how to go about this.
I have tried using the @.>=actualend parameter under the data tab. It works
for that but does not work under the reports tab. I can see it as a parameter
under report - report parameters but when i run the report with a date say
14/05/07 i get the error as
An error occured during local report processing.
An error has occurred during report processing.
Cannot read the next data row for the data set CRM_MSCRM
Arithmetic overflow error converting expression to data type datetime.
I would really appreciate some help.
Thanks and Regards
Ridhimai have managed to go one step beyond and set up a parameter which uses the
value as mm/dd/yy... how can i change it to so user can enter a value in
dd-mm-yy format. the parameter type is strng.
"Ridhima Sood" wrote:
> hi All
> I am quiet new to sql reporting so would really appreciate some help. I am
> using this with CRM 3.0
> I want to do a report where user can select a to date and a from date to see
> all completed phone calls. However both the to and the from are based on one
> field called actualend.
> Actual end is a date time field but in the layout tab i have used the function
> =Format(Fields!Phone_Call_Completed_Date.Value,"dd-MM-yy") to format this
> into just a dd-mm-yy value. Now i want to create a paramater where user can
> select a start date and an end date to report. Can someone please guide me
> how to go about this.
> I have tried using the @.>=actualend parameter under the data tab. It works
> for that but does not work under the reports tab. I can see it as a parameter
> under report - report parameters but when i run the report with a date say
> 14/05/07 i get the error as
> An error occured during local report processing.
> An error has occurred during report processing.
> Cannot read the next data row for the data set CRM_MSCRM
> Arithmetic overflow error converting expression to data type datetime.
> I would really appreciate some help.
> Thanks and Regards
> Ridhima|||That option is not available instead you can use date picker or seperate all
three in 3 parameters like mm, dd, yyyy and then concatenate..
Amarnath
"Ridhima Sood" wrote:
> i have managed to go one step beyond and set up a parameter which uses the
> value as mm/dd/yy... how can i change it to so user can enter a value in
> dd-mm-yy format. the parameter type is strng.
> "Ridhima Sood" wrote:
> > hi All
> >
> > I am quiet new to sql reporting so would really appreciate some help. I am
> > using this with CRM 3.0
> >
> > I want to do a report where user can select a to date and a from date to see
> > all completed phone calls. However both the to and the from are based on one
> > field called actualend.
> >
> > Actual end is a date time field but in the layout tab i have used the function
> > =Format(Fields!Phone_Call_Completed_Date.Value,"dd-MM-yy") to format this
> > into just a dd-mm-yy value. Now i want to create a paramater where user can
> > select a start date and an end date to report. Can someone please guide me
> > how to go about this.
> >
> > I have tried using the @.>=actualend parameter under the data tab. It works
> > for that but does not work under the reports tab. I can see it as a parameter
> > under report - report parameters but when i run the report with a date say
> > 14/05/07 i get the error as
> > An error occured during local report processing.
> > An error has occurred during report processing.
> > Cannot read the next data row for the data set CRM_MSCRM
> > Arithmetic overflow error converting expression to data type datetime.
> >
> > I would really appreciate some help.
> >
> > Thanks and Regards
> > Ridhima|||hi Amarnath
When i use the date picker it doesnt work either.. displays and error:(
"Amarnath" wrote:
> That option is not available instead you can use date picker or seperate all
> three in 3 parameters like mm, dd, yyyy and then concatenate..
> Amarnath
> "Ridhima Sood" wrote:
> > i have managed to go one step beyond and set up a parameter which uses the
> > value as mm/dd/yy... how can i change it to so user can enter a value in
> > dd-mm-yy format. the parameter type is strng.
> >
> > "Ridhima Sood" wrote:
> >
> > > hi All
> > >
> > > I am quiet new to sql reporting so would really appreciate some help. I am
> > > using this with CRM 3.0
> > >
> > > I want to do a report where user can select a to date and a from date to see
> > > all completed phone calls. However both the to and the from are based on one
> > > field called actualend.
> > >
> > > Actual end is a date time field but in the layout tab i have used the function
> > > =Format(Fields!Phone_Call_Completed_Date.Value,"dd-MM-yy") to format this
> > > into just a dd-mm-yy value. Now i want to create a paramater where user can
> > > select a start date and an end date to report. Can someone please guide me
> > > how to go about this.
> > >
> > > I have tried using the @.>=actualend parameter under the data tab. It works
> > > for that but does not work under the reports tab. I can see it as a parameter
> > > under report - report parameters but when i run the report with a date say
> > > 14/05/07 i get the error as
> > > An error occured during local report processing.
> > > An error has occurred during report processing.
> > > Cannot read the next data row for the data set CRM_MSCRM
> > > Arithmetic overflow error converting expression to data type datetime.
> > >
> > > I would really appreciate some help.
> > >
> > > Thanks and Regards
> > > Ridhima|||What I meant was you can use date picker for just picking dates in any ormat,
because this type of formatting upfront is not possible.
Amarnath
"Ridhima Sood" wrote:
> hi Amarnath
> When i use the date picker it doesnt work either.. displays and error:(
> "Amarnath" wrote:
> > That option is not available instead you can use date picker or seperate all
> > three in 3 parameters like mm, dd, yyyy and then concatenate..
> >
> > Amarnath
> >
> > "Ridhima Sood" wrote:
> >
> > > i have managed to go one step beyond and set up a parameter which uses the
> > > value as mm/dd/yy... how can i change it to so user can enter a value in
> > > dd-mm-yy format. the parameter type is strng.
> > >
> > > "Ridhima Sood" wrote:
> > >
> > > > hi All
> > > >
> > > > I am quiet new to sql reporting so would really appreciate some help. I am
> > > > using this with CRM 3.0
> > > >
> > > > I want to do a report where user can select a to date and a from date to see
> > > > all completed phone calls. However both the to and the from are based on one
> > > > field called actualend.
> > > >
> > > > Actual end is a date time field but in the layout tab i have used the function
> > > > =Format(Fields!Phone_Call_Completed_Date.Value,"dd-MM-yy") to format this
> > > > into just a dd-mm-yy value. Now i want to create a paramater where user can
> > > > select a start date and an end date to report. Can someone please guide me
> > > > how to go about this.
> > > >
> > > > I have tried using the @.>=actualend parameter under the data tab. It works
> > > > for that but does not work under the reports tab. I can see it as a parameter
> > > > under report - report parameters but when i run the report with a date say
> > > > 14/05/07 i get the error as
> > > > An error occured during local report processing.
> > > > An error has occurred during report processing.
> > > > Cannot read the next data row for the data set CRM_MSCRM
> > > > Arithmetic overflow error converting expression to data type datetime.
> > > >
> > > > I would really appreciate some help.
> > > >
> > > > Thanks and Regards
> > > > Ridhima