Syncing 2 separate dataviews?

rbuser

(D7, RB 7 Ent)

I have a report in which I have 2 separate dataviews. Each dataview has
records that are to be grouped by a reconciliation number. I need to be
able to correlate both dataview on the reconciliation number and sync them
together so that they line up, or at least show up on the same page. I can
get each dataview to group properly in separate subreports, but I cannot get
them to sync with each other. I've attempted to link both dataviews to a
master table and setting this as my primary data, but the grouping in the
subreports gets messed up. I have also tried to link the 2 dataviews
together, but they aren't in a master/detail relationship, so this too has
proven futile.

Any ideas?

Thanks,

Bob Nicksic

nardmoseley

1. Create a master query that contains a list of unique reconciliation
numbers. Order the query by reconciliation number:

Select Distinct ReconciliationNo
From SomeTable
Order By ReconciliationNo

2. Link the two detail dataview to the master.

Sounds like you tried this, but perhaps the master data was not ordered on
the reconciliation number.

3. Connect the main report to the master dataview

4. Connect each subreport to one of the detail dataviews

For each master record the detail band will generate. If the subreports are
in the detail band, then they will generate once for each master record and
will display the info for the linked reconciliation number.


--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com

rbuser

The first 3 master records work just fine, but the subreports in the 4th
master record contain multiple groups.

How much of an impact is it going to have if the Reconciliation Number is a
uniquidentifier (GUID) in SQL Server? They are represented in the Designer
as String(38) fields, and I can link on them but I vaguely remember reading
somewhere linking on a GUID doesn't work.

Thanks again,

Bob Nicksic

nardmoseley

Sorry, but Guid field linking is not currently supported.

The next release, ReportBuilder 9, will include support for Guid field
linking.


--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com

rbuser

Thanks, that's what I thought.

I was able to create a view (adding to the data dictionary, of course) and
cast the GUID column as a varchar(38), and it seems to be working so far.
Just wanted to share that with the newsgroup in case someone else is stuck
using GUID columns too.

Thanks again,

Bob Nicksic