Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 479
  • Last Modified:

Should we use wildcard defaults in SSRS -- What is Best Practice for Parameters

I need clarification...   what is the best practice when creating parameters in SSRS.  My buddy is setting all his parameters with a like statement and defaulting with % -- doing so runs the reports (pulls data) as soon as it is opened.  In my opinion I prefer to have drop down values and require the user to enter values, thus it limits the number of unecessary hits to the database.

What do you all recommend?
0
epicazo
Asked:
epicazo
  • 2
  • 2
1 Solution
 
Daniel ReynoldsSoftware Applications Developer / IntegratorCommented:
If you have one main parameter and then several more, I would use a mixed version of what you show above. A dropdown for the main one and default the wildcard for the others.
this would still keep from hitting the database on open, yet allow for opening the report and not needing to fill in all of the values.
0
 
epicazoAuthor Commented:
Right now, when I open a report I don't have to click on the [VIEW REPORT] because it automatically grabs the data and runs the reports, since everything is wildcard (%).  

If So if I added one parameter to be a drop down this will virtually help my system performance because it wouldn't have to hit the database by just opening the report -- it only hits the database with I click on the [VIEW REPORTS].

Am I correct?
0
 
Daniel ReynoldsSoftware Applications Developer / IntegratorCommented:
without seeing your report, I do believe you are correct.
0
 
epicazoAuthor Commented:
Sorry for the delay -- thanks
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now