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

Separating Report Data

edited August 2003 in General
I have a database process that assembles information on inventory by
part number. This is available through a single View to my reports. I
would like to add the Cash on Hand to that view as one more record.
Maybe it would have no part number or a zero part number. In the
report, I would like to display the Cash first, followed by all the
inventory. How can I best extract the cash record and display it first,
then produce the rest of the report?

Thanks,
Patrick

Comments

  • edited August 2003
    Hi Patrick,

    The easiest would be to create a new dataset with the cash value and a
    linking value that corresponds to your original dataset. This way you could
    link the two and create a master-detail relationship so every time the
    inventory changes, the cash changes.

    Otherwise you would need to create a new view that is re-ordered to show the
    "cash" value first. This could probably be done by joining the data in your
    current view with that of another view showing the cash values.


    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited August 2003


  • edited August 2003
    Hi Patrick,

    Sorry, but there is no way to separate out an individual field from a single
    dataset in ReportBuilder. When ReportBuilder accesses a dataset, it
    traverses all the data at the same time one record at a time. I would
    suggest staying with your first plan of action and using more than one
    dataset (i.e.. one for customers and one for cash).

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited August 2003
    Thanks for your help.
    Patrick
This discussion has been closed.