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!

Recent content by kinosaidp

  1. kinosaidp

    Building SPROCS in database

    I just want to know if somebody can help me with this one. Thanks.
  2. 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...
  3. kinosaidp

    Difference between sum of a group

    Reply below worked. Thank you all! ********************************* whileprintingrecords; numbervar A; numbervar B; if {table.group} = "Instance1" then A := sum({table.amt},{table.group}; if {table.group} = "Instance2" then B := sum({table.amt},{table.group}; Then in the report footer use...
  4. kinosaidp

    Difference between sum of a group

    I'm sorry but I'm not getting the result in the suggested code. If I would use the sum function Sum(fld, condFld, cond), it would be something like; Sum(mydata, mygroupfield, "mygroupfield = x") - Sum(mydata, mygroupfield, "mygroupfield = y") which does not allow me to embed a where clause in...
  5. 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...
  6. 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...
  7. 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...
  8. kinosaidp

    I could help on Formula

    sorry please disregard the last thread of email, my mistake.
  9. kinosaidp

    I could help on Formula

    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...
See more

Part and Inventory Search

Back
Top