Download DOWNLOAD
Forums FORUMS
Blogs BLOGS
Forge FORGE
Help HELP
Marketplace MARKETPLACE
DotNetNuke Home
You are here >   Development > Forge > Module - Reports
Register  |  Login
Purchase

DotNetNuke® Project :: Reports Module

The Reports module provides a simple, but flexible, view on data from your DotNetNuke Database. SuperUsers (aka "Host" users) can develop Reports by building a SQL Query and visualizing it with one of the Visualizers built-in to the module or a 3rd-party Visualizer.

How can you use the Reports Module?
  • Display a table of custom data from your Database
  • Display a list of Users in a specific Role
  • Display advanced queries that pull data from multiple tables
  • Display a chart of the number of users in each role
  • Display a report from SQL Reporting Services (EXPERIMENTAL)
Features: What can the Reports Module do now?
  • Display the results from any SQL Query in one of many ways:
    • a Grid
    • a Chart
    • an HTML-based template
    • an XSLT-based transformation
    • or anything else you want with the extensible Visualizer framework
  • Display reports from SQL Reporting Services
  • Import/Export Report Definitions through standard Import/Export Content
Roadmap: What are the future plans for the Reports Module?
  • Full support for the ASP.Net ReportViewer Control and SQL Server Reporting Services
  • Custom Parameters such as @PortalID, @TabID, @UserID that are filled in when the query is run
  • Custom Data Sources to enable the module to display reports containing data from:
    • Your DNN Data Provider
    • Other SQL-based Databases
    • XML Data
    • UDT Module Data
  • Allow SuperUsers to predefine a set of Reports that Admins can use (at this time, only SuperUsers can create Reports)
The project can be downloaded here

View_Blog

May 18

Posted by: Joe Brinkman
5/18/2006 8:19 PM 

Scott Hanselman recently posted a blog entry seeking a senior developer to work at Corillian. His post has some pretty specific requirements about the knowledge needed by a potential applicant.  Scott made a comment that some people find his requirements to be too difficult or totally irrelevant.  Jeff Atwood talks about the flip side of this coin which is stupid interview tests.

I have pretty strong feelings on this front.  I have conducted a ton of interviews over the last several years and found that our industry is loaded with a ton of programmers with inflated job titles.  I have run across people who have only been out of school for a couple years who claim to be "Senior" programmers.  I have seen others who think that because they have been programming for 20 years that they qualify as a Senior programmer.

I come from a different school of thought.  I believe that the number of years of programming experience has little bearing on whether you are a senior programmer or not.  If your 20 years of experience consists of writing software applications which would be good candidates for The Daily WTF, then you do not fit my definition of a senior programmer.  I could be the best programmer in the world when working with ASP.Net, but I would never claim to be a Senior PHP developer.  I may have skills which are transferable, but more than likely, my first couple of PHP applications would likely not exhibit good PHP programming practices.  My applications would likely look like ASP.Net applications written in PHP.  This is similar to the problem encountered by many VB programmers who move to VB.Net.  Many of them write procedural VB.Net with properties, methods and classes liberally sprinkled on top.

When interviewing candidates I like to start with a set of questions that give me some points from which I can drill down to truly assess the candidates understanding of programming in general and the specific technology needed for a given project.  I look for both breadth and depth and don't worry about someone knowing or not knowing one specific question.

At first glance, the question referenced in Jeff's blog may seem like a case of trivial pursuit that has no bearing on a candidates skill, I would disagree.  If you look at the full back and forth you see that the candidate has a good understanding of the file copy task.  He/she realizes that there are many issues that must be addressed in order to complete the task.  I would love to have a candidate who would ask these questions.  It says that they are thinking about the problem and how to solve it. 

So what are some typical questions I would ask of an applicant for a Senior ASP.Net developer?  This is an excerpt from a questionaire I used to screen candidates for a project lead position (note: I ask these questions in person so I can ask followups depending on their answers):

VB.net

 

  1. What is Reflection?
  2. What is the difference between an abstract class and an Interface?
  3. What is a delegate?
  4. Name two ways to assign events?
  5. What are attributes?
  6. How is ADO.net different from ADO?
  7. What is a dataadapter, dataset, dataview and datareader?
  8. What is the GAC?  How do you put your code in the GAC?
  9. What is side-by-side execution?
  10. What is MSIL?

 

ASP.Net

  1. What is a code-behind file?
  2. What is the difference between User Controls and Server Controls?
  3. Why would you build one versus the other?
  4. What is the purpose of the Machine.config file?
  5. Web.config file?
  6. What is an HTTPModule and an HTTPHandler?  Give an example of how each one might be used.
  7. What are the differences?
  8. What is viewstate?
  9. What is the difference between WebControls and HTMLControls?

Now some of these questions may be too trivial or too simple, but I found that the answers given could lead into whole new discussions.  I also found that the best candidates were not afraid to admit that they might not know the answer to a specific question.  I would rather have a developer who knows their own limits versus one who thinks that they know all there is to know about a given topic.

Tags:

2 comment(s) so far...

Re: Trivial Pursuit or Skill Assessment

In my experience the best method is to tell the applicant to bring in a large amount of code they wrote. Now lets go over it and you can explain your logic.

By AdefWebserver on   5/18/2006 5:44 PM

Re: Trivial Pursuit or Skill Assessment

David,
I am really not sure what your point is with both of the above comments. Do you think the questions are helpful or not? Keep in mind that the questions are starting points for further discussion and not as some wrote memorization exam. For example, the question about code behind leads naturally into more questions about n-Tier architecture, separation of concerns, automated code generation, etc. Also, depending on the skill level required for a position, I will look for a more thorough understanding of the design considerations involved: both on the part of MS in their framework design, and on the part of the developer who now must work within the constraints imposed by those design decisions.

As for the book; I know that most authors write books about a topic that interests them, or related to a topic where they have in-depth knowledge. In the case of the DotNetNuke books, we wrote them because there was a need in the DotNetNuke space for more documentation. I agree that a book about Practical ASP.Net would be of great value, but in this case it would not address the needs of thousands of DNN users who need help on how to use and extend DotNetNuke.

By jbrinkman on   5/23/2006 12:45 PM

Sponsors

DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation

Hosted by MaximumASP