Add any comments or questions regarding the DotNetNuke Core Reports ModuleTutorial

I only see links for the first video are you adding them even as I speak (7/14/11) so that they will all be there tomorrow? If not how do I get to the rest of them?

Hi, the videos will be released in stages, normally fortnightly, we'll publish the release dates as soon as we can.

Damn, I sort of need that information now? Obviously you have already created the videos themselves or you would not know the length to the second.

Any chance I could become a 'Beta' user on these videos?

Could I just 'borrow them for a few hours?

It is not an emergency so there is no need for you to bend over backwards. Thanks for the videos in general they are very helpful to a completely ignorant newbie such as myself

You can always ask questions!

The first tutorial does, though, introduce you to the basic functioning of the module. Just getting some data displayed by the module is a big first step.

Hi
Any idea when the last 3 videos will be published?
Regards
Richard

Parts 1-5 have been published. Part 5 was just published. I believe the schedule is bi-weekly.

Hi
Just started to use the Reports module in “anger” – nice and powerful.

But I got slightly caught out.

I’m giving users the opportunity to get results for their “team” we’ll call them Arsenal and Liverpool. I had them defined in an SQL table, with ClubName nchar(20) and then the data for the team.

I built a report to list the teams and then passed ClubName as a parameter, as you do in video 7.

So I have …../tabID/464/ClubName/[ClubName]/default.aspx

The test with …../tabID/464/ClubName/Arsenal/default.aspx worked a treat but when I passed the Club name as a parameter
…../tabID/464/ClubName/Arsenal!20!20!20!20!20!20!20!20!20!20/default.aspx

[ ! = % but this editor actually converted "% 20" to a space]

And therefore failure

So for future reference best to use 2 tables ClubID (Int) ClubName (nchar(20)) then ClubID and the results in the 2nd table – Which is best practice for Databases anyway

Can I ask you to produce video 8 – applying CSS formatting?

I’d like to know how to get

Row 1 – white background
Row 2 – light blue background
Row 3 – white background
etc

Invaluable videos

If anyone would like to see this in action

http://www.dorsetgolfleagues.co.uk/...cords.aspx

Work In Progress (4 March 2012) should be fully live by 1 April 2012

Thanks


Dave

For the club name, you didn't say how you get the name from the SQL table and construct the URL but your SQL could TRIM the club name to remove leading or trailing blanks before you construct it.

You would do something like select ... LTRIM(RTRIM(ClubName)) as CLUBNAME ...

For alternating table rows, you can use jQuery to add a class to alternate rows. Take a look here for one example: http://www.aliaspooryorik.com/blog/...ripes--16. You will have to modify the script to target the specific table. The Reports module assigns an ID to the table (something like id="dnn_ctr576_ViewReports_Visualizer_grdResults") to change the script to target that ID rather than a class.

Hi Joe

I'd thought of TRIM (from my VB days) not seen it before in SQL.

In the last video you show pages by user and then a link to the next page which shows the pages created by that user.

So Miko has 4 pages and when you click the number 4 you get to see Miko's 4 pages

And that new page shows the User Name, Page and Tab ID

I'm wondering if with the HTML Template Visualiser you can actual get

UserName: Miko
Page | Tab ID
First Page | 247
Second Page | 546
Third Page | 700

etc

Although I think the solution might actually need something else like 2 report modules

e.g.
Report Module 1: Select UserName where UserName = "Miko"
Report Module 2: Select User Pages etc Where Username = Miko

I welcome your thoughts

I am having trouble uploading my htmlo template. In the module settings I have changed the Active Visualizer setting to HTML Template Visualizer. (html files are allowable upload types in host settings)
When I attempt to upload my html file from within the reports module I get the following error:
An Error Has Occurred When Attempting To Save The File seo.html. Please Contact Your Hosting Provider To Ensure The Appropriate Security Settings Have Been Enabled On The Server.

The error message indicates that there is a file permission error. Are you able to upload other files to your site?

Check the that IIS AppPool Identity has full permissions for the entire website directory.

Thanks Joe. I checked with my hosting provider and they tell me all permissions are set proprely. I have no problem uploading the file directly in the DNN File manager. This problem only occurs from within the DNN Reports module.

Hi again Joe,

O.K. this is very strange. I just added the DNN Reports module to a page that also has the Datasprings Dyn Views module on it and everything in the Reports module seems to work fine. But when I add the Reports module to a page by itself, the upload funtion will not work and I get the error.

Which version of DotNetNuke?

Which version of the Reports Module?

DNN 6.2.5

Reports Module 5.5

On a test system: DotNetNuke 7.0.4m Reports 5.5 I had no problem uploading an html file.

Now: what was the actual error message? Did it have to do with restricted file types? If you, you need to go to host settings and make html files legal for uploading.

Can you upload an html file through the file magager? If so, do that and then just select that file when adjusting the Reports module settings.

Hi Joe,

Yes, HTML files have been added to allowable file types in Host settings.
I did just what you said here, I went and uploaded the file through the file manager with no problem. When I went back to the Reports module and the file would not show up in the drop down of availble HTML files.

Here is what I have discovered but still cannot explain. I had set up a page called "Reports" on the Host menu. It had a Reports Module on it. I also had two other pages set up as children of that "Reports" page, also with Reports Modules. It was the Reports Modules on these child pages that were giving me the problem. I moved these two pages out from under the "Reports" page and made them parent pages on the Hosts menu (Like the Reports page)and viola, everything worked as it was supposed to! The uploaded HTML files now displayed in the dropdown and I was also able to upload other HTML templates.

I cannot explain this but everything is working now. Thanks for your help Joe. Let me know if you have any thoughts as to why this happened.

No I don't have a good explanation. Maybe it has to do with the pages being Host pages?

Is the Reports Module available in DNN 6.2.5 Community edition? I cannot find it?

Yes, all of the core modules are available for download at codeplex.com.

For the Reports module: http://dnnreports.codeplex.com/

According to the release notes, the current version of the module is compatible with DotNetNuke 5.4.4 and higher.

You can find all of the core modules by searching for "DotNetNuke xxx Module" at codeplex.com. In more recent versions of DotNetNuke there are options on the Extensions page to search automatically at codeplex.com and also store.dotnetnuke.com.

I have a currency field in my table but the select statement returns unformatted number results. please what do I do to format the field to the currency format?

This is a useful reference: http://technet.microsoft.com/en-us/...13505.aspx

Thanks.
CONVERT(varchar(12),convert([FIELD])) , 1) worked.

The tutorials on HTML visualizer was very good. How about tutorials on other visualizers i.e. css, xsl. Will sure be happy if I could lay my hands on such tutorials. Thanks for the wonderful job.

Hi,

Just a question why is my Reports module not displaying the settings where the pencil is I only see manage add-ons?

Thanks
Nadia

Does the pencil icon appear for other modules using the same container? Do you see the Settings and the Move icons?