Visual Basic Crystal Reports - Select Expert problem

Author

Select Expert problem

Dr. IEM

2006-04-08, 10:04 pm

Hello,

I have created reports using this tool. What I've noticed is that if you use
a date/time field with the "is between" option, all the records are not
retrieved. For example, if the last data is 1/14/2004, you may or may not
get any records that have 1/14/2004 returned. It seems to depend on the time
in the date/time field. Other than enter the date AFTER the date that you
really need, in this example enter 1/15/2004, is there another way to get CR
XI to return records on the last date that you enter?

--
Indera
* * * * * * * * * *
Don't just live life.
Live life well.

Wayne Wengert

2006-04-09, 8:04 am

Indera;

I am not an expert and you'll probably get more advice but think you have
the right idea of the problem. On the end date, set the time portion to
something like "23:59:59" to include that whole day.

HTH

Wayne

"Dr. IEM" <dr.iem.bugoff@cant.spam.me> wrote in message
news:ugqKqb4WGHA.2268@TK2MSFTNGP02.phx.gbl...
> Hello,
>
> I have created reports using this tool. What I've noticed is that if you
> use
> a date/time field with the "is between" option, all the records are not
> retrieved. For example, if the last data is 1/14/2004, you may or may not
> get any records that have 1/14/2004 returned. It seems to depend on the
> time
> in the date/time field. Other than enter the date AFTER the date that you
> really need, in this example enter 1/15/2004, is there another way to get
> CR
> XI to return records on the last date that you enter?
>
> --
> Indera
> * * * * * * * * * *
> Don't just live life.
> Live life well.
>
>
>

Iain Sharp

2006-04-10, 4:11 am

On Sat, 8 Apr 2006 23:37:25 -0400, "Dr. IEM"
<dr.iem.bugoff@cant.spam.me> wrote:

>Hello,
>
>I have created reports using this tool. What I've noticed is that if you use
>a date/time field with the "is between" option, all the records are not
>retrieved. For example, if the last data is 1/14/2004, you may or may not
>get any records that have 1/14/2004 returned. It seems to depend on the time
>in the date/time field. Other than enter the date AFTER the date that you
>really need, in this example enter 1/15/2004, is there another way to get CR
>XI to return records on the last date that you enter?

Use date({field}) is between {param1} and {param2} where the two
parameters are date fields rather than date time.

Iain

Dixon

2006-04-10, 4:11 am

If u r using a date field in a grouping condition then u need to
specify on what basis u need to group these fields....like in Annually,
Biw

ly, Monthly, Daily.......or wat ever......

Ive done this in code as below....

Cr.AddGroup intGroupAdd, Cr.Database.Tables(1).Fields(intField),
crGCDaily, crAscendingOrder

Dr. IEM

2006-04-19, 7:07 pm

thank you wayne. i was thinking i couldn't count the records (smile)

--
Indera
* * * * * * * * * *
Don't just live life.
Live life well.

"Wayne Wengert" <wayneSKIPSPAM@wengert.org> wrote in message
news:%23CUjD48WGHA.1084@TK2MSFTNGP04.phx.gbl...
: Indera;
:
: I am not an expert and you'll probably get more advice but think you
have
: the right idea of the problem. On the end date, set the time portion to
: something like "23:59:59" to include that whole day.
:
: HTH
:
: Wayne
:
: "Dr. IEM" <dr.iem.bugoff@cant.spam.me> wrote in message
: news:ugqKqb4WGHA.2268@TK2MSFTNGP02.phx.gbl...
: > Hello,
: >
: > I have created reports using this tool. What I've noticed is that if you
: > use
: > a date/time field with the "is between" option, all the records are not
: > retrieved. For example, if the last data is 1/14/2004, you may or may
not
: > get any records that have 1/14/2004 returned. It seems to depend on the
: > time
: > in the date/time field. Other than enter the date AFTER the date that
you
: > really need, in this example enter 1/15/2004, is there another way to
get
: > CR
: > XI to return records on the last date that you enter?
: >
: > --
: > Indera
: > * * * * * * * * * *
: > Don't just live life.
: > Live life well.
: >
: >
: >
:
:

Dr. IEM

2006-04-19, 7:07 pm

hi iain,

are you saying that i can change a date/time field to a date field on the
fly?

--
Indera
* * * * * * * * * *
Don't just live life.
Live life well.

"Iain Sharp" <iains@pciltd.co.uk> wrote in message
news:715k3295pemb2mj8506589hvtfet67u7g3@
4ax.com...
: On Sat, 8 Apr 2006 23:37:25 -0400, "Dr. IEM"
: <dr.iem.bugoff@cant.spam.me> wrote:
:
: >Hello,
: >
: >I have created reports using this tool. What I've noticed is that if you
use
: >a date/time field with the "is between" option, all the records are not
: >retrieved. For example, if the last data is 1/14/2004, you may or may not
: >get any records that have 1/14/2004 returned. It seems to depend on the
time
: >in the date/time field. Other than enter the date AFTER the date that you
: >really need, in this example enter 1/15/2004, is there another way to get
CR
: >XI to return records on the last date that you enter?
:
: Use date({field}) is between {param1} and {param2} where the two
: parameters are date fields rather than date time.
:
: Iain

Dr. IEM

2006-04-19, 7:07 pm

thank you dixon. i was hoping that i could do this without writing code.

--
Indera
* * * * * * * * * *
Don't just live life.
Live life well.

"Dixon" <vijaydixon@gmail.com> wrote in message
news:1144659181.746016.315100@e56g2000cwe.googlegroups.com...
: If u r using a date field in a grouping condition then u need to
: specify on what basis u need to group these fields....like in Annually,
: Biw

ly, Monthly, Daily.......or wat ever......
:
: Ive done this in code as below....
:
: Cr.AddGroup intGroupAdd, Cr.Database.Tables(1).Fields(intField),
: crGCDaily, crAscendingOrder
:

Iain Sharp

2006-04-20, 4:06 am

On Wed, 19 Apr 2006 20:55:24 -0400, "Dr. IEM"
<dr.iem.bugoff@cant.spam.me> wrote:

>hi iain,
>
>are you saying that i can change a date/time field to a date field on the
>fly?

Pretty much,

I don't know if there's a performance hit because the database server
can't process the where clause and Crystal has to do it for you.

date({datetime field}) will return a date only value, which is
therefore testable against date only parameters.

Iain

Sponsored Links