Thursday, March 11, 2010

Home

Products
       ReportGrid ReportGrid
          Overview Overview
          Walkthrough Walkthrough
          Live Demo Live Demo
             Site Log Site Log
             Master/Detail View Master/Detail View
             User Parameters User Parameters
       ReportChart ReportChart
          Overview Overview
          Walkthrough Walkthrough
          Live Demo Live Demo

Support
       Products Forum Products Forum
       Feedback Center Feedback Center
       Contact Us Contact Us

Gallery
Support   »   Products Forum    
Dnaxp.net Forums
Minimize

Dnaxp.net Forums

The Dnaxp.net Community is proud to present our support forums. The forums enabled us to provide more benefits and better service to our valuable community.
  
Forum
Minimize
 
ForumForumGeneralGeneralBugs & ProblemsBugs & ProblemsMaster detail link not workingMaster detail link not working
Previous Previous
 
Next Next
New Post
 8/3/2007 4:00 PM
 
User is offline msweetnam
No Ranking

Joined: 6/12/2007
Posts: 0

I have this working on a different page, so I know it works.. I just can't get it working here:

Master SQL:

SELECT idReportPrinterThruConsumer_Title      
,[title]
FROM ReportPrinterThruConsumer_Header
where contentOwnerRoleID in (
 SELECT  r.RoleId
 FROM [OneSite2].[dbo].dnn_UserRoles r
  INNER JOIN [OneSite2].[dbo].dnn_Users on r.UserId = [OneSite2].[dbo].[dnn_Users].UserId
  INNER JOIN [OneSite2].[dbo].dnn_Roles on r.RoleId = [OneSite2].[dbo].[dnn_Roles].RoleId
 WHERE  [OneSite2].[dbo].[dnn_Users].UserId = @UserId
  AND    [OneSite2].[dbo].dnn_Roles.PortalId = @PortalId
  AND    (EffectiveDate <= getdate() or EffectiveDate is null)
  AND    (ExpiryDate >= getdate() or ExpiryDate is null))

Detail Grid SQL:

SELECT idReportPrinterThruConsumer_Title
      ,[OriginRoleID]
      ,[ContentOwnerRoleID]
      ,[title]
      ,[version]
      ,[originName]
      ,[originJobNum]
      ,[totalMailed]
      ,[totalCarrierRte]
      ,[inHomeStart]
      ,[inHomeEnd]
  FROM ReportPrinterThruConsumer_Header

But the DETAIL grid doesn't seem to get the linkage.. ie. the where clause that should be created by the grid control to link master and detail.. 

I thought that the grid would make the following where clause on the detail grid..

Where <Master>.idReportPrinterThruConsumer_Title = <Detail>.idReportPrinterThruConsumer_Title

Thoughts or assistance would be greatly appreciated.
New Post
 8/5/2007 3:25 PM
 
User is offline dcorallo
No Ranking

Joined: 11/2/2006
Posts: 0

Hi! Thanks for your question and sorry for the delay in answering.

Both query looks good. Try to check the followings:

1. Check that the Details Grid is set to receive data from the appropriate Master Grid (Advanced Settings > Master Module)
2. Try to trim the query. A known problem is a limit in DNN Parameter value lenght. If the query is too long, then it's cutted at 200 character. Whenever is so, you can also try to wrap it into a stored procedure.

I hope it helps.
Regards,
D.
New Post
 8/8/2007 5:16 PM
 
User is offline msweetnam
No Ranking

Joined: 6/12/2007
Posts: 0

ok.. must have been something like that. Interestingly, it appears that I can set a detail grid to use another detail grid as it's master, for cascading grids..

 
New Post
 8/8/2007 7:08 PM
 
User is offline msweetnam
No Ranking

Joined: 6/12/2007
Posts: 0

So, how do I use a stored procedure in the Detail Grid? I was thinking the detail grid just appends a where clause..
New Post
 8/9/2007 2:59 AM
 
User is offline dcorallo
No Ranking

Joined: 11/2/2006
Posts: 0

Hi! I'm glad you fixed your problem.

About cascading grid, this is a feature not much used but quite powerful. You can for example set a Details module rendered as a GridView and one rendered as a DetailsView.

About how to use a stored procedure, just use the same query as you do in the module. Actually the append of the query clause is done on the recordset and not on the database. The module fetch all the records, put it in the module cache, and filters the cached data. This must be improved but still works quite good for most of the cases.

Kind Regards,
D.
New Post
 1/14/2008 5:53 PM
 
User is offline msweetnam
No Ranking

Joined: 6/12/2007
Posts: 0

Thanks,

So for a detail stored proc, I should create it to return all results (i.e. not take the @MasterID as a parameter) and then let the control filter it by masterID after the return? If so, that's not an option as there are millions of rows in that table...

 

 
New Post
 1/16/2008 11:50 AM
 
User is offline dcorallo
No Ranking

Joined: 11/2/2006
Posts: 0

Hi!

This feature has been changed on users requests to use the @MasterID parameter. Actually the grid itself doesn't do anymore any filtering. The user should do it using it. For this reason you should have a stored procedure which accept the above parameter for making the filter at database level.

As always we're open to suggestion to improve this feature.

Kind Regards,
D.
 Page 1 of 1
Previous Previous
 
Next Next
ForumForumGeneralGeneralBugs & ProblemsBugs & ProblemsMaster detail link not workingMaster detail link not working

  
Forum Policy
Minimize


These Discussion Forums are dedicated to the discussion of the Dnaxp.Net 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 products and non-commercial products which are noectly related to the DotNetNuke Web Application Framework
2. No Flaming or Trolling.
3. No Profanity, Racism, or Prejudice.
4. Site Moderators have the final word on approving/removing a thread or post or comment.

  
 
Minimize

Full compatibility of ReportGrid & ReportChart with all releases of DNN from 4.0.2 to 5.1.4

 

The help desk support is always available to help you! Contact us!

Only $64.95 Offer expires on 12/31/2009

 

  

Snowcovered modules
Minimize

SQL Reporting Services (2.1)

Wed, 10 Mar 2010 16:48:31 -0600

Allows you to interface your portal with Microsoft SQL Server 2000 or 2005 reporting services. You can allow users to select which reports to run or you can specify exactly which report will be shown within the module. This is a great way to bridge the gap between DNN and your report server!

Freeway® Nemo 2.1 Developer Edition

Wed, 10 Mar 2010 16:48:31 -0600

Navigate your data with Freeway Nemo 2.1;: it is an Ajax-based DNN module for a fast developing of enterprise portals. You can integrate it with any dbms, any ERP or legacy system. Is also available a _FREE_ edition !

BackupNative 3.1.0 PRO edition - dotnetnuke backup solution

Wed, 10 Mar 2010 16:48:31 -0600

BackupNative - DNN backup solution - allows you to perform a full dotnetnuke (DNN) site backup: the database (native backup) plus all files and folders on the site (including \portals, \bin, \desktopmodules, web.config file, etc.). With proper rights also allows you to restore database backups.The

Easy Sql Newsletter

Wed, 10 Mar 2010 16:48:31 -0600

---- NEW PRICE, Only 12.99 ----This is a module for Dotnetnuke 4 that allows sending a newsletter, but you can create the distribution list for role.Feature * Two supported language ( ITA - ENG) * Distribution List creation for role o Sql Query with parameter ( Query s

ReportGrid v1.9 w/AJAX

Wed, 10 Mar 2010 16:48:31 -0600

The Report Grid module allow to easily create reports of your data using a simple query or a stored procedure. Supports Master/Details visualization, user parameters, export of data to Excel and XML and much more... (NEW) w/Ajax support for DNN 4.5.5

The DAL+SP Wizard Module 5.1.1

Wed, 10 Mar 2010 16:48:31 -0600

The Data Access Layer and Stored Procedure Wizard is the easiest way to generate code based on your module's database table structure. Watch our YouTube HD video demonstration and see...

SQL Reporting Services (4.1)

Wed, 10 Mar 2010 16:48:31 -0600

Now adding support for SQL Reporting Services 2008! Allows you to interface your portal with Microsoft SQL Server 2000 2005 or 2008 reporting services. This is a great way to bridge the gap between DNN and your report server!

ReportGrid & ReportChart v1.9.9

Wed, 10 Mar 2010 16:48:31 -0600

The Report Grid module and the Report Chart module allow to easily create reports of your data using a simple query or a stored procedure. Easy publishing of master/detail views, bar, pie and line charts. (NEW) Accepts user parameters! (NEW) Accepts QueryString, Form, Cookie and Server Variables!

Open-Events PA + Src

Wed, 10 Mar 2010 16:48:31 -0600

Enhanced Events Module with 'calendar mode', 'scrolling list mode' and separate details view

SQL Deluxe 1.3 Standard Edition

Wed, 10 Mar 2010 16:48:31 -0600

Write interactive reports, run and save SQL scripts, view query results with automatic sorting and paging, and more. Designed for the developer who wants to use SQL to write custom reports without having to create a custom DotNetNuke module.
  
Privacy Statement  |  Terms Of Use
Copyright 2006-2008 by Dnaxp.Net