Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

Affordable ASP.NET Hosting Service
  Ads  
 


  Sponsors  

Meet Our Sponsors

OnyakTech
CrystalTech Web Hosting™
Webhost4life, specialists in DNN hosting
Mad Development is a full service interactive agency focusing on the merge of design, technology, e-commerce, and affiliate marketing by providing total website solutions.
SteadyRain
DataSprings - Great Ideas. Always Flowing.
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Reports Module ...  Showcase and Blog idea
Previous Previous
 
Next Next
New Post 7/24/2006 5:20 PM
User is offline wildfiction
240 posts
www.headvert.com
9th Ranked


Showcase and Blog idea 
Modified By wildfiction on 7/24/2006 7:21:38 PM)
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 8:05 AM
User is offline Andrew Nurse
366 posts
8th Ranked






Re: Showcase and Blog idea 
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 8:13 AM
User is offline wildfiction
240 posts
www.headvert.com
9th Ranked


Re: Showcase and Blog idea 
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 8:27 AM
User is offline Andrew Nurse
366 posts
8th Ranked






Re: Showcase and Blog idea 
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 7:06 PM
User is offline Bill Torre
4 posts
10th Ranked


Re: Showcase and Blog idea 
I found some pretty decent (admin related) sql scripts here: http://www.cathal.co.uk/Default.aspx?tabid=44
 
 Page 1 of 1
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Reports Module ...  Showcase and Blog idea
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
 


DM Analytics, LLC
DM Analytics, LLC provides software solutions that facilitate rapid development of independent or dependent datamarts and their associated web-based reporting.
www.dmanalytics.com 		Integral Hosting | DNN only $14.95/month
Experienced .NET hosting on Windows 2003, ASP.NET 1.1 & 2.0, MSSQL with real technical support.
www.integralhosting.com 		Aricie
Aricie is one of the French pioneers and experts in DotNetNuke technology.
www.aricie.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP