Products

Solutions

Learn More

Partners

Community

Blog

About

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDevelopment and...Development and...Building ExtensionsBuilding ExtensionsModulesModulesStart developing modules for sql reportsStart developing modules for sql reports
Previous
 
Next
New Post
3/9/2017 10:24 PM
 
Hey there.

I've been using DNN reports module for my form and lists tables, but since the reports module is kinda static, I think I will need some module creation for my needs.

I want to be able to pass a var from a dropdown list or text field into the query.

Something like: Dropdown list with cities, select the city, click search, place the selected city in mycityvar and run the query select * from table where city = mycityvar

What is the best way (and simpler) to achieve this?

Best regards,
João
 
New Post
3/10/2017 8:06 AM
 
Joao,

I would use SQL Reporting Services to achieve that goal...

Happy DNNing!
Michael

Michael Tobisch
DNN★MVP
helferlein.com - Michael Tobisch's Site about DNN, SQL Server, ASP.Net and other related stuff dnn-Connect.org - The most vibrant community around the DNN-platform
 
New Post
3/10/2017 9:06 AM
 
Not possible.
I use a shared web hosting service, so no exe install.
 
New Post
3/18/2017 12:39 PM
 
you would need a simple module (e.g. created using Razor host) which contains the filter arguments and passes them using get as QS params when clicking submit to reload the page. in your reports module instance, you may use these QS values as parameters for your query. make sure you provide a proper value (Null or ''), if no param is present.

Cheers from Germany,
Sebastian Leupold (Microsoft MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
3/18/2017 1:16 PM
 
Thanks a lot.

Care to share some example I could follow?
 
Previous
 
Next
HomeHomeDevelopment and...Development and...Building ExtensionsBuilding ExtensionsModulesModulesStart developing modules for sql reportsStart developing modules for sql reports


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, 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 DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
DNN Launch Webinar
REGISTER NOW
DNN Launch Webinar
REGISTER NOW
DNN Launch Webinar
REGISTER NOW