Report record selection filter not sensing marked

[Dave Mac Callum]

Hi there,

I have a problem in printing a report which has a filter to print only marked records.

I attach the db

To get to my problem

1. Debtors Selection Form displays on loading
2. Select Enquire Accounts - 6
3. Name Search enter Dave DAVE MILLER MOTORS is selected.
4. If no transactions display, select Profile button. OK the Dialog box
5. 5 Transactions should display.
6. Activate Print Button.
7. Select Preview
8. There are no pages in layout is the result.

Select Control Panel / Reports / Debt_Xsacts_by_Acc_Batch
Design / Report / Select Records will display my filtering.

(The layout of this selection box suggests that it should be all Trade_Transaction Records, with Marked button active. I am not able to get it working this way either

Any ideas ?

Looking forward

[Tom Cone Jr]

Re: Report record selection filter not sensing marked

Dave, your report is based on a set of tables. The filter you're applying pertains only to one of the child tables. Depending upon what you need in the app you're either going to have to base the report on a set in which "Trade Transactions" table is primary, or you're going to have to change the filter expression to use either a crosslevel filter or to flatten the query with flattenquery(). As it stands right now nothing in the filter tells the report engine which DEBT table record to use.

[Dave Mac Callum]

Re: Report record selection filter not sensing marked

Hi Tom,

Thanks for the help.

As a test I have marked the parent record to filter the req record.

I have managed to get something going using flattenquery(). I am using a test condition on the Trade_transaction.net_amnt as you can see from the attached db. Still unable to filter marked child records which is what I had in mind. Any way of doing this ?

I wonder whether I am going about this the correct way ? Most systems have the need to filter / print parent / child records. How is it normally done ?

[Tom Cone Jr]

Re: Report record selection filter not sensing marked

Most systems have the need to filter / print parent / child records. How is it normally done ?

Sorry. The generality of this prevents a meaningful answer in the available time.

In your app, why are you marking child table records, and then using the marks as a way of including those child table records in the report? If you're marking all the child table records that are linked to a specific parent record you can stop. There's no reason to mark the children. The only reason to mark them is if you wish to EXCLUDE some of the linked child table records from your report. Is that what you need? Or are you simply trying to print all the linked child records for a specific parent?

[Mike Wilson]

Re: Report record selection filter not sensing marked

OK Dave here goes.
I don't like using mark() as a tool for marking records for filtering. It can create havoc in a network environment and filters are somewhat difficult to get working properly. That being said, I see that you have used mark() fairly extensively. I changed it to get it to work... at least for what I believe you were asking for.

I added a field "mark_f;c;1" to the trade transactions table, commented out line 51 and 58 of the Debt_Enq_OnFetch script and replaced td_xcts1.mark() with td_xcts1.mark_f = "x" and changed the base filter on the Debtors Enquiries form for the child table to be trade_transactions->mark_f = "x". The 5 records that get shown because they are tagged by the filters and actions of your Debt_Enq_OnFetch script contain these values in the trade transactions table field "net_amnt".

-152.69
225.30
25.07
24.57
82.65

None of these records have a value > 1000.00, which is what the filter expression on the Debt_Xsact_by_Acc_batch report is set to for which you are asking to show these records. I changed this report filter to use a global variable vgn_net_amnt with:

trade_transactions->net_amnt > var->vgn_net_amnt .and. Trade_Transactions->Mark_F = "x"

and changed the radio button from "marked" to "all".

I added an in-line xbasic action on the form print button with ui_get_number() to collect the value for the global variable vgn_net_amnt to pass to the report filter. With these changes, I believe the "tagged" (mark_f ="x") child records with values in the field net_amnt which are presented comply with the ask value and the desired report filter. I also added the net_amnt field to the report so you could see the field values of the presented records to confirm the values comply with the ask value delivered to the filter.

While I believe this filtering of child records is what you want, I claim zero understanding of what this is all about. I hope this helped.

[Dave Mac Callum]

Re: Report record selection filter not sensing marked

Thanks for you input Guys

OK Dave here goes.

While I believe this filtering of child records is what you want, I claim zero understanding of what this is all about. I hope this helped.

Certainly did help. Direction like this to see how it should be structured is worth its weight in gold.

The purpose of all this is to achieve a quick display. In my ignorance i decided to include the following in my child table Trade_Transaction filter

Trans_Type "CRN"
.OR.
Outstand_Amnt 0
.OR.
Date >= Var->gd_past1

I attach the resulting db. This is on a db with approx 3,000 records in child table Trade_Transaction. When one has more than 100,000 records it takes forever to chew through. The solution to tag an additional field works.

Thanks again