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 |
|
sherrireid
Yak Posting Veteran
58 Posts |
 Posted - 2010-07-08 : 20:45:17
|
| Hi:I have a stored procedure that I am calling in BIDS. The SP works outside of BIDS perfectly fine. If I try to run it inside of BIDS it does not generate any data. This is the first time I've tried to incorporate an SP into a BIDS report - I've searched google endlessly and haven't come up with anything.When I click on Preview and enter the data parameters for the report and then click on 'View Report', it runs instantaneously and simply returns the column names with no data. If I run it outside of BIDS using the same parameters, it returns data.Any idea?SLReidForum NewbieRenton, WA USA |
|
|
sherrireid
Yak Posting Veteran
58 Posts |
Posted - 2010-07-13 : 15:07:41
|
| Please, please, please does ANYONE have any idea? Have I posted to the wrong forum? Am I in the wrong universe?SLReidForum NewbieRenton, WA USA |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-07-13 : 16:23:45
|
| This kind of issue is generally caused by how the parameters are being passed from the report to the stored procedure. Can you post the parameters of the stored procedure and their defined data types, as well as each parameter in the report and how it is defined?I'm guessing - but if you are passing in dates as strings, those dates are going to be interpreted incorrectly and would cause the procedure to not return any matching rows. |
|
|
|
sherrireid
Yak Posting Veteran
58 Posts |
Posted - 2010-07-14 : 13:42:39
|
quote:
Originally posted by jeffw8713
This kind of issue is generally caused by how the parameters are being passed from the report to the stored procedure. Can you post the parameters of the stored procedure and their defined data types, as well as each parameter in the report and how it is defined?I'm guessing - but if you are passing in dates as strings, those dates are going to be interpreted incorrectly and would cause the procedure to not return any matching rows.
Thank you very much for replying - I really appreciate it. Late yesterday I did resolve the problem - I hadn't had a chance to come back here and post the answer yet.With the help of a co-worker who normally doesn't work with this stuff, I was finally able to resolve the problem. He found this:[url]http://stackoverflow.com/questions/802674/temporary-table-issue-in-reporting-services-2000[/url]Apparently BIDS does not work when a temp table is dropped as it tries to compile the statement prior to generating return values. To get around this, we had to turn off the formatting feature. Again, thank you very much for taking the time to reply.Regards,Sherri ReidSLReidForum NewbieRenton, WA USA |
|
|
|
|
|
|
|
|
Stored Procedure in BIDS