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 |
|
taiwoong
Starting Member
3 Posts |
 Posted - 2007-10-31 : 01:56:35
|
| Hello everyeone,I'm very new to this reporting services and am trying to see whether this service can be utilized in our company's sales system.I've searched quite a few documents about Reporting Service tutorials and it only shows how to make very basic reports, using simple query and one dataset.Is there any document or manual that shows how to generate a report using a stored procedure or complex queries with temp tables.If above is not possible, ca I join multiple datasets then?Please help~...Thank you in advance!! |
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2007-10-31 : 09:23:15
|
| You can check out Book On Line on how to create with Stored Procedures.refer to >> stored procedures [Reporting Services]also refer to >> datasets [Reporting Services], creatingYes you can create multiple Datasets and join them together. |
 |
|
|
taiwoong
Starting Member
3 Posts |
Posted - 2007-10-31 : 22:14:18
|
| Hmm I'm not sure whether you meant to check out actual book on online book store or there's online book in Microsoft on how to create with stored procedure.I have already checked out the tutorials that are provided by Microsoft about Reporting Services and no luck to find tutorials about creating with SP. |
|
|
|
taiwoong
Starting Member
3 Posts |
Posted - 2007-11-01 : 01:56:40
|
| Yes. Can use the stored procedure and Yes, can use temp table inside of stored procedure.Thanks!! |
|
|
|
zavhrye
Starting Member
1 Post |
Posted - 2008-07-07 : 04:18:01
|
| i'm getting an error with a stored procedure using temp tables. "There is an error in the query. Implicit conversion from data type sql_variant to datetime is not allowed. Use the CONVERT function to run this query." |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-07 : 04:49:43
|
| As it suggests, you need to use CONVERT() function for type conversion.just use CONVERT(datetime,yourfield) |
|
|
|
|
|
|
SQL2005 Reporting Service - Using Temp tables?