Search results for query: *

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

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

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

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

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

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