all groups > sql server reporting services > october 2006 >
You're in the

sql server reporting services

group:

How to tie ? to parameter name?


Re: How to tie ? to parameter name? Bruce L-C [MVP]
10/10/2006 12:24:48 PM
sql server reporting services:
I go against Sybase and have to do this all the time (unfortunately). Go
back to the dataset tab, click on ..., parameters tab. Remap the query
paramters. Keep in mind that although RS creates the report parameters
automatically for you they are not the same thing. This is where they are
mapped.

Another time you will want to do this is if you want to use the same report
parameter multiple times. For instance you have a from and end date that is
used multiple times in your query.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

How to tie ? to parameter name? dgk
10/10/2006 12:40:45 PM
In the Visual Studio (2005) designer, I created a report, data source,
and dataset. The query is essentially Select * from Table1 where
ClientID = ?

Under Report Parameters I changed the name Parameter1 to CIDParam, so
that it is somewhat meaningful when I call it from code. But when I
try to preview the report, Studio complains that the query can't find
Parameter1. So how do I let Studio know that ? should look at
Re: How to tie ? to parameter name? dgk
10/10/2006 2:19:38 PM
On Tue, 10 Oct 2006 12:24:48 -0500, "Bruce L-C [MVP]"
[quoted text, click to view]

AddThis Social Bookmark Button