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 Rhinorhino 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 IbeKaba

  1. IbeKaba

    Minimum Year Selection at a Group Level

    LB, Thanks once again for the help. You are the best! You were right about the speed problem associated with doing it the other way. It was impossibly slow!. I did it the second way you suggested and it's working beautifully. Merci, ibe
  2. IbeKaba

    How to Add new column - Mure

    This might be an oversimplification...but did you try going into each running and/or group total and change the field referenced to? That's what I would do ibe
  3. 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...
  4. IbeKaba

    Count Consecutive Years

    LB, I completely understand where you are coming from. And you are right, my previous post made illustrated exactly how you understood it. I guess even I did not know what I needed. So, no it's was not your mistake, it was entirely mine. And I probably wouldn't have seen it had you not brought...
  5. IbeKaba

    Count Consecutive Years

    All is well. I got exactly what I was looking for: going by current streak, how many donors have given y years in a row. However, at first I thought LB's understanding of the problems was right, but after checking my own requirements I think SV's right. That is, in a case of an id with years...
  6. IbeKaba

    Count Consecutive Years

    You guys are simply AMAZING! I've not had the chance to try your suggestions yet, but I just wanted to say what a nice suprise this is; after a long frustrating friday last week, to come in to work today to this....delicious! Thanks a lot. ibe
  7. IbeKaba

    Count Consecutive Years

    Thanks guys. I think I understand your answer(s)....but I think I explained my problem wrong. The 3 consecutive was just an example. What I really need to know is how many consecutive years a donor has given. Therefore in the above example, I not only need to know ID 111 has given three...
  8. 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...
  9. IbeKaba

    Viewing Records With SUBREPORT in Excel

    Genius! I got to say, this is absolutely the best forum on the Net. Good, quick response, and best of all patience with a novice like me. I love it! I simply love you guys! Thank you, thank you, thank you... ibe
  10. IbeKaba

    Viewing Records With SUBREPORT in Excel

    ibass, that's exactly what I was thinking. I really thought this was such a small problem that there had to be an automated solution like the one you mentioned. But unfortunately I don't this this is available in Crystal IX, because it didn't work for me. Synapsevimpire, sorry about not...
  11. IbeKaba

    Viewing Records With SUBREPORT in Excel

    Again, I'm new with Crystal I've never worked with shared variables before. But if I understand the concept, by using it, I can take a value from the subreport and display it on the main without having to "insert" the subreport directly into the main report....right? Cool. However, it doesn't...
  12. 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...
  13. IbeKaba

    Select Distinct Records - based on multiple fields

    Thanks a lot. It works Though I must say, I don't get it Maybe I don't remember much of the programing I learned back in college, but looking at the formular, I thought it would assign "1" to even those ID's that have other color TAGs as long as they have "red". Maybe the selection formular is...
  14. 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...
  15. IbeKaba

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

    Got it. Thank you very much ibe
See more

Part and Inventory Search

Back
Top