Create a customize dashlet with related to multiple modules

Hi All,
I want to create report kind of dashlet in my home page but its should be related to multiple modules. How to create kindly tell me he process.

Individual module we can to do the customization but we required related with multiple module.

For example:

I want to combine lead, calls, meetings in single dashlet.

my list view may be
[table]
[tr]
[td]Lead Name [/td]
[td]No. Calls[/td]
[td]No. Meetings[/td]
[td]No. Emails[/td]
[td]Assigned To[/td]
[td]Lead Status[/td]
[/tr]
[tr]
[td]BSivakumar[/td]
[td]5[/td]
[td]2[/td]
[td]3[/td]
[td]Balamurugan[/td]
[td]Assigned[/td]
[/tr]
[tr]
[td]BSivakumar[/td]
[td]2[/td]
[td]4[/td]
[td]5[/td]
[td]Snehith[/td]
[td]converted[/td]
[/tr]
[tr]
etc…
,…
[/tr]
[/table]

Kindly send me the process to do. here customize MySQL also required.

This is not currently possible out of the box.

Thanks will,

How we can build module like employee module. Because we don’t have separate table for employee module its taking from users table. Kindly tell me process to build the module?

My requirements.

Build module with existing tables. (Employee - > Users)

Hello balamuruganfloret,

take a look on this Projekt, as start for your module…
https://github.com/UTAlan/Sugar-User-Activity-Module