I don't think websheets have enough functionality for my needs.Probably not, but you can report on websheet content in other applications such as Business Objects.
I need to look at creating a page were the user defines a table, ie, colums, data typesCreating database objects dynamically will cause you lots of problems, so I wouldn't recommend going this way. Better to define a database structure which is static and contains metadata to describe what is in the columns.
Is it possible for the user to create a page with a interactive report on the click of a button.No, but you can define a classic report based on dynamic SQL. Users cannot create pages.