cancel
Showing results for 
Search instead for 
Did you mean: 

[HELP]Crystal Report

Former Member
0 Kudos

Hello experts, I want to create a token for my date in OINV table.

First they must select cardname and the date range, in date range let say I have Date From and Date To.

Please help.

Accepted Solutions (1)

Accepted Solutions (1)

former_member541807
Active Contributor
0 Kudos

hi,

for the cardcode selection use the ff token

BP@ Select CardCode, CardName FROM OCRD

for the daterange follow the ff.

make a new Parameter

Type: Date

List Of Values: Static

Allow Range Values: True

and the from the formula workshop put this formula

{OINV.CardCode} = {?BP@ Select CardCode, CardName FROM OCRD}

regards,

Fidel

Former Member
0 Kudos

hi,

>

> for the cardcode selection use the ff token

>

>

BP@ Select CardCode, CardName FROM OCRD

>

> for the daterange follow the ff.

>

> make a new Parameter

> Type: Date

> List Of Values: Static

> Allow Range Values: True

>

> and the from the formula workshop put this formula

>

>

{OINV.CardCode} = {?BP@ Select CardCode, CardName FROM OCRD}

>

> regards,

> Fidel

Thank you for this.

But I don't get it in the DATE.

Edited by: hikaru1207 on Dec 14, 2011 6:57 AM

former_member541807
Active Contributor
0 Kudos

hi Hikaru,

what do you mean on you cannot get it in the date?

here is how to make a new parameter

1. make new Parameter (Date) in the dropdown list choose Date

2. type - choose static from the dropdown list

3. Value options (this is the lowest part of the Create new parameter Window) find the "Allow Range Values: " the default value of this is False, hit the dropdown and select True, to allow range of values.

regards,

Fidel

Former Member
0 Kudos

hi Hikaru,

>

> what do you mean on you cannot get it in the date?

>

> here is how to make a new parameter

>

> 1. make new Parameter (Date) in the dropdown list choose Date

> 2. type - choose static from the dropdown list

> 3. Value options (this is the lowest part of the Create new parameter Window) find the "Allow Range Values: " the default value of this is False, hit the dropdown and select True, to allow range of values.

>

> regards,

> Fidel

Thank you for this, but when I run my crystal report the cardcode is true it display all the cardcode but the range was false.

former_member541807
Active Contributor
0 Kudos

hi,

put this in your Formula

{OINV.DocDate} = {?daterate} and
{OINV.CardCode} = {?BP@ Select CardCode, CardName FROM OCRD}

regards,

Fidel

Former Member
0 Kudos

Thank you for this.

It is possible to display the date range in crystal report? I want to put a Label and then the range. eg : Date From :

Former Member
0 Kudos

To put the range in the report you need to create two formula date From as MINIMUM() and Date To as MAXIMUM ()

Then add these two formula to your report

former_member541807
Active Contributor
0 Kudos

hi,

make a new Formula name it as what you desire and use this formula

totext(minimum({?DateRange})) +" To "+ totext(maximum({?DateRange}))

now you can add the formula in your report to display the date range of your current selection.

regards,

Fidel

Answers (0)