Search results for query: *

Thanks, lbass - worked like a charm! Except I used cust_id in my variable because it was shorter than cust_name. (Cust_id is a 7-char alpha-numeric field.) Because the length of the variable increases by 8 characters for each record per group, I had to eliminate (through group selection) those...

I have searched previous posts and FAQs, but have not been able to find this problem, so I apologize if there is one out there that I've missed. I'm using CR 8.5, DB2 db via ODBC. We produce customer statements that combine multiple accounts on each statement. I've got two tables: COMBLEAD...

Thanks to both of you. I will admit, I was struggling with the syntax a bit in my select statement. But I did finally get it (with the help from another thread on this site!) with the following: {table.field_1} like "*" & char(9) & "*" or {table.field_2} like "*" & char(9) & "*" etc. Thanks...

Good morning, I am using CR 8.5 with ODBC to Sybase db. I have a table with multiple string fields that are populated thru electronic customer correspondence. Some of these fields contain embedded tabs, which is causing a bcp to fail. Is there a way to select just the fields that contain a...

I'm experiencing the same dilemma and maybe somebody has an alternative solution to using the sum function? CR 8.5, sybase, ODBC or sybase server connection. I'm using manual running totals in my report because the field I need to evaluate is a sequence number, which begins at 1 each day for...

Thanks, all for your input. I find the exchange to be quite helpful. I get frustrated when what works in one software doesn't in the next. Unfortunately, I don't think my brand of multi-lingualism will help me on a world-wide vacation! FYI, maximum(groupnumber) did not work, however lbass'...

Thanks, dgillz, I knew there had to be a simple solution.

Using CR 8.5, how can I count the number of groups? Group is by customer, group selection is count ({detail field}) > 1 and I want to know how many customers fit the criteria. Thanks in advance.