Register | Log In
Store Download Support Blogs Forums Contact
Resources > Forums
HomeHomeDotNetNuke Forg...DotNetNuke Forg...Module ForumsModule ForumsReportsReportsHow to pass parameter to the SQL query?How to pass parameter to the SQL query?
Previous
 
Next
New Post
1/29/2008 1:44 AM
 
User is offline ivanchain

Joined: 1/17/2008
Posts: 8

Hi, firend. Please teach me how to:

Pass parameters to the SQL query of the report module. Could I do this? If I can't, then every user to view the page will see the same report result. That's very strange. In most situation, we need to allow the user to chose what data part to look. For example, If there is a datatable which records the score of game. The user of the page want to see his own score in the game, not all people's score list. How to chose his own score? If it allow to pass parameter to the SQL query, it could be done.

Thanks!

yours,

Ivan
 
New Post
1/29/2008 8:26 AM
 
User is offline Andrew Nurse

Joined: 4/12/2004
Posts: 433

The Module automatically provides four parameters that you can use from the SQL Query.

@UserID - The ID of the user who is viewing the report
@ModuleID - The ID of the Reports Module in which the query is executing
@TabID - The ID of the Page on which the Reports Module is placed
@PortalID - The ID of the Portal on which this Reports Module instance is running

There are already plans for more detailed parameters in the next version of the Reports Module, but for now that's the best we've got.

Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer
 
 Page 1 of 1
Previous
 
Next
HomeHomeDotNetNuke Forg...DotNetNuke Forg...Module ForumsModule ForumsReportsReportsHow to pass parameter to the SQL query?How to pass parameter to the SQL query?


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.
Attend A Webinar
Free Demo Site
Download DotNetNuke Professional Edition Trial
Have Someone Contact Me

Like Us on Facebook Join our Network on LinkedIn Follow DNN Corporate on Twitter Follow DNN on Twitter

Advertisers

DotNetNuke Scoop!

Sponsors

DotNetNuke Corporation

DotNetNuke Corp. is the steward of the DotNetNuke open source project, the most widely adopted Web Content Management Platform for building web sites and web applications on Microsoft .NET. Organizations use DotNetNuke to quickly develop and deploy interactive and dynamic web sites, intranets, extranets and web applications. The DotNetNuke platform is available in a free Community and subscription-based Professional and Enterprise Editions with an Elite Support option. DotNetNuke Corp. also operates the DotNetNuke Store where users purchase third party apps for the platform.
Copyright © 2002-2012 DotNetNuke Corp. / Terms of Use / Privacy
Hosted by MaximumASP