Search results for query: *

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

Try If totext({VW_GMAC_CCASHFR_CHECK_STATUS.PMTNUM}) = "0" then "0-Shared" CR needs to evaluate and return the same type of data. James

I would like to present my users with a name search parameter seeking their input as follows: LNAME,FNAME I would then like to parse their input and compair it to two different fields in the DB (LNAME and FNAME) I've got an idea of how to start but don't know how to grab everything before and...

Pardon my ignorance (if I had been working with my eyes open, I would have noticed that the custom color pallette providese the RGB value) with that handy little bit of information, my conditional formatting was a snap. Thanks for the smack to the head. James

How whould I derive the color "name" or RGB value when a custom color is being used. Would a report definition provide that info? James

I'm using CR8.5 developer / writing against V7 DB2 / I have given the users of this report grouping options (upto 4 deep so far). I'm conditionally supressing the group levels that are not used (ie if the user only wants two grouping levels, 3 and 4 are supressed). I've color coded the groups...