Multiple join problem with report group

rbuser

Hi,

i've a strange situation, i hope you can explain me and find a solution

I've 2 Table in "data" (2 normal table), like this:
table MYHEADER
IDUSER
DAY
NOTE
(the first two field are the primary key)
Table MYDETAIL
IDUSER
DAY
IDROW
WORKDESCRIPTION
(the IDUSER-DAY-IDROW are the primary key)

I want to create a normal masted detail report grouped by USER (IDUSER)
I've linked the two table with the fields IDUSER-DAY

In the report project section i create a new group based on IDUSER only (i
want to create a report with the WORKDETAIL for any user for all day!)
In the header group i place the IDUSER FIELD.
In the Detail section i create subreport and assigned it with MYDETAIL
pipeline.
In the subreport i create a normal visualization of the detail (a normal
list of record ... DAY- ROW- WORKDESCRIPTION)

When i execute the report, it break the sub report when DAY change!!! It
appear that the group that I've created with ONLY IDUSER contain DAY!


Can you explain this? I'm doing something wrong? Please help, if neccesary i
will try to explai better.

Regards


my system:
REPORT builder 7.0
Windows 2000
SqlServer 2000

nardmoseley

From the Data tab, use the Preview button on the DataView tool widnows to
preview the master data.The master dataset should be sorted on the IDUser
field first, then the group should not break until the IDUser field changes
value.

The master report will traverse the MyHeader table and generate a detail
band for each User/Day. Then the subreport will generate and traverse all
records related to the master. Since you defined a link on IDUser/Day, the
subreport will print for a IDUser/Day specified by the linking fields.



--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com

rbuser

nardmoseley

Based upon your description I think you need to remove the Day field from
the master query. Link the detail to the master based upon the IdUser and
add the search criteria on Day to the detail query.


--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com

rbuser

Ok,
but if i've a third table(myalternativedetail), linked at the first
(myheader) with the same 2 field, if I create the search filter (over the
DAY field) from MYDETAIL, how can i filter MYALTERNATIVEDETAIL.DAY with the
same value?

nardmoseley

For the other queries that require the same search value, define search
criteria but do not designate them as autosearch. You can programmatically
assign the autosearch value entered by the user to the additional queries.

Here is an example that shows how apply the autosearch value to additional
queries by extracting the TdaSQL object from a dataview and updating the
search criteria.

www.digital-metaphors.com/tips/AutoSearchDateToCriteria.zip

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

rbuser

i will try something like this, because I must work in calc section, I
can't do that at design time

rbuser

if I do this report builder duplicate detail record

How can I manage a master detail report with more relational key fields?
Normally how you do this?

nardmoseley

Please create a simple example using paradox or Access tables and send in
.zip format to support@digital-metaphors.com.

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

rbuser

Only table or also the report?

nardmoseley

We need a Delphi project that contains an example report that demonstrates
what you are trying to accomplish. Include any comments/notes that explains
the issue. Include an tables needed to run the example. (Or use DBDemos or
the Interbase demo database included with Delphi).

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