Report with Multiple Data sources: Can I do this?

Okay, so I have this ADO.NET dataset defined in my project. I created
an RDLC report and from the menu Report->Data Sources... I chose two
different tables that exist in my ADO dataset. So far so good. At this
point I can drag specific columns into various text boxes I have in my
report (I'm not using tables) and I end up with entries like
"=First(Fields!ContactName.Value)". That's all well and good, but what
I was hoping to do, in addition to that, is something where I can
specify a particular record from one of the tables. Basically what I
have is a table that has two different links to another table. Now
each of those links may be to the same record, or to two different
records. I have a "Job" table and a "Company" table. The Job table has
a link to a "Dealer" and an "Installer" (both of which are records--or
the same record--in the Company table). I was hoping to be able to
display the installer name in one text box and the dealer name in
another. I have two issues: I don't know how to refer to a specific
table when referring to a particular field (both the Job and Company
tables have a "ContactName" column), nor does there appear to be a way
to pick a particular record. I can't seem to be able to do something
like "=Fields!Job.ContactName.Value" when I want to refer to the
ContactName in the Job table as opposed to the Company table. Further,
I can't figure out how to do something like (kinda pseudo code here)
"=Fields!Company.ContactName WHERE Company.ID == First(Fields!
Job.InstallerID.Value)"
So it comes down to this: Can I do anything like what I have described
above? If I can't, my next thought it to create a stored procedure
that gets every value I need and stores it in a custom named field so
I have JobContactName, InstallerContactName, etc to refer to, but then
my next question is can I define a stored procedure that will let me
grab the data I'm looking for from my in-memory ADO.NET Dataset?So I discovered that using subreports would solve my immediate
problem, but I'm still curious if there is a way to do some of what I
describe above, which is: access each different datasource via Fields,
and access specific rows in that source. Right now we can access First/
Last and what ever is chosen as the default when you don't specify
First or Last, but why can't we access a specific record based on the
value of a field in that record? I just want to know if any/all of the
above is possible or not, and if not, what are the patterns people
follow to get around these limitations?
Thanks!

Report request orphaned after 60 seconds?

I am trying to debug a problem where a report times out after 60 seconds; the
report is calling a stored procedure via ADO.Net. The stored procedure is
slow, but acceptable.
Iâ've set the report timeout settings to 300 in all the relevant config files
and the report itself but this had no effect.
The RunningJobs record for this request in the ReportServer database shows
the report having a timeout of 1800.
My questions are:
1. These time values consistently represent the time in seconds, right?
2. I realise orphaned and expired requests are cancelled after 60 seconds by
default, but why does is this request orphaned?
Section of the ReportServer log:
>>
aspnet_wp!library!e88!05/12/2005-12:34:52:: i INFO: Call to RenderFirst(
'/Reports/NumberOneReport' )
aspnet_wp!library!e88!05/12/2005-12:34:52:: i INFO: Initializing
SqlStreamingBufferSize to default value of '65536' Bytes because it was not
specified in Server system properties.
aspnet_wp!runningjobs!834!12/05/2005-12:35:49:: i INFO: Adding: 1 running
jobs to the database
aspnet_wp!runningjobs!834!12/05/2005-12:36:49:: i INFO:
RunningJobContext.IsClientConnected; found orphaned request
aspnet_wp!library!834!12/05/2005-12:36:49:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., Error doing timer action for Running Requests Scavenger;
<<
Any help or suggestions appreciated.Roberto,
FYI: The ADO connection probably has its own Timeout setting. I know SQL
Server itself does. Have you checked these two properties yet? I'm not sure
where the ADO timeout setting is, but I know the SQL Server one is in the
Server Properties window.
Hope that helps.
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"Roberto" wrote:
> I am trying to debug a problem where a report times out after 60 seconds; the
> report is calling a stored procedure via ADO.Net. The stored procedure is
> slow, but acceptable.
> Iâ've set the report timeout settings to 300 in all the relevant config files
> and the report itself but this had no effect.
> The RunningJobs record for this request in the ReportServer database shows
> the report having a timeout of 1800.
> My questions are:
> 1. These time values consistently represent the time in seconds, right?
> 2. I realise orphaned and expired requests are cancelled after 60 seconds by
> default, but why does is this request orphaned?
> Section of the ReportServer log:
> >>
> aspnet_wp!library!e88!05/12/2005-12:34:52:: i INFO: Call to RenderFirst(
> '/Reports/NumberOneReport' )
> aspnet_wp!library!e88!05/12/2005-12:34:52:: i INFO: Initializing
> SqlStreamingBufferSize to default value of '65536' Bytes because it was not
> specified in Server system properties.
> aspnet_wp!runningjobs!834!12/05/2005-12:35:49:: i INFO: Adding: 1 running
> jobs to the database
> aspnet_wp!runningjobs!834!12/05/2005-12:36:49:: i INFO:
> RunningJobContext.IsClientConnected; found orphaned request
> aspnet_wp!library!834!12/05/2005-12:36:49:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for more
> details., Error doing timer action for Running Requests Scavenger;
> <<
> Any help or suggestions appreciated.|||The ADO timeout is set in my component.config to 300 (debugged this and the
call is using this value), the SQL server timeout to 600.
I hadn't thought of the SQL Server timeout so thanks for the post.
Still having the same problem though.
"Catadmin" wrote:
> Roberto,
> FYI: The ADO connection probably has its own Timeout setting. I know SQL
> Server itself does. Have you checked these two properties yet? I'm not sure
> where the ADO timeout setting is, but I know the SQL Server one is in the
> Server Properties window.
> Hope that helps.
> Catadmin
> --
> MCDBA, MCSA
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
> @.=)
>
> "Roberto" wrote:
> > I am trying to debug a problem where a report times out after 60 seconds; the
> > report is calling a stored procedure via ADO.Net. The stored procedure is
> > slow, but acceptable.
> >
> > Iâ've set the report timeout settings to 300 in all the relevant config files
> > and the report itself but this had no effect.
> >
> > The RunningJobs record for this request in the ReportServer database shows
> > the report having a timeout of 1800.
> >
> > My questions are:
> >
> > 1. These time values consistently represent the time in seconds, right?
> >
> > 2. I realise orphaned and expired requests are cancelled after 60 seconds by
> > default, but why does is this request orphaned?
> >
> > Section of the ReportServer log:
> >
> > >>
> >
> > aspnet_wp!library!e88!05/12/2005-12:34:52:: i INFO: Call to RenderFirst(
> > '/Reports/NumberOneReport' )
> >
> > aspnet_wp!library!e88!05/12/2005-12:34:52:: i INFO: Initializing
> > SqlStreamingBufferSize to default value of '65536' Bytes because it was not
> > specified in Server system properties.
> >
> > aspnet_wp!runningjobs!834!12/05/2005-12:35:49:: i INFO: Adding: 1 running
> > jobs to the database
> >
> > aspnet_wp!runningjobs!834!12/05/2005-12:36:49:: i INFO:
> > RunningJobContext.IsClientConnected; found orphaned request
> >
> > aspnet_wp!library!834!12/05/2005-12:36:49:: e ERROR: Throwing
> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > An internal error occurred on the report server. See the error log for more
> > details., Error doing timer action for Running Requests Scavenger;
> > <<
> >
> > Any help or suggestions appreciated.|||Is your report server running on Windows 2003 with IIS 6? Check if
increasing the IIS timeout (120 seconds on IIS6) on the default web site
helps.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Roberto" <Roberto@.discussions.microsoft.com> wrote in message
news:C5C7D412-819E-46AD-86D6-53E782A09368@.microsoft.com...
> The ADO timeout is set in my component.config to 300 (debugged this and
> the
> call is using this value), the SQL server timeout to 600.
> I hadn't thought of the SQL Server timeout so thanks for the post.
> Still having the same problem though.
> "Catadmin" wrote:
>> Roberto,
>> FYI: The ADO connection probably has its own Timeout setting. I know SQL
>> Server itself does. Have you checked these two properties yet? I'm not
>> sure
>> where the ADO timeout setting is, but I know the SQL Server one is in the
>> Server Properties window.
>> Hope that helps.
>> Catadmin
>> --
>> MCDBA, MCSA
>> Random Thoughts: If a person is Microsoft Certified, does that mean that
>> Microsoft pays the bills for the funny white jackets that tie in the
>> back?
>> @.=)
>>
>> "Roberto" wrote:
>> > I am trying to debug a problem where a report times out after 60
>> > seconds; the
>> > report is calling a stored procedure via ADO.Net. The stored procedure
>> > is
>> > slow, but acceptable.
>> >
>> > I've set the report timeout settings to 300 in all the relevant config
>> > files
>> > and the report itself but this had no effect.
>> >
>> > The RunningJobs record for this request in the ReportServer database
>> > shows
>> > the report having a timeout of 1800.
>> >
>> > My questions are:
>> >
>> > 1. These time values consistently represent the time in seconds, right?
>> >
>> > 2. I realise orphaned and expired requests are cancelled after 60
>> > seconds by
>> > default, but why does is this request orphaned?
>> >
>> > Section of the ReportServer log:
>> >
>> > >>
>> >
>> > aspnet_wp!library!e88!05/12/2005-12:34:52:: i INFO: Call to
>> > RenderFirst(
>> > '/Reports/NumberOneReport' )
>> >
>> > aspnet_wp!library!e88!05/12/2005-12:34:52:: i INFO: Initializing
>> > SqlStreamingBufferSize to default value of '65536' Bytes because it was
>> > not
>> > specified in Server system properties.
>> >
>> > aspnet_wp!runningjobs!834!12/05/2005-12:35:49:: i INFO: Adding: 1
>> > running
>> > jobs to the database
>> >
>> > aspnet_wp!runningjobs!834!12/05/2005-12:36:49:: i INFO:
>> > RunningJobContext.IsClientConnected; found orphaned request
>> >
>> > aspnet_wp!library!834!12/05/2005-12:36:49:: e ERROR: Throwing
>> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> > An internal error occurred on the report server. See the error log for
>> > more
>> > details., Error doing timer action for Running Requests Scavenger;
>> > <<
>> >
>> > Any help or suggestions appreciated.|||I'm running locally on XP Pro, IIS 5.1
The IIS connection timeout is set to 900 seconds.
The report is executed via a web service which uses ADO.Net to call a stored
proc. I'll keep working on this and post more information when I get it. Keep
the ideas coming!
"Robert Bruckner [MSFT]" wrote:
> Is your report server running on Windows 2003 with IIS 6? Check if
> increasing the IIS timeout (120 seconds on IIS6) on the default web site
> helps.
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Roberto" <Roberto@.discussions.microsoft.com> wrote in message
> news:C5C7D412-819E-46AD-86D6-53E782A09368@.microsoft.com...|||The report is executed via a web service which uses ADO.Net to call a stored
proc.
Web services have a default timeout of 100 seconds; that was the problem,
not the report server.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemwebservicesprotocolswebclientprotocolclasstimeouttopic.asp
The code to resolve this issue was:
this.Timeout = System.Threading.Timeout.Infinite;
Where â'thisâ' is my web service class, which is inheriting from
System.Web.Services.Protocols.SoapHttpClientProtocol