Writing Code
 Crystal Reports Forum : Crystal Reports .NET 2003 : Writing Code
Message Icon Topic: Date format in SelectionFormula Post Reply Post New Topic
<< Prev Page  of 2
Author Message
shabbi
Newbie
Newbie
Avatar

Joined: 21 Oct 2008
Location: India
Online Status: Offline
Posts: 4
Quote shabbi Replybullet Posted: 28 Oct 2008 at 3:18am
hello GlennC,
am trying to improve the performance of crystal reports, so am using selection fromula where am giving all "where" conditions in selection fromulas. ie recode selection formula.what is hapenning now is while designing the reports it takes time to display say some 25k data.
is there any way i can improve performance?
IP IP Logged
shabbi
Newbie
Newbie
Avatar

Joined: 21 Oct 2008
Location: India
Online Status: Offline
Posts: 4
Quote shabbi Replybullet Posted: 28 Oct 2008 at 3:25am

hai,

how do i use such as  BeforeReadingRecord. suppose if i use use

BeforeReadingRecords;
{COMMAND.START_DATE}=DateValue ({?FromDate});
i get an alert message "formula cannot be evaluated at time specified"
but if i use
WhileReadingRecords;
{COMMAND.START_DATE}=DateValue ({?FromDate}); i dont get any errors
IP IP Logged
j_tush
Newbie
Newbie
Avatar

Joined: 20 Oct 2009
Location: India
Online Status: Offline
Posts: 4
Quote j_tush Replybullet Posted: 04 Nov 2009 at 11:07am
how to convert this string date to datevar ..please help me... this below formula is giving me Boolean error

datevar year_a;
stringvar montselect;
stringvar firstday:="1";
stringvar createdate;

createdate:= totext (monthselect + "/" + firstday + "/" + year_a);
datevar Finaldate:=  cDate (createdate
);

thanks for supporting me ...
Tushar Jindle
IP IP Logged
Vertex
Newbie
Newbie
Avatar

Joined: 29 Oct 2009
Location: India
Online Status: Offline
Posts: 24
Quote Vertex Replybullet Posted: 08 Nov 2009 at 12:26pm
hello....tell me please

how to get first day and last day of any month

my code is here


if {Order.CreateDateTime}=.........varible for user's selected month ........ then
{Order.CreateDateTime}<       First day of any month.........and ............last day of any month >{Order.CreateDateTime}


Edited by Vertex - 08 Nov 2009 at 12:28pm
Hi Peoples
IP IP Logged
Vertex
Newbie
Newbie
Avatar

Joined: 29 Oct 2009
Location: India
Online Status: Offline
Posts: 24
Quote Vertex Replybullet Posted: 09 Nov 2009 at 12:02pm
To select the any month from any year
and also the first date of that year &
last date of the same month
...What is code ??
Hi Peoples
IP IP Logged
Vertex
Newbie
Newbie
Avatar

Joined: 29 Oct 2009
Location: India
Online Status: Offline
Posts: 24
Quote Vertex Replybullet Posted: 25 Nov 2009 at 7:26am

how to count these records for Given Timing

count ({Order.OrderID}) ...for today
count ({Order.OrderID}) ...for this month
count ({Order.OrderID}) ...for this year
Hi Peoples
IP IP Logged
Brinda
Newbie
Newbie
Avatar

Joined: 27 Nov 2011
Online Status: Offline
Posts: 7
Quote Brinda Replybullet Posted: 27 Nov 2011 at 9:34pm
It s Working For me thanks :)Smile
Thanks & Regards
IP IP Logged
<< Prev Page  of 2
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.