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 TouchToneTommy 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: famousoren
  • Content: Threads
  • Order by date
  1. famousoren

    Address Manipulation

    Hello, I have several thousand addresses in lowercase letters. What I would like to do is uppercase the first letter of each word (in other words, after every blank spot). I am somewhat familiar with building queries (not too savvy with VBA) so if anyone has ideas on easily accomplishing this...
  2. famousoren

    Suppressing Group Headers in Drill-Down Report

    Hello, I'm creating mailing labels in Crystal 8.0. I need to give the client the option of drilling which category they would like mailing labels printed for. However, when I drill down on a group, I don't know the way to suppress the group header so that it doesn't screw up the printing of...
  3. famousoren

    Query dilemma

    Hello!<br>I am trying to write an SQL statement that looks at an individual 'request' and then checks the audit trail to see if the issue has been reopened.&nbsp;&nbsp;If the issue has been reopened, assign the issue a &quot;1&quot;, else assign it a &quot;0&quot;<br>the final table would look...
  4. famousoren

    SQL Server driver error - defcon level 4 emergency!!

    Hello,<br><br>I've created a crystal report (V.8) that runs off a stored procedure in a SQL Server 7.&nbsp;&nbsp;When I attempt to 'convert database driver' from ODBC to pdssql.dll (SQL Server), the report shows random errors.&nbsp;&nbsp;When I try to refresh the screen using the lightning bolt...
  5. famousoren

    How do I convert minutes to days, hours, minutes

    Hello,<br>does anyone know a formula that can take an integer field for minutes and convert that into days, hours, and minutes<br>i.e.&nbsp;&nbsp;4000 minutes = 2d, 18h, 40m<br><br>Thanks,<br>Oren
  6. famousoren

    How can Crystal reports turn a blob (or memo) field into a normal fiel

    Hi everybody,<br>I'm writing a report in Crystal that requires the ability to select records on a description box that Crystal interprets as a memo or blob field.&nbsp;&nbsp;Because of that, I haven't been able to use that description field in any formulas or in the select expert<br>Has anyone...

Part and Inventory Search

Back
Top