on 12-14-2011 5:23 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.