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 Chris Miller 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. siboyd07

    Crystal Report sort problem, need to strip out data and convert to num

    That worked! Thanks so much. I've been working on this all day.
  2. siboyd07

    Crystal Report sort problem, need to strip out data and convert to num

    This worked well for the 1st part but if there is no 2nd dash I'm getting the error "A subscript must be between 1 and the size of the array" The problem is the number of dashes is not always the same. Sometimes the card_no could be 500-1-1, 500-10, 500, hec-10-1. I basically need to look at...
  3. siboyd07

    Crystal Report sort problem, need to strip out data and convert to num

    I have a text field (Card_no) that sometimes contains numbers and it sometimes contains both numbers and letters. Example: 500-10-2 500-1-2 hec-1 hec-1-a When the fields contains numbers they need to be sorted as 500-1-2 500-10-2 because 1 comes before 10. I'm having a problem figuring out a...
  4. siboyd07

    Need to use a concatenated footer field in a heading title

    The two groups are the same. I just added one because the instructions said to suppress one of them. I hadn't thought about a crosstab as a heading so I'll try that. That might be the simplest method to accomplish my goal.
  5. siboyd07

    Need to use a concatenated footer field in a heading title

    I moved these around everywhere and I can't get the @displayed value to end up in the header. It works like it should in the footer. I even tried to remove the @reset from the report and it still didn't work. Group 1 is WHcode (suppressed) Group 2 is whcode //{@reset} for the group header...
  6. siboyd07

    Need to use a concatenated footer field in a heading title

    I have a concatenated footer that takes each group heading and combines them all to one field. I found the formula on this site. I need to use this field in a heading but I can't seem to get it working. The field is reset once I try to reference the field in the heading formula. I'm trying...

Part and Inventory Search

Back
Top