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 gkittelson 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. zfge01

    Break field results into horizontal

    Looks good so far, but how do I get it to show the Site identified per activity type..basically need it to look something like Site Name Active On Order Pending 2000400 SMITH BBLZ0595 88121 F28 T3Z S **so showing all the detail for each site,, will have hundreds/thousands of info per...
  2. zfge01

    Break field results into horizontal

    I have a string type field that will show activity type of a circuit. For instance: Active, Reserved, On Order, Pending, Disconnected. My report needs to show each activity type horizontally across the page with total sites by each activity type. I am not sure how to do this. Thank you for your...
  3. zfge01

    Pull specific amount of digits only.

    Nevermind, I just redid it and it worked. Thank you for the formula. Don't know why it didnt work the first few times, But it does now
  4. zfge01

    Pull specific amount of digits only.

    My field is 10 digit string return values with no selection criteria look like this: 5712019 4000417 5712010 350351 48201 385401 so I want I want is to not show site id's like the first 3 listed here. Just site ids that are ONLY 6 digits long. I tried your formula in the editor and pulled the...
  5. zfge01

    Pull specific amount of digits only.

    I have a site id field. I need to limit my report to show only those sites that are 6 digits longs. Nothing more, nothing less. How can I accomplish this? Thank you.
  6. zfge01

    Outlook 2007 folder and calendar view

    Is there a way, as there was in 2003 I am told, to view Saturday and Sunday in one combined block? Also is there a way to reorder the folders in outlook? I have the months as folders but it wants to alphabatize them.
  7. zfge01

    Create a date from a 2 byte integer

    I tried that in my formula workshop and I receive the message: "The result of selection formula must be a boolean" Here is my formula dateadd("d", {FlightSchedule.DAY},date(1980,1,1))
  8. zfge01

    Create a date from a 2 byte integer

    LB I am teaching myself Crystal Reports so forgive this less than knowledgeable question. Do I place that formula exactly or do I need to "define" anything, like "table"? or "D"? THANK YOU
  9. zfge01

    Create a date from a 2 byte integer

    My software stores dates as 2 byte integers which represent the difference in days from 01-01-1980. I need a formula to change this field on reports to a date field, no matter how many days show up for each entry in the field. For example if its 8,972 in the field, what formula do I use to...

Part and Inventory Search

Back
Top