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  |  

AspDotNetStoreFront
  Ads  
Engage Software - Training Partner for DotNetNuke
 


  Sponsors  

Meet Our Sponsors

Red-Gate Software
MaximumASP
SourceGear - Tools for Developers
.: CounterSoft :.
telerik
ExactTarget email software solutions
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Reports Module ...  Creating a report based on current URL or query string?
Previous Previous
 
Next Next
New Post 10/13/2006 12:29 PM
User is offline blog.davestechshop.net
11 posts
blog.davestechshop.net
10th Ranked


Creating a report based on current URL or query string? 

Hi. Is it possible to utilize the current URL as a parameter in the query for the reports module?

For example, if the current URL is this:

/MyPage/tabid/245/EntryID/16/Default.aspx

I would like to utilze 245 and 16, for example, in the query so that the report is contextually relevant to the other information displayed on that page.

If this is possible, how would I do it? Thanks.

 
New Post 10/13/2006 5:48 PM
User is offline Andrew Nurse
366 posts
8th Ranked






Re: Creating a report based on current URL or query string? 
This is not possible in the current version. However, in the next version you would be able to use the TabID in the query as I have implemented a simple parameter system that allows you to use the current PortalId, TabId, ModuleId, and UserId in your queries. There is a plan for a more advanced parameter system in the version after that which would allow you to use the "EntryID" query string field in your example or any arbitrary URL fields, as well as more advanced parameters that let you use other data regarding the current session (User Name, Profile Data, etc.).

Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer

 
New Post 7/29/2008 3:58 PM
User is offline TC
14 posts
10th Ranked


Re: Creating a report based on current URL or query string? 

Is it possible to press in any variable through a querystring at the end of the address for the page that the reports module is on?  Something like http://disabilityvoicespace.org/dnn/DAWNCommentsConnection/tabid/77/Default.aspx?ArticleID=Hello2

I would like to pass the article ID to the SQL statement so only the rows where articleID equals a certain value.

For instance I would like to have the SQL statement be something like this

Select * from DAWNArtCommTable where articleID= articleID

I'm surprised there isn't something like this out there somewhere if this module doesn't have

 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Reports Module ...  Creating a report based on current URL or query string?
 


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.

 


Swanzey Internet Group LLC
DotNetNuke design, development, e-Commerce, hosting, maintenance, and training. Exclusively DotNetNuke.
www.swanzey.com
Lucede Systems Group
Providing a full range of IT services for large and medium sized companies
www.lucede.com
Adaptive InfoSystems, Inc.
We provide custom programming and various levels of support for DotNetNuke and the .Net framework.
www.aisysweb.com

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