Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: slickp
  • Order by date
  1. slickp

    Date Question

    Using Crystal Reports XI Hi, i've got a date field in my report which is data inputted manually by the user, however sometimes they get the year wrong, so i've changed my report to allow for current risks only, so my parameter i would like to be able to pick only the day and month and ignore...
  2. slickp

    Supress group when sub report is blank

    Crystal 10 Hi, i've got a subreport in the details and i would like to supress the group header above it if no data is in the subreport. Any ideas? Would it need to be some sort of shared variable upon which to supress the group header?
  3. slickp

    Excel Problem

    Excel 2003 Probably a stupid question but my brain has melted with all the help desk calls i have taken today. I;ve got a spreadsheet with two columns in. One for status and one for Premium like below Status Premium Secured £10000 Declined £35000 Scured £5000 I...
  4. slickp

    Date

    Cheers mate, found the Ken Hamady site, that guy is a legend!!
  5. slickp

    Date

    Using Crystal 10, I have a date field, and in my report i need to add a formula that will add 5 business days to this date if it is retail or 30 business days to it if it is commercial. However as it is business days, i need to exclude sat and sun. Any ideas? Cheers
  6. slickp

    Date

    Good idea, cheers for that mate
  7. slickp

    Date

    Using crystal 10, i am trying to create a formula that will give me the final day of the month, 3 months back from the currentdate month. So far i have this : if Month (CurrentDate) = 1 then date ((Year (CurrentDate)-1), 09, 30) else if Month (CurrentDate) = 2 then date ((Year...
  8. slickp

    Date Formula

    Crystal 10 I have a report which needs to be scheduled to run on a server every quarter, so i need to get rid of all the parameter fields so that it can run. One of the parameters is a notified date field. Now this should be the period of the quarter, i.e. 1st quarter 1 Jan 07 to 1 April 07...
  9. slickp

    Analysis Date Question

    Quality mate, cheers
  10. slickp

    Analysis Date Question

    Crystal 10 I have a field in a table called analysisperiod, which shows the month and year of each transaction as a number in this format, 200703 for March 2007. I need to create a formula which uses the current date to create this number. I have extracted the month and year from current date...
  11. slickp

    Formatting a date

    Hi, i have a formula below: totext(dateadd("d",6,{table.date}-dayofweek({table.date})+1),"dd/MM/yyyy") However i would like the date to formatted into say "02 January 2007" rather than "02/01/2007" which is what i've got. How can i change the formula above to show the date in the formatting i...
  12. slickp

    Shared Variables

    Sorry plus i have the rest formula on the in the same group and the formula is as follows: whileprintingrecords; shared stringvar PTYPE := "";
  13. slickp

    Shared Variables

    Ok i'm using crystal 10, i have a report and a sub report and i would like a field from the sub report being placed into my main report. So i'm using shared variables. In the sub report my formula is: whileprintingrecords; shared stringvar PTYPE := ({QUOTECLIENT.FSAClientType}) and in my...
  14. slickp

    Groups in Crystal

    Is there any way around grouping a fomula which has a sum in it? It has never worked for me and its annoying cause i've got got a report at the moment which needs grouping by this formula. Basically i've created a formula for Net Commission and then summed it in a group. Then i've created a...
  15. slickp

    Excel Question

    I have a speadsheet with two columns in, and I would like to do a stats worksheet. Example of the two columns are as follows: Operator Status Donald Duck Quote Donald Duck Bound Mickey Mouse Quote Donald Duck Quote In the stats page I would like to show the number of Quotes...
  16. slickp

    Excel - Remove text from a number

    There are 17000 records, wouldnt this take a long time?
  17. slickp

    Excel - Remove text from a number

    I have a list of telephone numbers imported from a database. However the field in the database it has come from was a text box so there is text in some of the numbers i.e 01234-523532 or (01234) 254525. How can I in Excel convert these to numbers only i.e. with the examples above convert them...
  18. slickp

    Remove 0 and space from Telephone number

    I'm creating a report in Crystal and I would like to change the telephone number so that the 0 at the front of the number is removed, plus any non number characters are removed, i.e (, *, etc. The format i've got at the moment is random: 01234 358824 0171-254-2545 I would like it so that the...
  19. slickp

    Extract Values from UK Post Codes

    I tried this and it seemed to work: if isnumeric (right((split({CLIENT.PostCode}," ")[1]), 1)) and isnumeric (right((split({CLIENT.PostCode}," ")[1]), 2)) then right((split({CLIENT.PostCode}," ")[1]), 2) else if isnumeric (right((split({CLIENT.PostCode}," ")[1]), 1)) and not (isnumeric...

Part and Inventory Search

Back
Top