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

    Building SPROCS in database

    Hello! I'm trying to figure a way to build sets of stored procedures and functions from a source database to another either using dts or t-sql. I do have a list of stored procedures listed in tableA in the source database. I'm thinking of 1. running my script thru tableA, 2. capture the...
  2. kinosaidp

    Difference between sum of a group

    Hello! I'd like to get the difference between summaries of a group something like this; group1_total = 100 <--- 1st summary group1_total = 200 <--- 2nd summary Using the 2 summaries of the above group I'd like to display my output in the report footer as Net = 100 which is a result of 2nd...
  3. kinosaidp

    Question on displaying a given type of result set in crystal

    Hi, I have a result set of records which needs to be displayed in crystal as shown below. I'm using Crystal 11 and sql2k as backend. Record set COL_A COL_B COL_C COL_D COL_E 1805 150XXXX 8/4/2007 0 100 1805 150XXXX 9/4/2007 1 200 1805 150XXXX 10/4/2007 2 300 1805 150XXXX 11/4/2007 3...
  4. kinosaidp

    &quot;Running Total Field&quot; help

    using database: SQL2000 and Crystal Report 11 The existing report is grouped by "COMPANY" then by "LINE". The body (located in the LINE group footer) displays the group amount by LINE and then the summary is displayed under the Company group footer. Based on the sample data below, the Company...

Part and Inventory Search

Back
Top