I have been trying to learn a cross platform language with a fast learning curve, and so it seemed obvious Python was the logical choice.  I've never programmed before but I have been reading on pragmatic programming and agile development for quite some time.  The question comes, "What is the single best choice to create a desktop software that is built heavily in python and can handle flexibilty of SQL injections, along with rich interface reporting?" e.g. SQL Alchemy, ReportLabs. 
I have been looking into pyHed found in sourceforge.net.  However, it's on early development stage and is still not well documented.  I checked out Titanium Desktop from Appcelerator and the concept seems exciting, but it's not in stable condition yet.  
Any suggestions, comments or ideas of what is currently being used? or new technologies out there now?
There are many answers to your question because you raise a number of issues:
Agile development is methodology and has very little to do with the language or software platform.  It is more a set of principles around which software teams organize themselves.  Refer to the works of Kent Beck for a bit more detail.
Do you have an existing Python code base?  If you do have an existing Python code base you could get relatively far with pyHed.  Otherwise you could look at something like Java Swing or C#. 
But really you might want to consider moving the application to a web platform - that seems to be the direction almost all desktop apps are heading.  Django is well known Python framework.  Or any number of the Java, C#, Ruby platforms if it strikes your fancy.
The jquery JavaScript framework is a good tool to provide rich Web interfaces.
Agile Software Development in Python