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: *

  • Users: IbeKaba
  • Content: Threads
  • Order by date
  1. IbeKaba

    Minimum Year Selection at a Group Level

    I'm working with Crystal IX using an ODBC connection Here's the source of my headache for the past couple of days: I'm pulling records from one table (gifts) where each record could potentially have multiple gifts dates. In trying to determine how many new donors we get each year, I'm...
  2. IbeKaba

    Count Consecutive Years

    I'm using Crystal 9, pulling from a SQL database, using ODBC connection. I'm pulling records from two tables. One table has general info, and the other has gift info. The two tables are linked by ID. Since there are many corresponding gift records for a donors, I have my report grouped by ID...
  3. IbeKaba

    Viewing Records With SUBREPORT in Excel

    I'm working with Crystal Report 9. When I export a report that has a subreport in it to Excel (Excel 2002)using the "Data Only" option, instead of printing on the same row as the record, the subreport value is printed in its own row. How can I keep this from happening, and keep this value on...
  4. IbeKaba

    Select Distinct Records - based on multiple fields

    I'm working in Crystal 9 on a database I'm not too familiar with. The primary key seems to be a combination of multiple fields. Hence I have records that are almost identical with only slighth variation in a field or two. Or maybe there is no primary key. Anyway, I'm not sure how to explain my...
  5. IbeKaba

    [b]Select Date Range AND Blank Date Field[/b]

    I'm working with Crystal Report 9, and here is what I have in the Record Selection Formular window: {contact_calls.solicitor} = {?Select_Solicitor} and {contact_calls.drive_code} = {?Select_Drive} and {contact_calls.regarding} = {?Select_Regarding} and...
  6. IbeKaba

    Limiting Record Occurence

    Keep in mind, I just started a new job and using Crystal literally two weeks ago. So if my question is really elementary, that's why. With that in mind, here is my question: How do you limit your result to only one occurence of the primary key (Account Number)? I'm working with two tables where...

Part and Inventory Search

Back
Top