Search results for query: *

That works like a dream LB, once again many thanks for your help.

Hi there I have a field for contact name, which i need to split logically into 2 fields, being first name and last name. Currently the name could be formatted like.... J P Murphy John Murhpy JP Murphy The majority of records are split john Murphy, so I want to say anything to the left of the...

Thanks again. Lastly (I hope), if I want to start it from a point in time rather than current date, so if I want the first month to be 200401 for instance, how do I amend the first formula to look for that date. Once again thankyou for your support, I'm 95% there.

Hi there, that's worked a treat, thankyou for all of your help. The only query I have left is that if I wanted titles for those, how do I go about doing that. I'd need the format of the 200910 to move along with the formula's, so a formula for the headings?

Hi there, the first formula did work, and the period field is a number. I did the grouping and the summed values, and for the first formula it works fine. This is the first formula.... //{@currentmonth}: if totext({RPT_JXNARIS_ROLLOUT.Period}) = totext(currentdate,"yyyyMM") then Sum...

Hi there, it appears to work for the first formula, but the 2nd returns 0's. I think it's due to the period field being a number (200910 - actually a number field in DB), so how would I go about re-writing it to be a number formula, so it would need converting to a date to add the one month on...

Hi there, thanks for the reply. I think a manual cross tab could be the way to go. Currently the date is a string (e.g. 200910, 200911, 200912) So I can sort in to alphabetical and it would order correctly. The problem I have, is that I have 12 lines for one item for each year, and some go...

Hi there, slight complex report I'm trying to create. Using Crystal 2008 with SQL. I am reporting off of one view, which makes this simple from a data point of view. What I have is this as lines of data..... Company Name Product Revenue Month Bob A £450 200907 Bob...

Hi there, thanks for your response. it doesn't quite work as you say to insert the 2nd formula into the details section. I haven't actually any data in the details section, as I have multiple groups showing info below the first group, and those groups show the data instead of the details...

Hi there, using SQL and Crystal 2008. I have a page header that has title for the columns in the report. This is all fine. However, the fist page on the first group is a graph for that group. I don't want the page header titles to show on a report, just the data pages. How can I supress the page...

Hi there, sure this is easy but cannot nail it down. I have a field thats a number field (SQL & CR2008) that I need converting to a date. The field example is..... 200810 I need to be able to see that as a date. Using CDate converts it very badly, as it then shows the year as 2449 on every...

The problem is graphing on the date, as one ticket could have a start and end date being in the same month, so that ticket should appear under the created section, and the closed section, so grouping would mean one or the other. There must be a way to do this somehow.

Hi there, CR2008 using SQL. I'm reporting from a Helpdesk call logging system. When you log a call it enters a record into a table, stamps it with the creation date, and has an action..... call No id Action Create date Modify Date 16919 23 Create 01/01/2009 01/01/2009...

Hi there, using SQL with Crystal 2008. What I'm looking to do is remove a group based on the what's entered into a parameter. Currently I have data looking like this.... Item 1 Quality Tops 2 Socks 3 Jeans 4 Item 2 Shoes 2 Hankys 3 Blankets...

That's done the trick, thanks once again for your help.

Hi there, yes sorry there is one field that contains the stage 1, stage 2 etc.... So one record would be Company=Tek-tips PLC (company table) Stage 1% - 20/12/2008 (history table) Stage 2% - 24/12/2008 (history table) so one to many from company to history. I need to be able to say the days...

Hi there, using crystal 2008 on SQL. I currently have a report that shows.... Stage 1% 01/12/2008 Stage 2% 10/12/2008 Stage 3% 21/12/2008 Basically they are three history records related to the same company, so it keeps track of when their issue is moved forward. Every time it moves...

Hi there, thanks a lot, nailed it in the end, thanks for your help

Hi there, sorry I'm running CR 2008. I've tried the Time {field}option but it just returns 0's. I guess it needs to be split out but not sure how to do that?

Hi there, I'm looking for a time conversion into HH:MM:SS from a field that outputs the date as... 72233 = meaning it's 07:22:33 104532 = 10:45:32 130427 = 13:04:27 Any help would be appriciated. Regards