Problem: Drill downs reset themselves

[mikebp]

Hi,

We're using SQL Reporting Services with SQL Server 2000 in a corporate environment, and have come across a problem where randomly our drill down reports, when we expand the + sign next to a group / header will reset the report as if we had just run it again. For example, I may drill down (expand) let's say two levels then click a third level and the report will "start again" with all the levels collapsed back to the original layout.

We've tried to do some basic problem solving. Here's what we (think we) know:

1) Not limited to any one report
2) It doesn't seem to matter how long a report is "left alone" for, i.e. it could be within 5 seconds of running the report that it resets, or it could be 30 minutes.
3) It's not limited to a particular drill down level.

So, my first question is whether anyone else has come across that problem? My second question is what areas should I look for that may help to diagnose the problem? My initial thoughts are:

- We're hitting a maxiumum number of concurrent users
- The session ID is becoming scrambled or expires very quickly
- There is a locking issue with the dataset driving the reports

Any suggestions (or solutions even) would be greatly appreciated.

Thanks,

MBP

 

[Catadmin]

Verify this is consistantly happening on your third level drill down. If it is, then the problem is in your Toggle property of that particular item. The Toggle is probably set to one of the higher items instead of the item right beside it. OR the visibility expression in the table properties might be set to something funny.





Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[mikebp]

Hi Catadmin,

Thanks for the reply, however please see above, item 3. I.e. no, not limited to a particular level. However, I will look at the visibility expression you mentioned.

Thanks,

MikeBP

 

[Catadmin]

Did you ever resolve this? If so, how?

It definately sounds like the report is re-rendering itself. Why? I'm not sure. Have you checked with Microsoft on this issue?



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???