Display a datagrid using the dataset as the source?

I am not sure how to display this in my report. I have dataset that queries the database to find a list of ingredients. I would like each ingredient listed in a grid. Under each individual ingredient is its amount, which is found from the database, using the Product and Ingredient name discussed above. The ingredient dataset has a list of ingredients. So I need the first one displayed in the first field, the second in the second field and so on. Then I need to ordert the Amounts Dataset properly so that the amount appears directly below the appropriate ingredient. How do you make a table cell display the first member of a dataset, then the second cell display the second and so on? Right now it is trying to display all the ingredients in one cell. I hope this makes sence. Thanks.I dont know if that makes any sence, so I found some better words to describe my problem. I have a table that I would like to transpose. This table could be long, so I only want it transposed for 5 or 5 columns, then word-wrapped to the next line so it can all fit on one page. How do you transpose a table. Is this a reporting issue, or should this be done on the Sql side? Thanks.sql

Disabling the AUTOCOMMIT option in MSSQLServer

Hello,

Is there anyway.. we can disable AUTOCOMMIT option in MSSQL server
while executing the SQL queries via SQL ANALYZERbegin transaction|||On 8 Jun 2006 08:01:15 -0700, Uncle Sam wrote:

>Hello,
>Is there anyway.. we can disable AUTOCOMMIT option in MSSQL server
>while executing the SQL queries via SQL ANALYZER

Hi Sam,

In Query Analyzer (for SQL Server 2000): Tools / Options / Connection
Properties / Set implicit_transactions to ON. This affects only new
connections.
Also in Query Analyzer: Query / Current coonnection pproperties / Set
implicit_transactions ON to affect the current connection.

In SQL Server Management Studio (for SQL Server 2005): Tools / Options /
Query Execution / SQL Server / ANSI / SET IMPLICIT_TRANSACTIONS ON (for
new connections), and Query / Query Options / Execution / ANSI / SET
IMPLICIT_TRANSACTIONS ON (for the current connection).

--
Hugo Kornelis, SQL Server MVP