X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> New To Crystal Reports, Crystal Reports 2008    
post Nov 27 2013, 05:28 AM

Posts: 1
Joined: 27-November 13

Hi ,
ew to site and very new to crystal reports,
I am doing quite well I think considering IM not a MS developer (I know its not MS but the interface is very similar).
Anyway the issue I have is seemingly a simple one, I can create a report that display s the data I want it to, but the issue I am having is any sort of string/date manipulation that I want to occur when the data returned to be changed in a minor way, in my case I would like to add two days to the order date to give an estimated delivery date.
Is there a way to do this in reports or is it JUST a templating engine that displays the data you give it and I have to use the connection to the database to manipulate the data first?
I.e create a view or a stored procedure that deals with this first and let CR display the data as needed?
If this is the case then no problem its swings and roundabouts really, I have to manipulate it somewhere, but it would be nice to know if this can be done in CP itself.
Many thanks,
Go to the top of the page
post Dec 18 2013, 11:14 AM

Posts: 178
Joined: 14-April 06
From: New England

Define the new fields in the "Formula Fields" of the field explorer.
If your date is a string, convert it to a date type and add an integer to it.
Formally you can:
dateadd("d",1,{datefield}) will add 1 day to the {datefield} value
dateadd("d",2,{datefield}) will add 2 days to the {datefield} value
dateadd("m",-1,{datefield}) will subtract 1 month from the {datefield} value.
If your date is a string like "mm/dd/yy" in the field {datestring} you can CDate({datestring}) which will convert the value to a date...
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    22nd March 2018 - 12:28 PM