Separating Report Data

rbuser

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

nicocizik

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.


--

rbuser

nicocizik

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).

--

rbuser

Thanks for your help.
Patrick