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

Master/Detail not being honored

edited May 2003 in General
Hi,

I am using RB 7.02 with Delphi 7. I have a report with two groups on the
main report: group[0] is by rep_id and group [1] is by state. The main
report is connected to a clientdataset In the state group footer I have a
subreport that has a crosstab in its summary section. The data for the
crosstab is a clientdataset whose MasterSource is set to the main report's
clientdataset's datasource. MasterFields are set to 'REP_ID;STATE'. I print
my report for a case where there are two rep_ids and two states per rep_id.
When scrolling forward in my report, everything looks good. When I get to
the end of the report and I start to scroll backwards page by page, I get to
the page that shows the crosstab it shows the data for the wrong state (it
shows the state from page 4 on page 3, etc.). What am I missing here?

Natalie

Comments

  • edited May 2003
    Natalie,

    Try setting the Report.CachePages property to True. If this does not help,
    please send a working example demonstrating the problem in .zip format to
    support@digital-metaphors.com and we'll take a look.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited May 2003
    "Nico Cizik (Digital Metaphors)" wrote in
  • edited May 2003
    Natalie,

    Exactly how big is your report going to be? The CachePages property does
    have the potential of causing memory issues but this is machine dependant.
    If your report mainly going to be text and lines, you should not have a
    problem. If it contains numerous large images, we may have to look at an
    alternative approach.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited May 2003
    "Nico Cizik (Digital Metaphors)" wrote in
  • edited May 2003
    It is not the expected behavior. We support proper TDataset descendents and
    have no problem using well behaved datasets. The only issue that can arise
    is if the client dataset is not a proper TDataset descendent. This means
    that it must support bookmarks on the dataset. Can you reproduce the error
    with our demo reports? What client dataset class are you using? If you test
    using the BDE or ADO (I don't know what database you are using) does the
    problem go away?


    Cheers,

    Jim Bennett
    Digital Metaphors


  • edited May 2003
    "Jim Bennett (Digital Metaphors)" wrote in
  • edited May 2003
    Try using the MasterFields and MasterSource properties to link the client
    datasets. Make sure that you do NOT use the datapipeline properties when
    using delphi linking, ie. do not assign DataPipeline.MasterDatapipeline and
    MasterFieldLinks. That may be one cause.


    Cheers,

    Jim Bennett
    Digital Metaphors


This discussion has been closed.