so are you manually watching connections and killing them?

where ln.acct_type='ML' AND

(ln.class_code 799)

So for each row you're brining back you need a subreport? If that's the case, can't you put each in a row of a table? Maybe some sample data would...

I would agree...profiler on the 60 records in 10 seconds...that's a ton of time for that small of a dataset.

What are you attempting to do? A data example will help. I'm wondering if you're needing this function instead...this will take a multi-select parameter and parse them out by commas...

=Join(Parameters!projectTypeID.Label,",...

You could make them dynamic...so once you say "No" don't show the sub, set all the subsequent parameters to "N/A"....so the users can just select Run Report instead of selecting...

Has anyone else experienced this??

I am currently experiencing some issues as well. Attached is a view of task manager on the server.

RAM: 3.25GB

CPU: Intel Xeon 5150, 2.66GHz

Windows Server 2006 Std Edition

SQL Server 2005 Std...

Thanks. After playing with the web service, I have decided that SQL will be much easier to grab the information that i need.

Currently I'm parsing the Schedules and then figuring out if my one report is in the schedule...Here's what I have so far.

Private Sub getReportHistory(ByVal ReportName As...

In the format field

#,##0

Here is what I have used.

select c.[Name], r.RoleName, u.UserName

from reportserver.dbo.catalog c

join reportserver.dbo.PolicyUserRole p on c.PolicyId=p.PolicyId

join reportserver.dbo.Roles r on p.RoleId=r.RoleId

join reportserver.dbo.Users u on p.UserId=u.UserId

where name <> '' and c.Type = 2

order...

Excellent! This worked great!

I have also seen the use of a rectangle with a conditionally shown/hidden rectangle within it. This method has worked for me on occassion but is very finicky. Surprisingly, I...

Thanks, I'll check these out!