reports

[imant]

Hi, I am interested in SQL databases, but I am beginner. So I wrote a query , and now I want to write a report to this query. I may do it in Visual Studio on computer that has either Reporting Services installed or on one that has Business Intelligence Studio Installed. So I should add parameters to the query, so users could filter atributs. Some example? Please

[KEMoore]

Try this link
http://msdn.microsoft. com/msdnmag/issues/06/06/DataPoints/default.aspx

[Delerna]

1)You cant parameterise views

2)There are no problems parameterising Stored procedures both input and output

3)You can also have User defined functions that return a table variable
These can also be parameterised and you can think of them as views that can be parameterised.

4) What sort of examples would you like to see. Be specific