Mr. Dursley sat frozen in his armchair. Shooting stars all over Britain? Owls flying by daylight? Mysterious people in cloaks all over the place? And a whisper, a whisper about the Potters...
Mrs. Dursley came into the living room carrying two cups of tea. It was no good. He'd have to say something to her. He cleared his throat nervously. "Er - Petunia, dear - you haven't heard from your sister lately, have you?"
(Harry Potter)
I can’t find the meaning but "it was no good" seems to mean "there's no choice but to do something." What is the real meaning and from where does it come from?