AnsweredAssumed Answered

Help creating a report that lists some things but not others

Question asked by Tauryn on Jul 20, 2012
Latest reply on Jul 20, 2012 by philmodjunk

Title

Help creating a report that lists some things but not others

Post

I have been an avid FM user for many years but I have been out of the FM scene for a while.  This may be very simple to do and if so I apologize.

Here is what I want to do.

I have a task database keeping track of what I am doing and I have a relational database, tasks line items to that defining specific things related to that task.  In the main level I am choosing whether the task is on hold, complete, in progress etc.  What I would like is for my report to print out the tasks I have but the ones on hold it just prints the task and not any related items underneath because it is on hold at the moment.

What it currently generates

Report:

Contacts Database    on hold

xxxxxxx   xxxxxxxxxxxxxxxxxxxxxxxxxxxxx  xxxxxxxxxxxxx

Jobs Database          on hold

xxxxxxx   xxxxxxxxxxxxxxxxxxxxxxxxxxxxx  xxxxxxxxxxxxx

xxxxxxx   xxxxxxxxxxxxxxxxxxxxxxxxxxxxx  xxxxxxxxxxxxx

Employee Database  In progress

xxxxxxx   xxxxxxxxxxxxxxxxxxxxxxxxxxxxx  xxxxxxxxxxxxx

xxxxxxx   xxxxxxxxxxxxxxxxxxxxxxxxxxxxx  xxxxxxxxxxxxx

(xxxx just equals whatever info)

and so forth, what I want is for the part to show but not its line items if they are on hold.  I tried some conditional formatting and also tried making some calculations that if status = on hold then the duplicate fields I created for each one in the TLI = "" and had the duplicate fields in the report.  this worked but they showed up as still empty spaces and even with sliding etc they didn't go away.

What I would like to see it generate:

Report:

Contacts Database    on hold

Jobs Database          on hold

Employee Database  In progress

xxxxxxx   xxxxxxxxxxxxxxxxxxxxxxxxxxxxx  xxxxxxxxxxxxx

xxxxxxx   xxxxxxxxxxxxxxxxxxxxxxxxxxxxx  xxxxxxxxxxxxx

and so forth..

Sorry if I am too confusing,

Tauryn

Outcomes