Crystal formula help

Aha! How about:

nextdate = datevalue(nextvalue({BAQReportResult.LaborHed.ClockInDate}))

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dan Shallbetter
Sent: Friday, November 30, 2007 8:21 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal formula help



Hello Ken,

The NextValue function returns the value of the next record of the
specified field. This reports was done years ago back when I could
remember things! I think the formula came from another user in this
group. I too normally use Crystal syntax

Thanks,

Dan

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Ken Williams
Sent: Friday, November 30, 2007 8:36 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal formula help

I can't tell you what may have changed as I started on 8.00. In
addition, I've only really dived heavily into Crystal the last few
months from .305 & .403. Going further, I do all my Crystal programming
in Crystal Syntax, not Basic, so there's anther barrier there. Lastly,
I haven't used the nextvalue function before and crystal help isn't
exactly clear on what it does.

All that being said, if what you did were done with Crystal equivalents,
I can't see anything wrong with the syntax. What does the nextvalue
function do exactly?

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Dan Shallbetter
Sent: Friday, November 30, 2007 7:22 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal formula help

Hello Ken,

Thanks for the reply. I am trying to convert a Vantage 5.0 weekly
attendance (feeds ADP) report into my test 8. 0403C environment. The
data dictionary display a field type of "DATE" for Laborhed.ClockInDate
Crystal calls it a "date/time" field. Did the BAQ change the field type?
Applying the same date conversion to the nextdate variable as I used in
thisdate it errors out and wants a field after the nextvalue function.

This formula is the problem.

Vantage 8.0.4023

dim thisdate as date

dim nextdate as date

dim output as string

thisdate = datevalue({BAQReportResult.LaborHed.ClockInDate})+ 1

nextdate = nextvalue (datevalue({BAQReportResult.LaborHed.ClockInDate}))
Original line nextdate = nextvalue({LaborHed.ClockInDate})

do while nextdate - thisdate > 0

output = output + totext(thisdate, "MM/dd/yy") + chr(10)

thisdate = thisdate + 1

loop

formula = output

Thanks,

Dan

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Ken Williams
Sent: Thursday, November 29, 2007 4:17 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal formula help

I use the date() function from Crystal for these situations:

thisdate = date({BAQReportResult.LaborHed.ClockInDate}) + 1

Ken

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Dan Shallbetter
Sent: Thursday, November 29, 2007 3:12 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal formula help

I am converting an old ODBC data source report (Crystal 8.5) to an XML
data source (Crystal XI) report the following formula returns a Date
field required here error

thisdate = {BAQReportResult.LaborHed.ClockInDate}+ 1 This formula
worked previously checking the field type for
BAQReportResult.LaborHed.ClockInDate shows it as a Date / time field

Any ideas?

Thanks,

Dan Shallbetter

[

.

<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
>
<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
>
>
Id=60976/stime=1196374516/nc1=4507179/nc2=4706133/nc3=5008825>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
I am converting an old ODBC data source report (Crystal 8.5) to an XML
data source (Crystal XI) report the following formula returns a Date
field required here error

thisdate = {BAQReportResult.LaborHed.ClockInDate}+ 1 This formula
worked previously checking the field type for
BAQReportResult.LaborHed.ClockInDate shows it as a Date / time field



Any ideas?



Thanks,



Dan Shallbetter







[Non-text portions of this message have been removed]
I use the date() function from Crystal for these situations:

thisdate = date({BAQReportResult.LaborHed.ClockInDate}) + 1

Ken


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dan Shallbetter
Sent: Thursday, November 29, 2007 3:12 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal formula help



I am converting an old ODBC data source report (Crystal 8.5) to an XML
data source (Crystal XI) report the following formula returns a Date
field required here error

thisdate = {BAQReportResult.LaborHed.ClockInDate}+ 1 This formula
worked previously checking the field type for
BAQReportResult.LaborHed.ClockInDate shows it as a Date / time field

Any ideas?

Thanks,

Dan Shallbetter

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
Hello Ken,



Thanks for the reply. I am trying to convert a Vantage 5.0 weekly
attendance (feeds ADP) report into my test 8. 0403C environment. The
data dictionary display a field type of "DATE" for Laborhed.ClockInDate
Crystal calls it a "date/time" field. Did the BAQ change the field type?
Applying the same date conversion to the nextdate variable as I used in
thisdate it errors out and wants a field after the nextvalue function.

This formula is the problem.

Vantage 8.0.4023

dim thisdate as date

dim nextdate as date

dim output as string

thisdate = datevalue({BAQReportResult.LaborHed.ClockInDate})+ 1

nextdate = nextvalue (datevalue({BAQReportResult.LaborHed.ClockInDate}))
Original line nextdate = nextvalue({LaborHed.ClockInDate})

do while nextdate - thisdate > 0

output = output + totext(thisdate, "MM/dd/yy") + chr(10)

thisdate = thisdate + 1

loop

formula = output



Thanks,

Dan











From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ken Williams
Sent: Thursday, November 29, 2007 4:17 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal formula help



I use the date() function from Crystal for these situations:

thisdate = date({BAQReportResult.LaborHed.ClockInDate}) + 1

Ken

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Dan Shallbetter
Sent: Thursday, November 29, 2007 3:12 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal formula help

I am converting an old ODBC data source report (Crystal 8.5) to an XML
data source (Crystal XI) report the following formula returns a Date
field required here error

thisdate = {BAQReportResult.LaborHed.ClockInDate}+ 1 This formula
worked previously checking the field type for
BAQReportResult.LaborHed.ClockInDate shows it as a Date / time field

Any ideas?

Thanks,

Dan Shallbetter

[

.


<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
Id=60976/stime=1196374516/nc1=4507179/nc2=4706133/nc3=5008825>




[Non-text portions of this message have been removed]
I can't tell you what may have changed as I started on 8.00. In
addition, I've only really dived heavily into Crystal the last few
months from .305 & .403. Going further, I do all my Crystal programming
in Crystal Syntax, not Basic, so there's anther barrier there. Lastly,
I haven't used the nextvalue function before and crystal help isn't
exactly clear on what it does.

All that being said, if what you did were done with Crystal equivalents,
I can't see anything wrong with the syntax. What does the nextvalue
function do exactly?


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dan Shallbetter
Sent: Friday, November 30, 2007 7:22 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal formula help



Hello Ken,

Thanks for the reply. I am trying to convert a Vantage 5.0 weekly
attendance (feeds ADP) report into my test 8. 0403C environment. The
data dictionary display a field type of "DATE" for Laborhed.ClockInDate
Crystal calls it a "date/time" field. Did the BAQ change the field type?
Applying the same date conversion to the nextdate variable as I used in
thisdate it errors out and wants a field after the nextvalue function.

This formula is the problem.

Vantage 8.0.4023

dim thisdate as date

dim nextdate as date

dim output as string

thisdate = datevalue({BAQReportResult.LaborHed.ClockInDate})+ 1

nextdate = nextvalue (datevalue({BAQReportResult.LaborHed.ClockInDate}))
Original line nextdate = nextvalue({LaborHed.ClockInDate})

do while nextdate - thisdate > 0

output = output + totext(thisdate, "MM/dd/yy") + chr(10)

thisdate = thisdate + 1

loop

formula = output

Thanks,

Dan

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Ken Williams
Sent: Thursday, November 29, 2007 4:17 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal formula help

I use the date() function from Crystal for these situations:

thisdate = date({BAQReportResult.LaborHed.ClockInDate}) + 1

Ken

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Dan Shallbetter
Sent: Thursday, November 29, 2007 3:12 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal formula help

I am converting an old ODBC data source report (Crystal 8.5) to an XML
data source (Crystal XI) report the following formula returns a Date
field required here error

thisdate = {BAQReportResult.LaborHed.ClockInDate}+ 1 This formula
worked previously checking the field type for
BAQReportResult.LaborHed.ClockInDate shows it as a Date / time field

Any ideas?

Thanks,

Dan Shallbetter

[

.

<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
>
Id=60976/stime=1196374516/nc1=4507179/nc2=4706133/nc3=5008825>


[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
Hello Ken,



The NextValue function returns the value of the next record of the
specified field. This reports was done years ago back when I could
remember things! I think the formula came from another user in this
group. I too normally use Crystal syntax



Thanks,

Dan



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ken Williams
Sent: Friday, November 30, 2007 8:36 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal formula help



I can't tell you what may have changed as I started on 8.00. In
addition, I've only really dived heavily into Crystal the last few
months from .305 & .403. Going further, I do all my Crystal programming
in Crystal Syntax, not Basic, so there's anther barrier there. Lastly,
I haven't used the nextvalue function before and crystal help isn't
exactly clear on what it does.

All that being said, if what you did were done with Crystal equivalents,
I can't see anything wrong with the syntax. What does the nextvalue
function do exactly?


________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Dan Shallbetter
Sent: Friday, November 30, 2007 7:22 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal formula help

Hello Ken,

Thanks for the reply. I am trying to convert a Vantage 5.0 weekly
attendance (feeds ADP) report into my test 8. 0403C environment. The
data dictionary display a field type of "DATE" for Laborhed.ClockInDate
Crystal calls it a "date/time" field. Did the BAQ change the field type?
Applying the same date conversion to the nextdate variable as I used in
thisdate it errors out and wants a field after the nextvalue function.

This formula is the problem.

Vantage 8.0.4023

dim thisdate as date

dim nextdate as date

dim output as string

thisdate = datevalue({BAQReportResult.LaborHed.ClockInDate})+ 1

nextdate = nextvalue (datevalue({BAQReportResult.LaborHed.ClockInDate}))
Original line nextdate = nextvalue({LaborHed.ClockInDate})

do while nextdate - thisdate > 0

output = output + totext(thisdate, "MM/dd/yy") + chr(10)

thisdate = thisdate + 1

loop

formula = output

Thanks,

Dan

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Ken Williams
Sent: Thursday, November 29, 2007 4:17 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal formula help

I use the date() function from Crystal for these situations:

thisdate = date({BAQReportResult.LaborHed.ClockInDate}) + 1

Ken

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Dan Shallbetter
Sent: Thursday, November 29, 2007 3:12 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal formula help

I am converting an old ODBC data source report (Crystal 8.5) to an XML
data source (Crystal XI) report the following formula returns a Date
field required here error

thisdate = {BAQReportResult.LaborHed.ClockInDate}+ 1 This formula
worked previously checking the field type for
BAQReportResult.LaborHed.ClockInDate shows it as a Date / time field

Any ideas?

Thanks,

Dan Shallbetter

[

.

<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
>
Id=60976/stime=1196374516/nc1=4507179/nc2=4706133/nc3=5008825>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]