Register | Log In
Download Contact
Resources > Forums
HomeHomeDotNetNuke Forg...DotNetNuke Forg...Module ForumsModule ForumsReportsReportsReport Module Parameter inputReport Module Parameter input
Previous
 
Next
New Post
5/11/2011 9:14 AM
 
User is offline Marcus Farrugia

Joined: 7/16/2008
Posts: 40
Hi, I am trying to add a parameter to the a report using the report module.  My query example is simple.
Select * from Customers where CustomerID = @url_CustomerID
However I am receiving the following error message:
There was an error executing the data source: There is an error in your SQL at line 7: Must declare the scalar variable "@url_CustomerID".
I am unclear how to implement a parameter into an SQL query.  Do I need to use the Allowed URL Parameters input field?  Can you give me an example using my query on how I can implement this?  Thank you
 
New Post
9/12/2011 11:36 PM
 
User is offline Chris Hammond


Chris Hammond's Avatar

www.chrishammond.com
Joined: 1/14/2003
Posts: 6656
I realize this is an old thread, but to fix this you should do the following.

Add CustomerID in your module settings.
Pass in CustomerID in the query string for the URL.

The SQL query should be

where CustomerID = @url_CustomerID
Chris Hammond
dnnCHAT.com a chat room for DotNetNuke discussions
Christoc.com Software Solutions DotNetNuke Module Development, Upgrades and consulting.
 
New Post
11/12/2011 12:18 AM
 
User is offline Victoria Chan


Joined: 11/11/2011
Posts: 2
hi .sir
I also have this problem..
First...I write in Allowed Url Parameter text box " @moduleID"
and in Query text box " Where ModuleID=@moduleID"
I get this result " The report query return no result"
But I dont add exactly parameter as @moduleID=442
Where can I add exactly value to my parameter?
 
 Page 1 of 1
Previous
 
Next
HomeHomeDotNetNuke Forg...DotNetNuke Forg...Module ForumsModule ForumsReportsReportsReport Module Parameter inputReport Module Parameter input


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.
Copyright © 2002-2013 DotNetNuke Corp. / Terms of Use / Privacy
Hosted by MaximumASP