The @ symbol for parameters
in [Reports]
|
Prev: Reporting Services will not show URL
Next: error: Detailed members can only contain static inner memmbers.
From: childofthe1980s on 31 Mar 2010 16:14 Hello: Below is an example of a query that I created for a SQL report that I created a long time ago containing five parameters: select * from BPINKTONER where Company IN (@Company, ',') and ItemNumber IN (@ItemNumber, ',') and StockingLocation IN (@StockingLocation, ',') and DocumentDate BETWEEN @Begin_Date and @End_Date I can't remember. Why do you need an apostrope in the first three parameters above? For example, why have (@Company, ',') when you can have(@Company)? childofthe1980s
From: Bruce L-C [MVP] on 31 Mar 2010 17:45 These look like multi-select parameters but you do not need to do it this way. just put in @ItemNumber for example. Also, I bet it is a comma not an apostrophe. -- Bruce Loehle-Conger MVP SQL Server Reporting Services "childofthe1980s" <childofthe1980s(a)discussions.microsoft.com> wrote in message news:D305324D-D793-4328-89EF-9E22D8F1D39B(a)microsoft.com... > Hello: > > Below is an example of a query that I created for a SQL report that I > created a long time ago containing five parameters: > > select * from BPINKTONER > where Company IN (@Company, ',') and > ItemNumber IN (@ItemNumber, ',') and > StockingLocation IN (@StockingLocation, ',') and > DocumentDate BETWEEN @Begin_Date and @End_Date > > I can't remember. Why do you need an apostrope in the first three > parameters above? For example, why have (@Company, ',') when you can > have(@Company)? > > childofthe1980s
From: childofthe1980s on 31 Mar 2010 19:01
You're right--on both counts! Thanks! childofthe1980s "Bruce L-C [MVP]" wrote: > These look like multi-select parameters but you do not need to do it this > way. just put in @ItemNumber for example. Also, I bet it is a comma not an > apostrophe. > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "childofthe1980s" <childofthe1980s(a)discussions.microsoft.com> wrote in > message news:D305324D-D793-4328-89EF-9E22D8F1D39B(a)microsoft.com... > > Hello: > > > > Below is an example of a query that I created for a SQL report that I > > created a long time ago containing five parameters: > > > > select * from BPINKTONER > > where Company IN (@Company, ',') and > > ItemNumber IN (@ItemNumber, ',') and > > StockingLocation IN (@StockingLocation, ',') and > > DocumentDate BETWEEN @Begin_Date and @End_Date > > > > I can't remember. Why do you need an apostrope in the first three > > parameters above? For example, why have (@Company, ',') when you can > > have(@Company)? > > > > childofthe1980s > > . > |