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  |  

AppTheory specializes in solutions based on the DotNetNuke platform and has 2 employees on the DotNetNuke Core Team.
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
Iron Speed Designer is a software development tool for building database, reporting, and forms applications for .NET without hand-coding.
 


  Sponsors  

Meet Our Sponsors

eUKhost.com is commited to offer exceptional UK Windows Web Hosting solutions with quality 24x7 technical support.Our plans support ASP.Net, ASP, ASP.NET Ajax extensions, XML, MSSQL, MySQL, PHP,DNN, multiple domains and Shared SSL as standard.
SmarterTools
The Official Microsoft ASP.NET Website
Portal Webhosting - Hosting For Developers
Red-Gate Software
MaximumASP
 


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
344 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.
 


Hosting for DotNetNuke
SiteGround.com is the best place to host your DotNetNuke website! Expert DotNetNuke support, reliable servers, low price!
www.SiteGround.com 		Code Endeavors, LLC
Do you Endeavor to Enhance your DotNetNuke designs by utilizing AJAX technologies to more efficient interactive web experiences
www.codeendeavors.com 		T-WORX, INC.
Professional DotNetNuke Solutions
www.t-worx.com

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