hi I am working on Microsoft SQL Server 2008 R2 -report services.I use a combo box to show all table's name in my database it fills by a query .this table name will pass to another store procedure to creare my select command .this select contains all exist fields for your select tablename .
untill now I created select command for all tables . now I want to pass this select command to another dataset .how can I display dynamic fields .bz every table have different fileds.
If you are using dynamic sql you will have to add fields manually..
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance