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 |
|
osupratt
Posting Yak Master
238 Posts |
 Posted - 2009-06-16 : 16:05:10
|
| I have a report that has a parameter = YARD. In this main report I have several subreports with same parameter. I have 5 yards. A,B,C,D,and E.In my test environment all subreports and the main report show correctly and all is good. When placing the subreports in Report Manager on Report Server all subreports run fine and all YARDS except for the last one is good. On the last YARD it has data that isn't from subreport showing but where subreports should be it states ERROR: Subreport could not be shown.My question is why would it run fine in my test environment (48-hr old data), but not run fine on Production Data. Why does all the yards show fine except for the one? I'm stumped. The production DBA states that it's probably a problem with my script or .rdl file and I currently have no way of telling or disputing this. Any one with experience of this please help. I've tried to research this, but all other threads say parameters not passing correctly, but mine do. I think anyways. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-17 : 10:08:02
|
| based on my previous experience, i would suggest running the source query for last yard directly in query analyser and see how long it takes. Once one of my fellow developer had a similar issue which troubled us for a week and in the it turned out that reason was badly written source query for subreport which was causing some deadlock issues in db |
 |
|
|
osupratt
Posting Yak Master
238 Posts |
Posted - 2009-06-17 : 22:59:56
|
| it just is odd that this source code works fine when pulling the other yards, but not the last one. |
|
|
|
osupratt
Posting Yak Master
238 Posts |
Posted - 2009-06-17 : 23:25:49
|
| another thing is that when i run this query for the sub-report and just for the yard that isn't showing... it runs fine. the report runs fine in Visual Studio, but not in the Report Manger reporting web site. i don't know if this jars anyone's experiences, but i can't figure this out. does anyone know if microsoft takes calls on these type things? |
|
|
|
|
|
|
Subreport could not be shown