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

  • Users: metaldude
  • Content: Threads
  • Order by date
  1. metaldude

    forcing null results to show

    I'm using Crystal Reports 2008 with an ODBC connection to a SQL database. Most everything I need is in a table called RECEIPT_LINES. I have a few tables inner joined to it so I can give some user friendly info (for example, the department's name vs code). I'm trying to show every Store even...
  2. metaldude

    DateAdd results in unexpected SQL query- ideas?

    Hi and thanks in advance for any help you can give. Information: --CR 8.5 --Gupta SQL db --2 of my parameters are for start and end date --attempting to also select same start and end date but 1 year before --parameters I entered were 6/19/07 and 6/21/07 --results show in cross tab but with...
  3. metaldude

    calculations with sums from the same group but different time periods

    i'm new to crystal and this forum and apologize up front for making up my own syntax to try to explain what i mean. i'd love any help anyone can offer. background: i have a report that shows sales for 3 diferent quarters. there are 3 groupings: product department, time period sold, and product...

Part and Inventory Search

Back
Top