Where is the great rod in Pokemon diamond?

There is a fisherman on the road between Hearthome City and Soleceon Town that will give one to you.

No, it isn't. You have to go to the battle area after beating the Elite Four. It isn't even called the greatrod, it's the super rod. ^^^ Between Hearthome and Soleceon is the good rod.