You are here:

MS SQL/Integer parameters

Advertisement


Question
Hello sir,

I am developing a report using ssrs and visual studio 2013. I have 2 parameters in the report of type integer. If I set the "allow null value" for each of the parameters and I preview the report, the report is blank. How can I do so that if I don't enter values for the parameters that the report will show the data and disregarding the parameters?

Thank you

Assaf

Answer
Hi Asaaf

You can make sure of parameter default values. Using this approach you can show report based on default parameter and still allow users to change parameter values, if required. If you don't want users to change these parameter then just hide parameters.


Regards
Mohit

MS SQL

All Answers


Answers by Expert:


Ask Experts

Volunteer


Mohit Nayyar

Expertise

Microsoft SQL Server: T-SQL development (stored procedures, triggers, functions), Database optimization, performance tuning, high availability (Clustering, Log Shipping, Mirroring, Replication), scalability, SQL Server migration (Sybase/Oracle to SQL Server), SSIS/DTS, Data Warehousing (Kimball Methodology), ETL (SSIS), Cube (SSAS), Reporting Services (SSRS), database modeling, database administration, Security implementation and typically anything related to Microsoft SQL Server.

Experience

With over 10 years of experience in Database Administration, Development, Business Intelligence solutions and managing enterprise level database solutions based on Microsoft SQL Server.
Publications
IT Magazine: ASP, SQL

Publications
IT Magazine: ASP, SQL
SQLServerCentral.com

Education/Credentials
MCA (Masters)

Awards and Honors
Brainbench Certified: RDBMS
MCTS: DBA/Developer/BI for SQL Server 2005/SQL Server 2008
MCITP: DBA/Developer/BI for SQL Server 2005/SQL Server 2008
MCDBA: SQL Server 2000
MCP: SQL Server 6.5

©2016 About.com. All rights reserved.