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

    Allow multiple record selection criteria

    Here's the record selection formula: {CLAIM.ACC_NUM} = "HCP" and {PAYMENT.PMT_CAT} in ["I31", "I30", "I06"] Here's the SQL statement: SELECT CLAIM.ACC_NUM, CLAIM.CLM_NUM, CLAIM.CAS_NAM, CLAIM.OCC_DTE, CLAIM.STATUS, PAYMENT.PMT_CAT, PAYMENT.ISS_DTE...
  2. itkyle

    Allow multiple record selection criteria

    Using CR6... I've written a report to show clients to whom we've made payments in 3 categories, and used the Select Expert using {PMT_CAT} "is one of...", then chose the 3 categories. The problem with this is that when a client has been paid under more than one of those categories...
  3. itkyle

    I have two rows in a db table and need to

    btw - I'm assuming your data actually looks like this: ID AREA LEVEL 18 Acton Parish 18 Coppenhall District Ward
  4. itkyle

    I have two rows in a db table and need to

    Can't you just use the Select Expert (since "Level" is a field in your table) and choose 'is equal to District Ward'? Or am I not understanding your problem correctly? Kyle
  5. itkyle

    Problem with Groups and "Others"

    glauco - When I mentioned "change", I meant to change a setting for the number of groups allowed. That was before I realized the TopN grouping was set to 5; after 5 groups were listed, the rest of the records fell into the "Others" group. Once I fixed the TopN setting, all...
  6. itkyle

    Problem with Groups and "Others"

    Please disregard - found that the problem was in the "TopN" grouping.
  7. itkyle

    Problem with Groups and "Others"

    Using CR6 I have a report that groups on a user name. When I run the report, I only get 5 groups, and "Others" as the 6th. Is there a setting for limiting the number of groups that I can change? I want all user names to have their own group. I tried using Change Group Expert to...
  8. itkyle

    Find difference between values in group header

    The problem is that both of these totals are in the same textbox - it appears in a group header, so it just repeats for each grouped year. Should the calculation be placed somewhere else? Thanks for your help. Kyle
  9. itkyle

    Find difference between values in group header

    I have a report in which I placed the sum of a field in a group header, which gives me the figures I want grouped by year. In the report footer, I'd like to be able to show the difference between 2 years based on that sum in the header. For instance, when I run my report I get 1 group for 2000...
  10. itkyle

    Printing "Continued on Next Page"

    Ken - Moving the formula did the trick. When I put the first formula in the page header (where the bill number field resides), and kept the 2nd formula in the group footer, it worked perfectly. Thanks for the help, and thanks to ngolem for getting the ball rolling. Kyle
  11. itkyle

    Finding records where a field *doesn't* exist

    jdemmi: I can't use FF_TYP=&quot;D&quot; and FF_STATUS<>&quot;O&quot;, because I need to find records where there has been no diary created; therefore, these will not have &quot;D&quot; in the FF_TYP field. dgillz: I can't use the IsNull function, because FILEFOLD.DIARY is not a field; the...
  12. itkyle

    Finding records where a field *doesn't* exist

    Here are the details: The dept. I'm working with processes claims (data stored in table {CLAIMS}). All open claims should have an open diary attached to them (stored in table {FILEFOLD}). The FILEFOLD table allows and stores different types of entries; D for Diary, L for Letter, N for Note, F...
  13. itkyle

    Printing "Continued on Next Page"

    Yes, it is for continued records (I should have realized that sooner - suffering from &quot;brain fry&quot; from all the month-end reports I've had to modify!) The details are all tied to a bill number, which appears in the page header (the report is also grouped on this field). When that bill...
  14. itkyle

    Printing "Continued on Next Page"

    In my group header: WhilePrintingRecords; BooleanVar Continued:= True In my group footer: WhilePrintingRecords; BooleanVar Continued:= False In my page footer: WhilePrintingRecords; BooleanVar Continued; if Continued then &quot;Continued on next page&quot; else &quot;&quot; Thanks...
  15. itkyle

    Printing "Continued on Next Page"

    Not sure what happened - this post was originally titled &quot;Question for kenhamady&quot;, and was directed to him concerning a formula he posted. My apologies. Please disregard.
  16. itkyle

    Grouping by date ranges, Part II

    Ken - Once again, the Tek-Tips gurus have really come through for me! Thanks a ton for your help. Now an aesthetic issue - how can I get those individual date ranges from my formula to print in the page header (e.g., &quot;Period: 3/31/1994 to 3/31/1995)&quot;)? I'd like each section to show...
  17. itkyle

    Printing "Continued on Next Page"

    Ken - I'm using CR6, and have inserted your formulae for printing &quot;Continued on Next Page&quot; in a report. However, I'm finding that it prints on *all* pages, regardless of whether it's a continued record. Any ideas? Thanks for the help. Kyle
  18. itkyle

    Grouping by date ranges

    Ken - Once again, the Tek-Tips gurus have really come through for me! Thanks a ton for your help. Now an aesthetic issue - how can I get those individual date ranges to print in the page header (e.g., &quot;Period: 3/31/1994 to 3/31/1995)&quot;)? I'd like each section to show the period...
  19. itkyle

    Grouping by date ranges

    I have a report that is run based on a date range, which I usually select from the Select Expert. Since there are now 9 or more ranges needed, this is getting to be a pain (essentially I'm having to run the report 9 times, once for each range). Compounding this, different clients need the...
  20. itkyle

    Help!!! Crystal to Acrobat

    Typically Acrobat only creates bookmarks automatically when it finds a Table of Contents in the document being converted to PDF. Otherwise, you have to create the bookmarks manually. Kyle

Part and Inventory Search

Back
Top