Only show certain people

[Fadius]

I have a table that contain people, worksheets, and work items.

I am only wanting people to show if they have an open worksheet, but all work items have been closed.

I am having a hard time doing getting this. WOuld I use a whilereadingrecords function when the report open? If so, how would this look?

Each worksheet has a true or false check box as to being open or closed as does each work item on the work sheet.


Thank you,

 

[Turkbear]

Hi,
Can you post the table fields and some sample output - It is not clear as to whether each person can have multiple records and if each record can have multiple worksheets and/or work items.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Madawc]

I'd do it as a pair of countable selections.E.g.

if isnull ({worksheet})
or {worksheet} = " "
then 0
else 1

if isnull ({workitem})
or {workitem} = " "
then 1
else 0

Display these formula fields in a special display line below the data, to be sure they work. They create a summary total for each.

You can now make a group selection, @CountOpenWorksheet = 0 and @CountOpenWorkItem > 0. (You find this under Report and next to Record Selection.

It has to be done this way because Crystal will only let groups be selected or suppressed on the basis of summary totals. If you're not already familiar with Crystal's automated totals, see FAQ767-6524.

PS. It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options. In this case, it probably makes no difference.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP