Hi

Im trying to create a Report in WebFocus using the Report Painter. I have one alpha-numeric field in the By category and one numeric field that is summed up within a date field that is in the Across category. To summarise, I have one field in the By Category, one in the Across category and one numeic field summed up under these. The values in the By category are getting repeated with the summed up values getting split. Why is it so? I have joined these tables in a simple Joiner before this report, as a Unique Join. How do I display unique values and suppress these duplicates?

Are your date values the ones repeating? If so you may have time stamps in your original data. same for using Numeric By's. check for decimals even though they may not be displayed in the final report.

If not, post your code.

eSearing.com
version 2.something now available

Hi
The date field has a timestamp, but it is 12:00AM for all the dates and that should not cause a problem. Also, what is repeated for me is the Alpha-numeric field in the By Category. Fo eg., I'm listing the total hours spent by few employees in a particualr team. the employees' names are getting repeated twice with values split. I'm trying to do this using the Graphical tool, and hence am not doing any actual coding. Can you still help?

The problem you're having may be caused by the VERB you use. If you're doing a horizontal sort (ACROSS), you want an aggregating verb (SUM/WRITE), as opposed to a non-aggregating verb (PRINT/LIST). This is because, with the non-aggregating verb, every detail record produces an output record. You want an aggregating verb, so that each unique value of the vertical sort (BY) file, produces a SINGLE record.

Art