Need to count number of full tapes

[Bill_Webster13]

I have a report of full tapes that need to be ejected.  I need to create another report that lists the scratch tapes to be loaded in their place.  When I try doing a count(id) the GUI give a nebulus error response.

[Deeps]

Its not clear to me what exactly you are expecting in your report ? Also could you pleaes share the whoc are you building the ew report ? If its custom then what filters and columns are you selecting and if its custom SQL , what SQL you are using ?

Do you  want the list of media ids from scratch pool  that should replace the mediaid that are ejected (FULL) ??

Thanks

DeepS