Hi I have a very simple query which outputs a simple table, I am trying to add to one of the columns in the table links to different url's, and maybe even add more columns that will display data as pictures, random text etc...

My main thought was combining between forms and lists module and SQL View(?)
as in creating a table using forms and list and then one of the table columns for example will display data from my DB using SQL View.. is that possible?

is there a way to do that with SQL View or maybe with the pro version?

any help will be very much appreciated!

Yes, you can do that in SQLView you just need to build up all the html within the sql clause appending it all in a column. For instance you could do something like this to show an html link.

SELECT '' + urlTitle = "' AS Link FROM MyTable

where urlColumn is a column with a valid url (ie. http://www.something.com) and urlTitle contains the title for the link (ie. Visit the something website)

In the SQLView Pro version it's much easier though because you can create a template report instead of using the grid report and just reference fields like this:

[urlTitle]

Of course, in the template report you'll have to build the table up yourself as well. It just hands the data into the template and you reference the data using tokens such as [EACHROW] and the column tokens (ie. [urlTitle])

If you want to try it out, download the SQLView Pro trial and install it. It won't overwrite any SQLView Free version data, they are separate products. After you install, add SQLView Pro to any page, then choose the 'Browse Repository' menu item and select the 'Template Google Chart' and you'll see how the templating works. I also have a simple demo of templating here, http://www.dnnstuff.com/Modules/SQLViewPro/SQLViewProDemos/TemplateReport/tabid/380/language/en-US/Default.aspx.

WOW thanks alot for your help! it seems to be working fine with sql view
and I will download the pro version and test it as well.
thanks again!

You're very welcome.