Search results for query: *

Hi, When exporting a date/time value (style: system default short format) from crystal to a SQL table (which by default creates a new table), I'm loosing the seconds value of the date time. eg 28/07/2009 09:01:13 becomes 28/07/2009 09:01:00. When crystal creates the table, and the field...

Hi Adam, Of course I can share .. Within the cross-tab expert, third tab 'Customize Style', sub-section 'Summarized Fields; there is an option to include lables (Show Labels). There are also a few formatting options as to where these are displayed. Kinda wished I'd looked harder before...

Solution found - - thanks for reviewing my post J

I'm using crystal XI

Hi, I have a cross tab with three datasets within the 'summarized fields' section (these relate to a positive, negative and no result received). These all output a summed numeric value. There is one 'Row' item (type) and one 'Column' item (calander day 1 to 30). I'd like to label the +ve, -ve...

Thanks Ian, perfect. Have a good day.

Hi, Newbie .. simple one .. I hope. I have 2 date/time stamps(start time:x, end time:y). I need to show the result of a formula calculating the different between these date/times (y - x) in the format of date/time ... Can i find it anywhere ..? Thanks, in advance.

hi, i have numerical data relating to the calandar day in the month. I need to display this data with calalandar date moving down the rows and two columns relating to the data for that day and a running month to date total, which will increase moving down the rows. this data will then be...

spot on, thanks. enjoy your day!

Hi, Within a table (dbo.accounts) of over 190k records, I have an email address field (varchar(50), null), within which is all sorts of data (most not email addresses). I'm looking for a method the clear the data within the field which is not an email address, and return this to a NULL value...

Thanks for the info Ian

awesome .. thanks

Hi, How could I calculate the number of working days in a month (monday to friday, excluding weekends). Also I'd need to return the current working day. I appreciate this may not be exact allowing for B/Hols's etc. Thanks, jmhc

Hi LB, Spot on - thanks. I'll post correctly next time. Cheers

edit - I'm summarising data related to the date/time stamp which is a numerical value (not summarising the actual date time stamp) JC

Hi, I have a list of data in date/time format '11/09/2008 14:11:37' and I'd like to summarise it twice, (1) once month to date and (2) on just yesterdays data. My selection expert is set to month to date so (1) is simple. How to I apply a conditional summary to acheive (2)? Thanks, in...

Thanks for the update. I suspected so. Cheers

Hi, I'm trying to convert a string to a date. The string is in the format of "200809092. I'm using the formula of Function (stringvar apex_date); cdate(apex_date[7 to 8] &"/" & apex_date [5 to 6]&"/" & apex_date [1 to 4]) There are no conditions for the user when entering the string. When...