Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

The best choice for your web site host, email hosting, and domain registration.
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
The best choice for your web site host, email hosting, and domain registration.
 


  Sponsors  

Meet Our Sponsors

FCKeditor Project
Salaro -- Skins and more
OnyakTech
The best choice for your web site host, email hosting, and domain registration.
CrystalTech Web Hosting™
Webhost4life, specialists in DNN hosting
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Reports Module ...  How to pass parameter to the SQL query?
Previous Previous
 
Next Next
New Post 1/29/2008 12:44 AM
User is offline ivanchain
3 posts
10th Ranked


How to pass parameter to the SQL query? 

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 7:26 AM
User is offline Andrew Nurse
353 posts
8th Ranked






Re: How to pass parameter to the SQL query? 

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 Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Reports Module ...  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.
 


EMAS Pro
Strategic Enrollment Management Software for Higher Education Recruitment, Retention and Financial Aid
www.emaspro.com 		Subzero Solutions
Dutch / English DotNetNuke consultancy services. Custom module development in any version. Complete application integration. Small business portal hosting. Your ideas our innovation - Your success our motivation. K.v.k Amsterdam: 34236342
www.subzero-solutions.net 		Hosting for DotNetNuke
SiteGround.com is the best place to host your DotNetNuke website! Expert DotNetNuke support, reliable servers, low price!
www.SiteGround.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP