Crystal Reports Date format in SelectionFormula

Writing Code
Crystal Reports Forum : Crystal Reports .NET 2003 : Writing Code

Topic: Date format in SelectionFormula
	<< Prev Page of 2

Author	Message
shabbi Newbie Joined: 21 Oct 2008 Location: India Online Status: Offline Posts: 4	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 Logged

shabbi Newbie Joined: 21 Oct 2008 Location: India Online Status: Offline Posts: 4	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 Logged

j_tush Newbie Joined: 20 Oct 2009 Location: India Online Status: Offline Posts: 4	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 Logged

Vertex Newbie Joined: 29 Oct 2009 Location: India Online Status: Offline Posts: 24	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 Logged

Vertex Newbie Joined: 29 Oct 2009 Location: India Online Status: Offline Posts: 24	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 Logged

Vertex Newbie Joined: 29 Oct 2009 Location: India Online Status: Offline Posts: 24	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 Logged

Brinda Newbie Joined: 27 Nov 2011 Online Status: Offline Posts: 7	Posted: 27 Nov 2011 at 9:34pm
	It s Working For me thanks :)
	Thanks & Regards
	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.032 seconds.