Recent content by butkus

Group by portfolio then enter a summary that DistinctCounts member ID for that group

I'm trying to develope a report that will run court dockets. Different courts have dockets at different time during the day. The users of the report will be able to select Docket Date / Court / and Docket Time from 3 different parameters. I need to handle potential data entry errors in the...

If you want to user to decide how the report is to be viewed, you can do the following: 1) Change your Parameter to a pick list with "Container" and "Vessel" as the options 2) Create a formula named group and add this Select {?parameter} case "Container" : {tablename.container_name} case...

Can you give an example of the desired output please. Do you want the difference in days and hours/minutes or just days? Also, do you want this to be cumulative for any given days or for all those logged in or for individuals logged in? James

Sorry again, I'm typing faster than I'm thinking this morning totext(year(currentdate),0,"") returns what you want. James

Sorry, I just copied and pasted your portion, It should be this: totext(int(year(currentdate),0,"")) James

Try this totext(int((year(currentdate),0,""))) James

I do something similar all the time. The trick is to group based on the result of formula's rather than record exclusion based on condition (if that makes any sense). Basically, you return all of the records to the report that you may need. Create a formul named Group1 (or whatever you want)...

You could try the following. Return all of your records to the report. Then create a formula for your group. @Group1 for example. Within @Group1, perform you conditional evals and then insert your group based on the results of @Group1. I do something similar all the time. It would help to...

I had a similar problem recently and corrected it by adding the following to the running total's formula. If {@the formula returning the value you want to average}>0 then true This cleared things up very nicely for me. James

Both solutions provide the answer, thanks to all. James

I'm writing in CR 8.5 Dev ed. against a DB2 v.7 database. I need some guidance on monthly groupings please. I have reports that allow the user to select the groupings and the # of grouping levels deep. Here is my grouping formula: If count({?Choose Groups}) >=1 then select {?Choose Groups}[1]...

Change the OR to an AND in lbass's reset formula" {table.flag} = "Y" and {table.ID} <> previous({table.ID}) that way both conditions must be met. James

Writing in CR8.5 against DB2 v.7 I created a report that searchs names and returns info based on exact matches, I also provide the user with a soundex list on names in case no exact match exists. From CE 8, the user can refresh the report using the soundex info return. Is it possible to have...

Works like a champ, thanks James