Source language: Translate to:

Master detail reports

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

Master detail reports

Postby BRobinsonS » Sun Oct 21, 2012 3:12 pm

I have a membership app with members (Clients) in one table and payments in second table (DuesPaid).
Fields are MemNum,DatePaid,Amount,ReceiptNo.

When the app starts the Relationship is defined Master (Clients) and Detail (DuesPaid) linked by MemNum.
To report on dues paid between 2 dates I end the first relationship and create a new relationship Master(DuesPaid) and Details (Clients) linked by MemNum. After I am done with the report, I re-create the first relationship.

There are 36 payments in the DuesPaid table but the report only results in 30 payments.
All 36 payments are associated with correct MemNum's .

Ideas why this is not picking up the other 6 payments?

Other questions, can there be more than 1 relationship created and active in an app?
Can there be more than one Linked field?
Brian Robinson
'When all else fails, try again!'
www.ComputerSoftwareSystems.com
User avatar
BRobinsonS
 
Posts: 340
Joined: Sun Sep 25, 2005 9:00 pm
Location: Ontario, Canada

Re: Master detail reports

Postby BRobinsonS » Sun Oct 21, 2012 4:12 pm

Check the help file it suggests that I need to use a Sub-Report, but I won't get the layout I want.

I would like my report to look like this

Date, Member_Name, MemberNum, Amount, ReceiptNo [no commas]
9/17/2012, Bill Major, 114343, $45.00, 128

Date, Amount, MemberNo (linked), ReceiptNo in DuesPaid table.
Member Name in Clients table.


Right now I have all these fields on the Data Band (DuesPaid) (only one - no Sub-Report Band)
Report seems to work except leaving out 6 of 36 payments.

Or Is there a way to do a look-up Member Name using MemNum using DuesPaid to Client table?
Brian Robinson
'When all else fails, try again!'
www.ComputerSoftwareSystems.com
User avatar
BRobinsonS
 
Posts: 340
Joined: Sun Sep 25, 2005 9:00 pm
Location: Ontario, Canada

Re: Master detail reports

Postby BRobinsonS » Sun Oct 21, 2012 5:26 pm

The problem may be filtering.

The missing records are the last 6 records. The filter I am using :
SetVar "[OkStatus]" ""
IfEx "[PFromDate] > '' and [PToDate] > '' "
SetVar "[pFilter]" "DatePaid Between #[PFromDate]# and #[PToDate]#"
SetVar "[PFromDate]" ""
SetVar "[PToDate]" ""
SetVar "[OkStatus]" ""
Else
AlertBox "Date Empty" "Please fill in both dates"
SetVar "[OkStatus]" "Dont"
EndIf
If "[OkStatus]" "=" ""
CloseCustomWindow "PrintDates"
EndIf

PFromDate and PTodate are from a custom window.
The filter is in Actions of the OK Button.
The last 6 dates are 9/17/2012 [x 4] , 9/24/2012, 10/23/2012.
There are 7 dates of 9/17/2012.
If I choose 9/1/2012 to 10/31/2012 I get all but the last 6 dates listed above.
If I filter from 9/17/2012 to 10/31/2012 I get the missing dates including the 3 I do see when doing 9/1/2012 to 10/31/2012.

Not sure what's going on here.
Brian Robinson
'When all else fails, try again!'
www.ComputerSoftwareSystems.com
User avatar
BRobinsonS
 
Posts: 340
Joined: Sun Sep 25, 2005 9:00 pm
Location: Ontario, Canada

Re: Master detail reports

Postby BRobinsonS » Sun Oct 21, 2012 6:19 pm

I may have found the problem.
I had a column footer with a Sum function.

I deleted the column footer and get all the records.
Brian Robinson
'When all else fails, try again!'
www.ComputerSoftwareSystems.com
User avatar
BRobinsonS
 
Posts: 340
Joined: Sun Sep 25, 2005 9:00 pm
Location: Ontario, Canada


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 2 guests

cron