Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

TppDBCalc Problem

edited April 2002 in General
I have a report where the main report is a set of groups that individuals
belong to. The individuals are a sub-report of the groups. Each individual
has a count field in the data and the user can break the report into 3
sections. Each section is a subreport tired to a different occurence the
individual table with a filter on that table. On the main report I have a
dbcalc field to count the individuals. The DBCalcs appear to be ignoring
the filter and counts the entire dataset for each table not just the
pipeline.

D5 Up1, RB 6.03 Std., DBISAM 3.07

--
__________________________________
Thad Smith
Sr. Programmer/Analyst
Computer Dimensions Inc

Comments

  • edited April 2002
    I attempted to reproduce the problem you described by setting up a filtered
    table. A DBCalc counting the records on the report gave me correct values
    based on the filter. Make sure that you are setting the Filtered property of
    the data source to true to enable the filter. You can hook up a DBGrid to
    the data source to inspect the data which is being pulled into the report.

    --
    Cheers,

    Alexander Kramnik
    Digital Metaphors

  • edited April 2002
    The Sum is working but the count is not. The filter is set on the group.

    Thad


    "Alexander Kramnik (Digital Metaphors)" wrote
This discussion has been closed.