You need to Register for free and Login to post a message in the forum.

Forum

Forums > DotNetNuke® > DotNetNuke® Questions
Subject: Creating a "top 5" table which gets its entries from another udt
Prev Next
You are not authorized to post a reply.

Author Messages
crook_sam
DNN Creative Magazine Subscriber
Nuker
Nuker
Posts:13
16 Apr 2008 4:48 AM  
Hi,
    I have a site which allows registered users (which is a sales force) to submit their figures using a udt table for each monh of figures.. I would like to be able to do some interesting things with the figures submitted such as some graphs etc and in particular would like a "top 5" table to appear based on the best performers for a particular month.
            Has anyone got some tips on how to manipulate the data in this sort of way, or even some suggestions of some interesting things that I could do with the figures and how I might go about it?

Thanks so much
                           Sam.
jncraig
DNN Creative Staff
Nuke Master II
Nuke Master II
Posts:2505
16 Apr 2008 8:13 AM  
If all of the data are in a single table, you might be able to use the Reports module to do this. Graphing is not included in any module with which I am familiar, though.
Joe Craig
DNN Creative Support
Subscribe to the website
crook_sam
DNN Creative Magazine Subscriber
Nuker
Nuker
Posts:13
16 Apr 2008 8:51 AM  
Thanks alot for the reply, I shall have a closer look at the reports module, do you know of any good tutorials anywhere on the reports module?
Thanks again,
                       Sam
jncraig
DNN Creative Staff
Nuke Master II
Nuke Master II
Posts:2505
16 Apr 2008 8:01 PM  
I'd think that many of the concepts used in the UDT module would be applicable to the Reports module.

Both of these modules are conceptually fairly simple. But because the permit you to executle SQL and then do transformations on the resulting data, you can easily cause them to do rather complicated things.

I note that you can have a grid visualizer, an HTML template visualizer, or an XSL Transformation visualizer. So, you could go quite wild with this. And, since the Reports module executes an SQL query, it could combine data from multiple tables if you construct things "correctly."

I'd LOVE to see some examples of use of Reports and/or UDT to do some really complicated things ... just to demonstrate the possibilities ...

I'd also check the documentation at the DotNetNuke.com site.
Joe Craig
DNN Creative Support
Subscribe to the website
jncraig
DNN Creative Staff
Nuke Master II
Nuke Master II
Posts:2505
16 Apr 2008 8:06 PM  
Well, I highly recommend that you take a look at the DotNetNuke.com forum for the Reports module. I just spent a few minutes poking around and I think that I could get lost there easily for a few weeks! Lots of good stuff, discussions of custom or add-on visualizers, etc.
Joe Craig
DNN Creative Support
Subscribe to the website
You are not authorized to post a reply.
Forums > DotNetNuke® > DotNetNuke® Questions > Creating a "top 5" table which gets its entries from another udt


ActiveForums 3.7

Latest Forum Posts

Create new 'host' user? by jonathanbrickman0000
I have a DNN 4.7 web site successfully migrated to a new server.  There is only one hitch:  the 'hos...
RE: split copyrgt option in two lines by jncraig
You can put a in the copyright text. This may or may not put other text (to the right of the copyr...
RE: Can't Login! Login Page can't be accessed... by jncraig
Try: http://localhost/DNN/login.aspx http://localhost/DNN/?ctl=login If neither of those ge...
RE: HOw to upload site from localserver to www.mysite.com by jncraig
View this tutorial:How to transfer a localhost DotNetNuke installation to a live websitePay special ...
RE: Nightmare with SKINS... by jncraig
Before you get in too far, you might want to take a look at:An Introduction to the Principles of Dot...
RE: Nightmare with SKINS... by dougieladd
Hi Joe...thank you for that...I kind of assumed that was the case. As I understand it the skin comes...
HOw to upload site from localserver to www.mysite.com by aniket.rasal
Dear Friends,       I have created site. Its wolring fine on my local machine.But when i upload the ...
RE: DotNetNuke 4.9.1 and 5.0.0 by leesykes
It is on the Extensions page as well - named 'Batch Install Extensions' stefan blogged about it here...
How to Change fckeditor alignment by aniket.rasal
Hello Friends,       I am creating site with customized skin. In that i want to change the alignmen...
RE: DotNetNuke 4.9.1 and 5.0.0 by leesykes
Talk about hiding things - it took me a while even though it was staring me in the face!In the Contr...
RE: DotNetNuke 4.9.1 and 5.0.0 by leesykes
This post is worth a read in the main dnn forumsHaving upgraded, one thing that is confusing is wher...
RE: DotNetNuke 4.9.1 and 5.0.0 by leesykes
Hello, I've just been experimenting with this upgrading a fresh 4.6.2 (default installation no ex...
Can't Login! Login Page can't be accessed... by durationinc
Hi guys,I develop a website using DotNetNuke 4.9.1. I can't login after I did some modifications on ...
split copyrgt option in two lines by meenu
in dnn0408 website,I added copyright option in admin page settings.now my option is like this"Copyri...
PopUp Page by meenu
hiin my dnn0408 website i added one page named "PopUpMap".....in page settings of Popup page i selec...
RE: link to outlook by meenu
hi joei did the settings...working fine...thanks...
RE: Navigating between modules by Germaine
Hi Hi, anyone out there who can help me in this?? thanks
RE: New Logo cant display by Germaine
Hi Joe, yes I have a filed name Logo.png in the portal's root directory. I have added it into my pro...
Child portal to live site by psgrzelak
Hi all, I am new to the DNN universe but I have administered sites with Front page and Dreamweaver. ...
RE: PDF File Content by dongoldwater
I have reports that are strictly pdf files and want to incorporate them in a module. Can I insert t...
AppTheory
RSS Feeds