Filtering Detail Band in Reports

[samuelNYC]

Hi,

I'm trying to create a report that has some fields from a parent table in a group band and for each of those records, display some related records from a child table. But I only want CERTAIN records from the child table in the detail (due_dt>{07/01/2010})

I'm on a pre-packaged database built on FoxPro. I'm new to VFP and still learning, but I'm pretty sure all I have access to is the report designer, which is what I'm using.

Anyway, I'm not really sure where to put the expression to filter the detail rows. Specifying this in "Print When" for each field in the detail row gets rid of the fields, but leaves empty rows (even with "skip row if empty" checked). I suspect I should enter this either in the expression field for "target alias" or for "run expression on entry" under edit bands -> detail. But not sure.

Another user's solution was this: "I remembered there is a field for a 'scoping' clause used when there is an intermediary form for selecting a date range or something, and I slipped in the 'AND txncode="810"' and of course [the empty rows] are now gone." (

http://www.tek-tips.com/viewthread.cfm?qid=501168&page=605)

Is this what I should do? Anyway care to explain this just a little for the newbie? I really appreciate any guidance! Thanks,

Sam

 

[samuelNYC]

Ctrl-A didn't reveal anything that I was missing. I'll tighten it up as suggested (or insert something and disappear it) and report back.

Thanks, Tamar and Olaf.

Sam

 

[samuelNYC]

Getting rid of the extra space worked perfectly. I'll figure out a way to have add back in a little extra space through some trial and error.

Thanks Mike, JRB, Dan, Olaf and Tamar for all your help. Even if some of the advice didn't lead me to this particular solution, it definitely helped my understanding of reporting in FoxPro--despite my limited options through this app (yes, Tamar, it is Donor Perfect).

Thanks again.

Sam

 

[Mike Lewis]

Sam,

Glad to hear you've got it solved, and that it was a relatively easy solution.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy