Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
muzzettemm
Posting Yak Master
212 Posts |
Posted - 2008-12-30 : 13:49:27
|
this might be a silly question, but i was wondering why is that you can not pull a function through into the dataset in Report Services? Stored Procedure no problem, function problem. Or perhapns its just me?? |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-30 : 14:08:10
|
you can use functions in report queries just like you use them in normal queries.But you cant simply use function name like yourfunction(param values...) in commandtext. you need to useSELECT fields... FROM dbo.yourfunction(param values...) if its table valued or SELECT dbo.yourfunction(param values...) if scalar valued |
|
|
|
|
|