Filtering CR10 and counting

[Gourmet10]

Okay, let's try this again. Frustration level has come down to a 7.

I am creating a report using an ODBC link to Remedy ARSystem, which actually has another connect to DB2 for part of data which really does not affect the data I use. I have a parameter value to get records for specific dates. The report is broken down by regions (assigned, pending, resolved, etc.) these are count with a total under the heading of each region. Works great. Now manager wants filter even more, but still wants the counts. For example CST Eastern should be added to Eastern Office. He does not want to see CST on the report. These are some of the things I have tried: SELECT, Case, IF statements, nothing seems to work.

 

[Turkbear]

Hi,
Without a clearer picture of your data and what the finished report should look like, it is difficult, at best, to propose a solution, and your use of the term 'filter' confuses things even more - a filter is used to limit what data is returned to the report, not to determine how to organize and count the resulting data.

Perhaps you mean Grouping or Sorting?

Once that is clarified, perhaps using a formula something like:

If Eastern Office OR CST Eastern then 1 else 0

and placing the formula in the appropriate place and summing the result to get a count of both regions combined.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Gourmet10]

My apologies, getting so tired of this report. I am using grouping, it is generated by dates in a parameter values, start and end. Each section: Assigned, Pending, Resolved, etc. are counted for the month and then totaled by region.

 

[Gourmet10]

I'm still not explaining this very well. First of all, I'm using Crystal 10 with an ODBC link to Remedy, using a crosstab set up.

My parameter values are [DateStart] and [DateEnd]. Works fine.

Then I have all the technicians grouped with totals as follows:

Assigned 14
Pending 1
Resolved 64

Western 79
Techs

This works fine.

Then we have:

Assigned 0
Pending 1
Resolved 45

CST Western 46

What I am trying to do is combine the different regions into one total and hide the CST.

 

[kskid]

Still not sure what you want.

Want to eliminate the CST regions altogether, including the count. then add to the following to the record selection

not({table.field} startswith "CST")

If you want to include the CST counts with the region, I would do the following

Set up formula @region

Select {table.field}

Case "CST Eastern":
  "Eastern"
Case "CST Western":
  "Western"
....(and so on)
Default:
   {table.field}

From the report canvas, right click on the group section containing the region and click on Change the group and select @region from the dropdown

-LW

 

[lbass]

To create these custom groups, use a formula like:

if {table.region} in ["Western", "CST Western"] then "Western" else
if {table.region} in ["Eastern", "CST Eastern"] then "Eastern" else //etc.

Then insert a group on formula and remove your group on {table.region}.

-LB

 

[Gourmet10]

Thanks, manager decided to let report run as is.