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: *

  1. Folkstone

    Crystal Specified Order

    Hello, I have tried a few different options with this string field. I have firstly used: CDate({Disputes.Age_Catagory}) This returned a "bad date format" error. I then used the following formula: Formula name: CDATE stringvar strDate := {Disputes.Age_Catagory}; stringvar array arrDate :=...
  2. Folkstone

    Crystal Specified Order

    Hello, I am creating a report through crystal version 8.5 and I am working with a string field {Disputes.Age_Catagory} which contains dates within it. I am trying to extract the month and the year from this string field in order for me to create a specified grouping order. I want to see the...
  3. Folkstone

    Bursting Reports

    Hello all, I have come across a problem when trying to create a report in crystal version 8.5. I am using a string field {Disputes.Age_Category} which contains age dates within in. I need to extract the month and the year from this field and then group them into the following specified order...
  4. Folkstone

    Grand total of a field

    Thank you both. I have solved the problem now so case closed. Ended up using a subreport and shared variables which worked well. Thanks again
  5. Folkstone

    Grand total of a field

    Have been creating a report where I have created parameters to be able to choose particular dispute reasons and particular credit officers. I have created summaries however I would like to compare them to total no. of disputes whether they appear on the report or not (eg chose Credit note as a...
  6. Folkstone

    Bad Date Format

    Tried to above and I am now getting an error message as follows: Dates must be between year 1 and year 9999 I have browsed the data in the string field and I have found that some of the dates are shown as 16/06/2004 and others are shown as 16/06/04. I think that this is why I am receiving an...
  7. Folkstone

    Bad Date Format

    Tried the above formula and I am now receiving the following error message from bdreed35: A subscript must be between 1 and the size of the array Any ideas? Only new to crystal and I am more using trial and error then knowledge at the moment.
  8. Folkstone

    Bad Date Format

    Creating a formula to show days between two different fields. One of the fields is a date field and the other is a string field. I have tried to convert the string field into a date field by using the "CDate" function and I am finding that there are a few dates which are coming up as "Bad Date...

Part and Inventory Search

Back
Top