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

Forum

Forums > Users Lounge > DNN Creative Articles
Subject: Tutorial for Reports Module
Prev Next
You are not authorized to post a reply.

Author Messages
pcdhake
Nuke Newbie
Nuke Newbie
Posts:8
19 Sep 2007 1:43 PM  

Hi Lee,

I'm a subscriber of your monthly magazine and have been very happy with your offerings. You make everything seem to simple and straight forward. Please keep up the good work.

I have a quick question for you today - I am trying to gather some information on the Reports module and was wondering if you have already published one such video tutorial on the Reports module.

If yes, can you help me find it please? I'm very bad at searching for things - they're right under my nose and I can't find 'em.

Regards,
Parry
jncraig
DNN Creative Staff
Nuke Master II
Nuke Master II
Posts:2318
19 Sep 2007 8:27 PM  
I don't see a tutorial on the Reports module.

But, even if there isn't one, what is it that you'd like to know?

You install the Reports module just as any other module. Then, you can put the module on any page.

Basically, you configure a Reports module to include an sql query, and the module will execute the query and display the results. Presumably, you can create simple to quite complex queries. You can also display the results in a grid, with an html visualizer, or you can do an xml transformation visualizer.

If you ask some specific questions, I'm sure that we can give you some answers.
Joe Craig
DNN Creative Support
Subscribe to the website
jncraig
DNN Creative Staff
Nuke Master II
Nuke Master II
Posts:2318
19 Sep 2007 8:34 PM  
As an example ... put this in the query box: select * from users

If you leave all of the other parameters at their default values, then you'll get a table of all users registered at your site.

I'd recommend that you do your testing with pages visible only to administrators. Other words, you could put information on your public pages that shouldn't be public.
Joe Craig
DNN Creative Support
Subscribe to the website
leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3325
20 Sep 2007 4:11 AM  
Hi Parry,

Please do not reply to the forum emails as they come directly to me, please reply in the forum, thanks, Lee


Actually, I'm thinking of using a very simple master/detail functionality into my website. There will be a grid which will display a list of records (with paging) and there'll be another panel (which would have textboxes) for the user to enter some values.

Just a typical master/detail functionality is what I'm looking for and I don't know if DNN can help me here - or if I need to build my own custom module.

 
Regards,

Parry




Is there any way by which we can allow "intra-module" communication ? In other words, is it possible to pass values from one module to the other ?

Regards,

Parag
Lee Sykes
Site Administrator
Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

Twitter: www.twitter.com/leesykes

Lee Sykes's Facebook Profile
leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3325
20 Sep 2007 4:15 AM  
In the past if I have needed to present info in master / details functionality I have created a module for it. - The latest version of XMOD maybe able to cover your needs though and would be worth a look / enquiry to the XMOD team.
Lee Sykes
Site Administrator
Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

Twitter: www.twitter.com/leesykes

Lee Sykes's Facebook Profile
jncraig
DNN Creative Staff
Nuke Master II
Nuke Master II
Posts:2318
20 Sep 2007 8:12 AM  
Yes, if you want to create modules that communitcate with one another, look at DotNetNuke.Entities.Modules.Communications. If you google, you'll also find some other tutorials or blogs that have some examples of these object in use.

There is a very nice class browser at http://classbrowser.subzero-solutions.net/. It includes a section with all of the DotNetNuke libraries.
Joe Craig
DNN Creative Support
Subscribe to the website
You are not authorized to post a reply.
Forums > Users Lounge > DNN Creative Articles > Tutorial for Reports Module


ActiveForums 3.7

Latest Forum Posts

RE: Reversing Limited Access to the Admin Menu by wynnjon
OK-So I've updated the TABS table entries in the database and set the previously modified entries (t...
RE: localhost Install issues by leesykes
If you go to the subscribe page and click on the get free trial button - this takes you to a page wh...
localhost Install issues by cdees
I've set up a local host and want to run DNN for a local development machine.  The host is set up; h...
RE: Reversing Limited Access to the Admin Menu by wynnjon
That is what I thought.  So for my clients that will need to manage user accounts, I can not limit t...
RE: Reversing Limited Access to the Admin Menu by leesykes
I seem to recall it doesn't work
RE: Reversing Limited Access to the Admin Menu by wynnjon
Thanks Lee-  I will give that a try.An additional question- If you place the "User Accounts" page un...
RE: Reversing Limited Access to the Admin Menu by leesykes
all you need to do is reverse the process within the SQL tables.Compare the data to the other rows i...
RE: Module not working when logged off. by leesykes
thanks for the info,
Reversing Limited Access to the Admin Menu by wynnjon
Hi!  I followed the tutorial for limiting the access to the admin menu.  What a great thing!However,...
RE: Trouble installing! Designer trying to be a Developer. by leesykes
glad to hear you found a solution, thanks,
RE: Skim Question by leesykes
You could but you will not be able to have an XHTML compliant page as the SolpartMenu is non-complia...
RE: Include in Menu - Weird Request by leesykes
For your sitemap.xml file - use GSiteCrawlerYou could create the site map before moving the sub menu...
RE: Trouble installing! Designer trying to be a Developer. by awright14
It looks like I had ASP installed in the wrong order.  Copying and pasting this into the Run Command...
RE: Need Help Changing Containers Contentpane's Text Color by leesykes
Hello,Have you tried adding a class to the content area of your container and then styling the p, a,...
RE: Vertical SolpartMenu by leesykes
hello,If you wish to display the admin and host menus within the house menu, you need to enable it i...
RE: Firefox Does Not Display WMV File In Media Module by leesykes
Hello,I have just tested this and I can play a wmv file in Firefox 3.0.3, so it does suggest that it...
RE: advice wanted convert site to DNN while keeping existing asp functionality by leesykes
You could try using the IFrame module in DotNetNuke and then just link the IFrame to the current pag...
RE: Need Help Changing Containers Contentpane's Text Color by CROKeefe
Thanks for the quick update... I know it looks broken right now, but I had the TITLE classes working...
RE: Need Help Changing Containers Contentpane's Text Color by leesykes
The default class for a container is .head so you will find that the .head class will override any s...
RE: Module not working when logged off. by t.ramya85
have to set the cache time to '0' in that module setting.
AppTheory
RSS Feeds