Is anyone using SQLView on their site currently? If so, what are you using it for. If you include the url, I'll post your site on the SQLView module page as well.

Hi,

Just downloaded it and it looks great. I love the style flexibility. I use SQL queries extensively on my site (jigsaw.net) to display account and sales related data and have about 160 reports ranging from monthly sales recognition like Top Sales, Top Recruiters, Top Talks (Party Plan distributors) etc. Also have account reports to show monthly invoices, sales averages, warehouse reports, top products, statements etc all pulling information of our accounting system (ACCPAC). We have completely automated our reporting and recognition so now all we have to do is enter in our distributor orders and all reports are shown on our Portal with no one having to maintain the site. Before we had a full time person just producing our newsletter and sales reports. Even our monthly commission and distributor promotions are reported automatically.  We also show what is our monthly specials and stock status updates on the Portal. Another great way we personalise our home page is we show Happy Birthday messages, welcome to new distributors and MTD and YTD sales and reward points for the user that is logged on (they logon using their account code so we can pull all the relevant data from the accounting system).

I am using PowerReports and SQL Grids but both have limitations which your SQLView solves (and it is free!). Great job. I look forward to any enhancements which I would gladly pay for. I will post what enhancements I would like to see in the other forum.

Need some help understanding the Grid Styles in SqlView.. Is there a Doc somewhere I missed?

Thanks
Pat

Hi Pat,

Yes, there should be a help.txt in the folder in desktopmodules\dnnstuff - sqlview which explains all the options. You can view this through the help menu of the module.

The styles are as follow:

Grid Class            - A valid CssClass that will apply to the grid (try SQLViewGrid)

Grid Header Class     - A valid CssClass that will apply to the table header (try SQLViewHeader)

Item Class            - A valid CssClass that will apply to the odd numbered rows (try SQLViewNormalItem)

Alterating Item Class - A valid CssClass that will apply to the even numbered rows (try SQLViewAlternatingItem)

Pager Class           - A valid CssClass that will apply to the pager (if activated)

Header Text Class     - A valid CssClass that will apply to the header text
Footer Text Class     - A valid CssClass that will apply to the footer text

There are styles already located in the module.css file located in /desktopmodules/dnnstuff - sqlview which you can use to try things out. These all begin with 'sqlview'. If you want additional styles, either add to this file, or add styles to your portal.css or default.css file.

Hope this helps.

Richard

I was looking for a DNN3 module to display a random image... then I thought of SQLview and managed to achieve it with this:

SELECT TOP 1 '<img src="http://myserver/images/' + cast(imageid AS Varchar) + '.jpg" alt="' + alttext + '"><br>' + ImageLabel  AS description FROM mytable

 order by    NewID()

:o