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!

Register Log in
  • Congratulations derfloh 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: TymArtist
  • Order by date
  1. TymArtist

    Suppress Email or Blank Field

    I'm trying to create a report that shows a record of all the customers in our database that do NOT have an email address on file. My method was to try and use the select expert so if customer.email contains "N/A" or "" (blank) then it will show. However, it doesn't seem to like the "" command...
  2. TymArtist

    CSV Concat Text/HTML + Variable

    Can you combine variables and HTML files or not? The formula I just posted didn't work for me.
  3. TymArtist

    CSV Concat Text/HTML + Variable

    What about doing a concat using content from external HTML files? I noticed that Excel allows you to reference external files but in a concat it will just display the string reference to the file rather than displaying the content of the file itself. For instance...
  4. TymArtist

    CSV Concat Text/HTML + Variable

    I believe I'll answer my own question by referring to the concat() formula. Sorry for the empty thread, but if anyone else needs to do this that's your answer :)
  5. TymArtist

    CSV Concat Text/HTML + Variable

    In Excel, is it possible to Concat HTML Tags or Regular Text with an Excel Variable? I'm doing a CSV file for Excel where I will need HTML tags combined with data pulled from other cells, so something like <table>+$A1+blah blah blah Is this possible, or is there another way in which I can pull...
  6. TymArtist

    Displaying Selected Fields

    I attempted to use this conditinal before but is there a formula to tell if something has been suppressed or not? field.description = "" doesn't work.
  7. TymArtist

    Displaying Selected Fields

    This worked well, except now if there are two products on the page and a quantity of zero has already shown for the first product description, then it will not show it again. I was attempting to suppress the quantity only if the description = "" but that didn't seem to work. Is there a way I...
  8. TymArtist

    Displaying Selected Fields

    Wow thanks, I'm shocked at how easy these solutions are some times. Next time I'll try searching through the FAQs rather than posting here first (duh). Anyway, I'll research the grouping idea a little bit. I've dealt with it before but obviously it still goes over my head somewhat :)
  9. TymArtist

    Displaying Selected Fields

    Hey guys, I'm new to the forums and hope to learn a lot and eventually start helping people out. My knowledge of Crystal is fairly limited but they've had me working with all our reports, pretty much just Sales Order's, Invoice's, etc. The current issue is with a Packing Slip. I had to set it...

Part and Inventory Search

Back
Top