Customize a report in run time?

[mythinky]

Helo, guys
1. How can I produce a report that based on the user?
For example, if the user want to display a column, that it can make a report of it.

2. How can I select data from a table that its database is chosen based on the user?
e.g. "SELECT * FROM databasename..TABLE"
I wanna the report display the data based on databasename.. Cause the database name is changing according to the user needs.

 

[Gousi]

Hi,

Are u maintaining the detail about the User and the Database Name in an Table?

Where u want acheive these functionality? In Crystal Reports or .Net Coding

I can provide u the solution if you let me know the above details.

Thanks,
Gousi

 

[LandDestroyer]

I want to know about this too. Help!
I have a group of zip codes. I want to make a report that lists all the information from the store table for stores that have the zip codes that are checked. When the user checks 71111, 71006, 71497, I want the report to get only those stores/rows from the table and put those in the report. I only know how to make the crystal report wizard display all rows from a table or querie. How can I do this?

Thanks,
Chris Gregory
christopherleegregory@hotmail.com