Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsReportsReportsShowcase and Blog ideaShowcase and Blog idea
Previous
 
Next
New Post
7/24/2006 7:20 PM
 
wildfiction

www.headvert.com
Joined: 6/17/2006
Posts: 240
Does anybody have a showcase web page where the report module is being used? I am thinking about using it to show the latest blog entry as per this post. ...but not sure if there's a better way to accomplish this... Using the same logic you could show the most recent 3,4,5 etc. forum postings...
ver 4.3.1 (to 8 July 2006) ver 4.3.2 (to 20 July 2006) ver 4.3.3 (to 5 Aug 2006) ver 4.3.4 (to 20 Sep 2006) ver 4.3.5 (to 25 Dec 2006) ver 4.4.0 (to date)
 
New Post
7/29/2006 10:05 AM
 
Andrew Nurse

Joined: 4/12/2004
Posts: 433
I'm not aware of any showcase web pages, but if someone else knows of one please post it! Personally, I'd love to see where it is being used, and it might help others find out ideas.

As for your question, right now the Reports module can only render a simple Grid for the data you retrieve. So I don't think its suitable for showing the latest blog entry.

I am doing research into the ASP.Net ReportViewer control which would allow you to use a graphical designer to create a report description and then upload it to your server and have it rendered on the page. I'm also looking in to using XSLT to allow admins to design their own way of translating the data into HTML to display on the page.

Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer
 
New Post
7/29/2006 10:13 AM
 
wildfiction

www.headvert.com
Joined: 6/17/2006
Posts: 240
The main use for the report module I see is as an admin task to keep track of certain "things" in the system that are not readily available by other methods.

To that ends, it would be useful if anybody could post sample SQL scripts that they use to glean info about their setups that help them manage their portals and sites.

For example, I wrote a piece of SQL (can't get to it right now or I'd post it) that showed me any duplicate email addresses in the DB - useful if you're switching from non-unique to unique emails on your portals.
ver 4.3.1 (to 8 July 2006) ver 4.3.2 (to 20 July 2006) ver 4.3.3 (to 5 Aug 2006) ver 4.3.4 (to 20 Sep 2006) ver 4.3.5 (to 25 Dec 2006) ver 4.4.0 (to date)
 
New Post
7/29/2006 10:27 AM
 
Andrew Nurse

Joined: 4/12/2004
Posts: 433
Great idea! The Reports module actually includes an Import/Export feature so that you can export your Queries, but there is an issue with it that I am currently fixing so for now feel free to post some SQL Scripts in the fourms.

I am hoping that we can create a sort of small repository of cool reports here so I'm going to try to set up a Sticky thread that will stay on the first page so I can list interesting SQL Queries that I come up with and that other users send in!

Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer
 
New Post
2/1/2007 10:06 PM
 
Bill Torre

Joined: 7/5/2005
Posts: 4
I found some pretty decent (admin related) sql scripts here: http://www.cathal.co.uk/Default.aspx?tabid=44
 
 Page 1 of 1
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsReportsReportsShowcase and Blog ideaShowcase and Blog idea


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out