How do you get rid of parameters?

Hot Topic

Notification Services and Full text search
Can we add tooltip to the Reports available in Report Manager?
Implicit conversions using UDTs
Dumping configuration data into an arbitrary (XML) file.
Poison Message Sample in BOL
Custom Conflict Resolver
View with SELECT * doesn't pickup new columns in table
SQLExpress w/Beta 2 VS -- Can't Create DB
Query Results SSIS Data Flow Source Adapter
Two Digit Year Format - Loading Data

SQL Server

ssis Creating a Basic Package tutorial - not a query
AdventureWorks db for 101 Samples
Intermittent Failure of Interdatabase Service with SP-1 CTP
SQL Server 2005 Standard Installation Problem
SQL Task with Variables
SQL DMO Support in SQL Server 2005...
green-bar for list
Scheduling a legacy DTS package
Layout File for a Fixed-Length Flat File
I cant Install SQL Server 2005 (final release) in the same machine with SQL Server Express Edition (final release)

How do you get rid of parameters?

i write  a sql statements and i was passing parameters but now i do not need parameters so i removed from my sql statements but when i run my report it still asking for the parameters

but i make sure that there is no parameter expecting in my sql statements

any help

Answer this question

How do you get rid of parameters?

  • Aldur

    In report designer in layout mode, click on the report menu -> report parameters and remove the parameters you no longer want.

    Note: there are query parameters (on the dataset properties) and there are report parameters. The mapping between query parameters and report parameters can be modified on the dataset properties dialog.

     

    -- Robert



  • How do you get rid of parameters?
Answer this question