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

Two Problems With Reports in RBS 7.02

edited March 2004 in General
Hi,

I have 2 problems making reports with RBS 7.02.

The first problem is with two querys, I see individually and the results are
good, but when I link both and execute again anyone the program is blocked,
so I don't know what happen, or what I have to do.

The second problem is with a especial paper format, I have only 20 lines for
writing records, so I use the property PrintCount, but the problem appears
when I have to make partial summaries, because the count reinitiate.

Thaks by the help, and excuse my poor English.

Comments

  • edited March 2004
    Hi German,

    1. How are you linking the queries? If you are linking them using
    datapipeline linking, you need to be sure you order each dataset on its key
    field, otherwise, you will see no data.

    2. What are you doing to add partial summary information between your
    detail bands? I need a little more information about how your report is set
    up to see what is happening here. Perhaps a diagram of how your report is
    designed.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited March 2004
    Hi Nico,

    Sorry by the poor information I gave you.

    1. I'm using End-User Reporting application with data dictionary and
    explorer included in an application made by my self. The queries where done
    by this way, I have order each query by the key field, I can see data
    individually, but if I link the querys and try again the program blocked,
    the same if I try to see the preview. The individual data is correct, all
    fields are good and it's possible the link but doesn't work and I don't now
    why.

    2. For adding partial summary information I'm making groups with the data,
    this happen because each registry belongs a "Family", by example hammer,
    screwdriver, clamps are tools and I have to totalize their value, and blue,
    red, yellow painting cans in other group also totalize. In the Summary band
    I totalize all the bill.

    The report is designed in this way:

    ...Client Data

    **** Header
    ... Family Name
    **** Group Header: Family
    ...Amount ....Product .... Price ... Total
    **** Detail
    ........... Family Name .... Total
    **** Group Footer
    .... Total Bill
    **** Summary

    Thank you very much for your time and help. I hope this information will be
    Sufficient.
    Cheers.
    Germ?n Osorio.

  • edited March 2004
    Hi German,

    This is interesting behavior. Be sure that when you link the datasets in
    DADE, you are dragging the detail field to the master dataset. If possible,
    please send me an example of this behavior to support@digital-metaphors.com
    in .zip format and I'll take a look at it for you.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited March 2004
    Hi Nico,

    I can't send you an example of these behaviors, because the application is
    in spanish, maybe you don't understand, and the data base is in 100 mb, so
    you need almost all data for see the problems.

    So, I will try to solve these problem, thank you very much by your time and
    help.

This discussion has been closed.