For instance, the following SQL statement works correctly and displays all the rows.

Select * from DAWNArtCommTable

I would like to display only the rows of a table that have a certain value in a column.

For instance, the following SQL statement would get only the rows where ArticleID is Hello2 and this statement does work correctly on the reports module

Select * from DAWNArtCommTable where ArticleID='Hello2'

And most importantly can a variable be brought in through the http querystring and then go into the SQL string?

For instance, something like the following

Select * from DAWNArtCommTable where ArticleID=MYVARIABLE

With the following added to the end of the address or the DotNetNuke page that the reports module is on.

?MYVARIABLE=Hello2

And then I would like it to display differently than everything in column and rows.

Is there some way to display cell info where I want on a page. For instance of one cell would be displayed on on the first row and then each roll under that the next cell and in some page rows have more than one piece of information. And then for a each table row have that format like in HTML. Something like a guestbook where all the guestbook records are shown but they aren't in a direct spreadsheet looking page.

And you know where I can find examples of of SQL statements. I've access Microsoft access databases and the statements are very similar to SQL statements. I have written some SQL statements but it has been awhile.