I know about the 7M.
As for the numbers to date:
Hollywood accounting trick #1: Canadian dollars = USA Dollars. Check your exchange rates- they aren't equivalent.
Furthermore, those numbers are gross reciepts. Those numbers still don't show you the costs of printing, advertising and distribution. They barely exceeded production costs. This is still a movie in the red.
Compare this to a movie that was considered a marginal success and spawned no sequel or spinoff, Eddie Murphy's
Coming To America and two that did, Steve Martin's
Parenthood and
Ghostbusters . They not only reached 9 figures in the theaters, they also reached 9 figures in rentals.
I'd challenge you to find another movie that did as little business as D&D (relative to its production cost) and still spawned a sequel.