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
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
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...
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.