September 7, 2010 at 6:01 pm
I have a Report that was developed in SSRS 2008. It renders inconsistently.
The report has a pivot on two separate columns. One time I run it, and the output is fine and the report renders with data and all of the data checks out. Inconsistently, when I run the report using the EXACT same parameters, the report renders,but no data is displayed, even though I know that data should be displayed on the report.
I put a trace on the SQL Server, caught the query cut it out and ran it in Management Studio and the SQL Server query runs successfully every time.
Additionally, I enabled the NoRowsMessage table property to say "No records match the parameters you selected." When the report renders as if there was no data returned from the SQL Server, even though I know the SQL Server returned data, I don't see the message. When I choose parameters that I know shouldn't return data I see the message.
There is no error message. There is nothing unusual in the logs that I can see.
This inconsistent behavior happens in Visual Studio.Net 2008 SSRS designer, on the QA Server, on the Production Server, in an ASP.net application, and in a Win Forms application. Everyone who has observed the behavior is baffled.
Does anyone have any idea why I am seeing these intermittent results? I have a call in to the Microsoft SSRS team and they seem stumped.
Thank you in advance.
September 8, 2010 at 7:45 am
This is normally just a rendering issue. Could you answer a few of the following questions
1.) Is this a large report?
2.) When you say it is pivoted on 2 points of data you're just using the Tablix control with 2 column groups correct?
3.) What service pack are you on? I am assuming it would be the same acorss all enivronments and that is why you see the same thing.
4.) What OS are you currently running?
Expanding on the rendering piece......2008 sends the data back in chunks instead of waiting till the last bit is received to redner the report.
So the issue you are describing is just a rendering issue and I would be surprised if there was not a hotfix available already to address it.
So it's not anything that you've done
Cheers,
AJ
Arie Jones
http://www.programmersedge.com
http://www.sqlsherpa.com
September 8, 2010 at 8:03 am
Arie Jones-435881 (9/8/2010)
This is normally just a rendering issue. Could you answer a few of the following questions1.) Is this a large report?
2.) When you say it is pivoted on 2 points of data you're just using the Tablix control with 2 column groups correct?
3.) What service pack are you on? I am assuming it would be the same acorss all enivronments and that is why you see the same thing.
4.) What OS are you currently running?
Expanding on the rendering piece......2008 sends the data back in chunks instead of waiting till the last bit is received to redner the report.
So the issue you are describing is just a rendering issue and I would be surprised if there was not a hotfix available already to address it.
So it's not anything that you've done
1.) The report can be large if the proper parameters are chosen. But, I keep the parameters limited so that it only returns 208 records. I have even limited it to return only nine. The Query runs in less than a second.
2.) I am using a Tablix control with 2 column groups.
3.) I am on Service Pack 1. I installed the 9 hot fixes on the development server late last night, and I am in the process of testing the report now.
4.) OS is Windows Server 2008 Enterprise SP1 (Not R2).
Thank you for adding that it's not anything I have done! I needed a boost of confidence because everyone here is acting like I am an idiot!
September 8, 2010 at 8:10 am
Lol! Get used to it ....always the DBAs fault 🙂
Just remember that you also have to install the SP on your desktop/laptop running VS 2008 so you can hopefully correct it there too...
Lemme know if you run into any other issues!
We're here to help!
Cheers,
AJ
Arie Jones
http://www.programmersedge.com
http://www.sqlsherpa.com
September 8, 2010 at 8:16 am
Thanks A.J.
I am a sql developer, not a dba. And, it's the dba who is being the meanest to me, and no help at all. That's not meant to be a slight at dba's - almost every dba I have worked with has been absolutely AMAZING! He's not though.
I will try installing the SP on my machine! Keep your fingers crossed.
Ann
October 6, 2010 at 9:15 pm
Arie Jones-435881 (9/8/2010)
This is normally just a rendering issue. Could you answer a few of the following questions1.) Is this a large report?
2.) When you say it is pivoted on 2 points of data you're just using the Tablix control with 2 column groups correct?
3.) What service pack are you on? I am assuming it would be the same acorns all enivronments and that is why you see the same thing.
4.) What OS are you currently running?
Expanding on the rendering piece......2008 sends the data back in chunks instead of waiting till the last bit is received to redner the report.
So the issue you are describing is just a rendering issue and I would be surprised if there was not a hotfix available already to address it.
So it's not anything that you've done
A.J. Thank you for your response. Installing SP1 for SQL Server 2008 resolved the issue. We did not have to install any of the hot fixes. I really appreciate your help!!! I've been meaning to post back that your suggestion resolved my issue, but have been so busy with work. One of my best developers quit shortly after you helped me resolve this isue and I just haven't had time. I know this is off topic, but it's the reason I haven't followed up to tell you the success of your suggestion, and to mark this issue as resolved. Is there a way to mark the issue as resolved? Nevermind, I'll figure it out.
Thank you for your time and your great advice.
Ann
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply