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!

Search results for query: *

  1. birdprogrammer

    Duplicate Record, distinct records doesn't work

    K, Thanks for ripping on me but you are actually right. Sorry for any confusion. If I review all the fields, it is not duplicate issue. The report is pretty complex and I was hoping there was an easy way out to supress certain records in the detail section based on criteria that isn't available...
  2. birdprogrammer

    Duplicate Record, distinct records doesn't work

    I'm creating a vendor performance report and having problems with duplicate detail line items. The best approach would be to correct the data through linking tables. However, I can't do this because the 2 tables I'm working with only have one link. Let me clarify. Inventory Receipt Information...
  3. birdprogrammer

    Printing multiple records when query returns only 1 resultset

    In my record selection, it has {?RMA #}={SVC05000.RETDOCID}. My sql: SELECT SVC05000.RETDOCID, SVC05000.CUSTNMBR, SVC05000.CUSTNAME, SVC05000.ADDRESS1, SVC05000.ADDRESS2, SVC05000.ADDRESS3, SVC05000.STATE, SVC05000.ZIPCODE, SVC05000.COUNTRY, SVC05000.CITY, SVC05000.USERDEF1, SVC05000.USERDEF2...
  4. birdprogrammer

    Printing multiple records when query returns only 1 resultset

    Hello, I have created a report that is printing additional records in the detailed section. When I copy and paste the sql stmt into query analyzer, it returns only one resultset. Any suggestions on where to look to troubleshoot this problem. Thanks, MH
  5. birdprogrammer

    Cannot summarize formula Field.

    Thanks MBARRON and lbass for the quick response. Both your solutions worked beautifully. Thanks a bunch!!! MHa
  6. birdprogrammer

    Cannot summarize formula Field.

    Hello, I'm trying to summarize two formula fields @Full_late and @Full_On_Time but there are not an option under Running Totals function in CR. Please help. Thanks in advance. Add'l Info: I have 5 groupings: vendor, ponumber, polinenumber, itemnumberA, itemnumberB @Full_late = If...

Part and Inventory Search

Back
Top