Products

Solutions

Resources

Partners

Community

Blog

About

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 ForumsReportsReportsTwo Questions about ReportsTwo Questions about Reports
Previous
 
Next
New Post
8/17/2006 12:44 AM
 

1. Is there any chance this will be back ported to 3x?

2. Is there a way to add a template for a single row query to be able to produce something like a invoice ?


Dylan Barber http://www.braindice.com - Dotnetnuke development classes - skins and modules
 
New Post
8/17/2006 1:00 AM
 
Hi! Thanks for your questions, I hope these answers help.

  1. Not likely, one of the reasons this module was created is to provide an example for developing modules using the Dynamic Compilation features of .Net 2.0 and DNN 4.x. So, sorry but there aren't any plans to backport
  2. If I understand you right, you basically want to do something similar to the Reporting provided by Access, Crystal Reports, and other tools. My current plan is to incorporate the ASP.Net ReportViewer control into the module in the next version. This means you could create more detailed reports (such as invoices) from the database. So at this time, the answer is no, but its coming

Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer

 
New Post
8/17/2006 1:19 AM
 

Okay - got why you are not backporting it - could you do me a favor and talk a little about how the module works - i need some sort of reporting to incorporate into a module and so far have had no real luck - heres what I have tried so far

1. Created a server control the module loads dynamically so each report would be its own project and could be loaded kind of like modules are -

     PROBLEMS so far: control loads fine but buttons on the control never fire (have an export to excel button and feature)

2. Created a new page in the module and set it up

         PROBLEMS: this works perfectly for the most part - the export grabs the whole site but it sort of works - real problem is the data colected by the module is so variable that we have lots of reports of different kinds and new ways to do each report that redoing the module every day or time is not really viable

3. Created Reporting Services reports

        PROBLEMS: works but one of our main queries is so complex (crosstab query) that the report we have tried to create keeps failing and we cant find any good info on what to do

 

If you could talk about what you are doing and how you achieve it maybe I coulod get some good ideas

 

TIA


Dylan Barber http://www.braindice.com - Dotnetnuke development classes - skins and modules
 
New Post
8/17/2006 2:09 AM
 
The Reports module is fairly simple right now, and I don't know how much it will help, but I will go over the process:
  1. The Module Executes the Query specified in the Module Settings and creates a System.Data.DataTable object containing the results
  2. The Module sets up an ASP.Net GridView control with the correct columns and sets its DataSource property to the DataTable
As you can see, its fairly simple at this point. I don't know much about designing Reporting Services reports (I only have to know how to display them ) so I can't really help you there.

As for how Reporting Services will be integrated into the next version, the plan is to just embed an ASP.Net ReportViewer control which basically does all the work (just pass it the Url to a Report and it display it).

Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer

 
New Post
8/17/2006 5:06 AM
 

Got ya on what you are doing which is what i did in the first idea I had

Heres an idea for you if you want to make this configurable and useful beyond simple grid reports

for queries that return a single row have a replacement template engine that will cycle through the query and the template and replace known tags such as [first_name] with a value from the database

for queries where a grid is appropriate adapt the template engine to do a grid with some sort of table designation for the template such as:

[grid]

[first_name][last_name][username]

[/grid]

here [grid] would tell the template engine to make a datagrid and fill it with rows from the query in the order the tags are in

or even a xml type of fragment could be used - im not good with XML yet so not sure how that might look


Dylan Barber http://www.braindice.com - Dotnetnuke development classes - skins and modules
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsReportsReportsTwo Questions about ReportsTwo Questions about Reports


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