Crystal reports is a wonderful tool for developers to develop reports for end users with fixed layout.

Have you ever seen a report generator/function in a program which allows the end user to choose tables/columns and create reports dynamically. Any lead/comment is welcome!