Why does my 2006 RT Charger with sunroof leak from the overhead light near the windshield? The sunroof remains dry

Bad connection to its power socket probably or an intermittent backlight.

Remove the lens on the overhead light by prying it off with a screwdriver.
Slide the locking tabs towards the windshield and pull down on the housing to remove the inside of the roof light assembly. Leave the wiring connected.
Insert the S shaped Allen wrench supplied with the vehicle into the left side motor hole.
Turn the crank clockwise to close the sunroof.
2014 Newest Automatic V8 X6 Key Cutting Machine

Under your headliner, than routed outside the car through your a,b and c Pillars

Take your vehicle to the dealer. This is a known issue having to do with the drain hose for the sunroof.
Here is a related thread on SwedeSpeed: http://forums.swedespeed.com/showthread.php?162397-Sunroof-leak
And a roundup, including links to a current class-action lawsuit on my site detailing our issues with the XC60: http://bergeronvolvoservice.com/

Sunroofs, moonroofs, and convertibles are all going to leak, eventually. There is just no way around that. Go to a pet store and get some clear aquarium sealer, or a hardware store and get some clear latex in a squeeze tube, smear it around and into all the cracks and joints. Eventually you will fix the leak, and it will start leaking somewhere else. When the sealant has dried and shrunk, it will start to leak again so you can start anew.

If you have a sunroof then you have a clogged drain tube but usually you will see that the water is dripping form overhead in the liner. Otherwise you may have a rusted out spot behind the front driver side wheel. Maybe leak from windshield seal but that would be most noticeable. 

check sunroof drain holes are not blocked.

This is just a shot in the dark-- but ya never know, right? If you have a sunroof check the drains. They are lines that typically run from the inner corners of the sunroof housing down to empty out at the low point on the vehicle body. You may find the opening on the inside door jamb near the hinges, or on the pillar between front & rear doors. Look for a little nipple type rubber fitting.
Another thought...have you checked your heater core and hoses?
Good luck!

common problem with these roof racks check for loose bolts holding it on also there are inserts pressed into your roof under the roof rack these threaded insrts tend to come loose or get pulled out use silocone sealant around every bolt and insert.

Locate the IP to body harness connector, THIS CONNECTOR IS UNDER THE DASH HIGH UP ON THE LEFT HAND SIDE. Check to see if there is a water leak into the area and repair as necessary. Use a water hose to determine the source of a water leak and effectiveness of repair. Some examples of potential water leaks are: A-pillar seals, sunroof drain lines (if so equipped) and windshield/cowl sealing. Finally, repair or replace the IP to body harness connector, making sure no corrosion or debris is left on or between the terminals.

IT IS ADVISABLE THAT YOU REMOVE THE INTERIOR CARPETING AND DRY IT THROUGHLY. IT WILL MOLD AND SMELL REALLY BAD AFTER A FEW DAYS IN THE HEAT.

USE A WATER HOSE STARTING LOW AND WORKING YOUR WAY UP TO DETERMING WHERE THE LEAK IS. OR USING A FOAMING TYPE WINDOW CLEANER SPRAY IT WHERE YOU THINK THE LEAK MIGHT BE AND USE COMPRESSED AIR FROM THE INSIDE ON THE TRUCK FOLLOWING THE SEAMS AND WINDSHIELD.