Recent content by itkyle

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.