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 Mike Lewis 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: R000k
  • Order by date
  1. R000k

    SP Help - Generate unique row ID's every time SP is executed

    Hello, I'm having some issues figuring out how to get this piece of code accomplished. I need to manually create a 10 digit ID number that will continually increase every time the stored procedure is executed. For instance: This is my result set the first time I execute my SP: ID...
  2. R000k

    DateTime formula for Cross-Tab Report

    Excluding the records using Select Expert worked. That was so simple I can't believe that did not come to me. I guess you learn more and more each day. Thanks you guys!
  3. R000k

    DateTime formula for Cross-Tab Report

    Hello, I am currently using Crystal 9 and I have a cross tab report that is displaying the data like the below: 2008 2009 2010 2011 2012 2013 $5 $10 $10 $20 $50 $50 I need to write a formula that will display the current year going forward so I wrote this...
  4. R000k

    Calculate "Year" from Start_Date and End_Date date range.

    Thanks Madawc for your feedback. I am currently using Crystal version 9.
  5. R000k

    Calculate "Year" from Start_Date and End_Date date range.

    Hi there, I am a Crystal newbie and I need to produce a cross-tab report that returns a "Year" column with the "Yearly rent" below. An example of data I am working with is below: Lease Name Lease_StartDate Lease_EndDate Monthly Rent Lease A 1-Nov-09 30-Jun-12 $200.00 Lease A...

Part and Inventory Search

Back
Top