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 |
|
SoftFox
Starting Member
42 Posts |
 Posted - 2011-02-24 : 11:24:59
|
| I have very strange behaviour on a particular report whereby upon refreshing the report, occasionlly the data is not displayed in the report, even thought the stored procedure is correctly displaying the data!Upon another refresh, the data is usually then displayed again correctly!! The stored procedure always returns the correct data. The report always executes the stored procedure correctly upon refreshing (as can be seen in the profiler). The data is definetly not changing in the database!!Please help someone! Is this a bug that is fixed in SP4? |
|
|
theboyholty
Posting Yak Master
226 Posts |
Posted - 2011-02-25 : 06:41:00
|
| I've had something like this and I found that it was to do with the date formats. First time I ran the report, the date format was in correct UK format DD/MM/YY but then when refreshed, it was switching to US format MM/DD/YY. Although this was a problem in visual studio, it didn't do it when deployed to the report server.I didn't find a solution because I left that job before I got to the bottom of it, but It could have been to do with the set-up of the PC, or the installation of Visual Studio, or maybe something else. It was annoying and at first very confusing but in the end I just put it down to Visual Studio being female. Of this I am convinced.---------------------------------------------------------------------------------http://www.mannyroadend.co.uk The official unofficial website of Bury Football Club |
 |
|
|
SoftFox
Starting Member
42 Posts |
Posted - 2011-03-02 : 05:21:58
|
| Thanks for the suggestion but unfortunatly in this case its not the parameters. Even if I take out the parameters from the SP the problem still happens. After more investigation, it looks as though if the report has more than one dataset then it doesn't work properly. Each dataset I remove, from 4 to 1 , the refresh bug happens less ofen until it doesnt happen at all with one dataset. This is starting to look like a bug in reporting services which is what one person is claiming is a known issue on another forum, however the msdn links that he points to do not exist.If anyone knows anything about this or has any other ideas please let me know!! |
|
|
|
SoftFox
Starting Member
42 Posts |
Posted - 2011-03-03 : 10:50:12
|
| Conclusion:After much searching and hair pulling it looks as though this is a bug in RS 2005. I've only been able to find one reference to the problem on another forum which claims it is a known issue regarding multiple datasets and paging, but the links it provides to MSDN pages do not exist anymore. If anyone know differently would be useful to know, but that is the only conclusion I can come to. Have had to spend best part of a week recreating a complex report that previously used multiple datasets, and the problem does not now occur. Also clicking on refresh you can now see the report taking the time to refresh properly , before it seemed to just flicker and not really do anything randomly return a load of empty values.Bottom line: DO NOT USE MULTIPLE DATASETS FOR REPORT IN RS2005 EVEN THOUGH IT MAY INTIALLY WORK OK. |
|
|
|
|
|
|
|
|
Reporting Services intermittent blank data issue!!