Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Quick login...


Or... now make it easy with Facebook Integration
Connect via Facebook



Top Sellers

Frustrated over the lack of customization for your user's registration fields? Dynamically setup your DNN Portal with custom registration fields, layout, questions, and other core integration options......

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to upload videos in various format and automatically encode them to flv or H264 format, you also can add videos from internet or record live videos from your webcam.

Build high performance, completely customizable data-entry forms and views driven by your DNN and external databases. New built-in tools make it a snap to quickly create data entry forms, data views, and even database tables. Plus, add your own HTML, CSS, Javascript, SQL commands, stored procedures,

The most advanced DotNetNuke shopping cart on the planet. Easy to use e-Commerce, Secure Shopping Cart Software and SEO friendly. B2C / B2B Ecommerce Sites.

One stop solution for events calendar and events registration! FREE DOWNLOAD is available now!

Simple List Report
Last Post 07-09-2012 05:29 AM by Ryan Bakerink. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Joseph AllenUser is Offline
wading in the water
wading in the water
Posts:20
Avatar

--
07-06-2012 11:28 AM
    I am trying to develop a simple list report similar to the vanilla DNN reports module. I am want to use Dynamic View for the export to excel feature.

    I am having several issues.

    1. How do I create a simple 5 column view? The module seams to be geared towards complex layouts and I want something that looks like a speadsheet.

    2. When I export data to excel all columns in the table are exports. I only want the 5 columns I selected to be exported not 55 columns.

    3. I need to filter using a basic SQL where clause: "WHERE LEN(Venue) = 0 OR DataLength(Content) = 2 OR DataLength(Content) = 24" I can't seem to figure out how to implement this using Dynamic Views.

    4. I have gotten a "Problem Loading Page" error several times causing me to delete the page, go to the recycle bin to delete the bad module, then restore the page.
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    07-09-2012 05:29 AM
    Hello Joseph,

    Let me see if I can assist you.

    Regarding Question #1:

    I would recommend going into the Module Configuration of the Dynamic View and use "Multilined Textboxes" instead of "Rich Text Editors" for the Template section. I would then encourage you to use a combination of the Header, Item and Footer template to achieve a layout that include a header and records listed below the header.

    In the Header Template Section, start a HTML table and include all of your Header information(Don't close the table in this template, meaning don't provide a closing Table tag).

    In the Item Template Section providing all of the Dynamic tokens inside in a table format using TR and TD tags to match up with the Table that you started in the Header Template.

    In the Footer Template Section provide a closing table tag.

    Now you should have a report layout that looks more like an Excel report.

    Regarding Question #2:

    You can limit which columns of information you want to Export to Excel. Inside of Module Configuration you can click the Excel Icon to the right of your Generated Columns. When clicked you'll see the Green Excel icon change to a Red Icon indicating that field isn't going to be included in the Excel Report.

    Regarding Question #3:

    If you're going to use a WHERE Clause then I'm assuming that you're using the Custom SQL Datasource? If so, is this SQL in a Stored Procedure? If it is then you need to Enable "Allow Free Form". Enabling this feature will result in your search filters working no longer. However there's a workaround for this. Also you need to make sure that your SQL is valid.

    Regarding Question #4:

    If the SQL you're providing in the Custom SQL Datasource section is invalid syntax or semantics then the module will error out like you're experiencing. I would recommend testing the syntax of your SQL statement in SQL Server Management Studio before using a bad query.

    Also, if you find yourself wanting our assistance/involvement with configuring your Dynamic View please review our Premium Integration Service at the link below:

    www.datasprings.com/premiumsupport


    Let me know if you have any questions. Looking forward to hearing from you.

    -Ryan

    You are not authorized to post a reply.


     
     

    Join our mailing list...

    Get current news and events the easy way
     
     
       
    Subscribe Me

    Recent Blogs...

     
    Copyright 2005 - 2011 by Data Springs, Inc.
     
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi