HomeHomeUsing DotNetNuk...Using DotNetNuk...Using Modules a...Using Modules a...DNN 6 Tokens as SQL Parameter in Reports ModuleDNN 6 Tokens as SQL Parameter in Reports Module
Previous
 
Next
New Post
7/30/2011 11:35 AM
 
Is it possible to pass DNN 6 Tokens as @Parameters into a SQL query using the reports module?

If this is possible how would it be done?

Are there any guides or documentation as to the availabe Tokens within DNN 6?


Thanks for any help.
 
New Post
8/1/2011 3:35 AM
 
AFAIK this is not supported by the module.

Cheers from Germany,
Sebastian Leupold (DotNetNuke MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group   European Network of DotNetNuke Professionals

 
New Post
5/21/2012 12:48 PM
 

Anyone know if there is an update to this issue? I am looking to do basically same thing. I'll explain what I need to do and maybe one of you nice people can point me in the right direction. We need customers to be able to log in and run reports about their inventory. The parameter would be the customer number. We can't have customers running reports on other customer's inventory. It would work out perfectly if we could set the customer number in the user profile (as a token I'm assuming)  and have it passed to the SQL query. We have about 300 customers that would need to run reports, so it would be impracticable to create a separate reports page for each user or role.

 

Thanks in advance

-Maxwell Comfort

 
New Post
5/21/2012 9:17 PM
 
unfortunately, this module has not been taken care off during the past years.

Cheers from Germany,
Sebastian Leupold (DotNetNuke MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group   European Network of DotNetNuke Professionals

 
New Post
6/22/2012 11:49 AM
 

Hi

I have a similar requirement.

I have seen a demonstration of passing URL parameters to the Reports module from DNNCreative

The catch is always how to get the parameter in the first place

I am thinking of using DataSprings Dynamic forms and using hidden fields and having just a "submit" button that says "show me my records" this would then launch a page passing the Client ID / Customer ID as a parameter

I'll post my success or failure here :-)

Regards

Dave





 
Previous
 
Next
HomeHomeUsing DotNetNuk...Using DotNetNuk...Using Modules a...Using Modules a...DNN 6 Tokens as SQL Parameter in Reports ModuleDNN 6 Tokens as SQL Parameter in Reports Module


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
Start  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

Sponsors

DotNetNuke Corporation

DotNetNuke (DNN) provides a suite of solutions that make designing, building and managing feature-rich sites and communities fast, easy and cost-effective. The DotNetNuke Platform CMS is the foundation for more than one million websites worldwide. DNN Social, our newest solution, enables businesses to create immersive, interactive communities. Thousands of organizations like True Value Hardware, Bose, Cornell University, Glacier Water, Dannon, Delphi, USAA, NASCAR, Northern Health and the City of Denver have leveraged DNN to deploy highly engaging business- critical websites. Our rapid growth in product sales and deployments resulted in DotNetNuke Corp. being named one of the fastest growing private companies in America by Inc. Magazine in 2011 and 2012.