different dataset inside table header

Hi, I need to access a secondary dataset inside a table header. I have a List
item defined, and a TextBox inside it. When I try to access a field in the
secondary dataset, it says that field is outside of scope. How can I
accomplish this? If it's any help, here is the RDL:
<TableCell>
<ReportItems>
<List Name="list1">
<Style />
<ZIndex>7</ZIndex>
<DataSetName>TOC_HEADER</DataSetName>
<ReportItems>
<Textbox Name="textbox3">
<Style>
<PaddingLeft>1pt</PaddingLeft>
<FontFamily>Courier New</FontFamily>
<FontSize>=Iif(RowNumber("TOC_HEADER") > 1,
"10pt", "12pt")</FontSize>
<TextAlign>Center</TextAlign>
<PaddingRight>1pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!titleString.Value</Value>
</Textbox>
</ReportItems>
</List>
</ReportItems>
</TableCell>
Thanks in advance,
Peter L.You can only access fields through aggregate functions in other datasets.
E.g. =First(Fields!xyz.Value, "OtherDataSetName")
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"plandry@.newsgroups.nospam"
<plandrynewsgroupsnospam@.discussions.microsoft.com> wrote in message
news:8158CB33-7651-4492-884D-0B98E7F1B590@.microsoft.com...
> Hi, I need to access a secondary dataset inside a table header. I have a
List
> item defined, and a TextBox inside it. When I try to access a field in the
> secondary dataset, it says that field is outside of scope. How can I
> accomplish this? If it's any help, here is the RDL:
> <TableCell>
> <ReportItems>
> <List Name="list1">
> <Style />
> <ZIndex>7</ZIndex>
> <DataSetName>TOC_HEADER</DataSetName>
> <ReportItems>
> <Textbox Name="textbox3">
> <Style>
> <PaddingLeft>1pt</PaddingLeft>
> <FontFamily>Courier New</FontFamily>
> <FontSize>=Iif(RowNumber("TOC_HEADER") > 1,
> "10pt", "12pt")</FontSize>
> <TextAlign>Center</TextAlign>
> <PaddingRight>1pt</PaddingRight>
> <FontWeight>700</FontWeight>
> </Style>
> <CanGrow>true</CanGrow>
> <Value>=Fields!titleString.Value</Value>
> </Textbox>
> </ReportItems>
> </List>
> </ReportItems>
> </TableCell>
> Thanks in advance,
> Peter L.|||> Hi, I need to access a secondary dataset inside a table header.
Wherefore?|||Here's my problem:
I need a multi-line header on every page, that is populated through a
dataset. Since I can't access a dataset from inside the page header (which I
think is a pretty serious shortcoming), I thought maybe I could put a header
on the table that would appear on every page. This header is populated from
its own dataset. I'm open to other ways of accomplishing this -- but
basically I need information from a dataset to appear at the top of every
page.
"Sergey Fedorenko" wrote:
> > Hi, I need to access a secondary dataset inside a table header.
> Wherefore?
>
>|||Try dropping a subreport inside your header. I know it's not elegant, but
it's a way to get around the nested datasets issue.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"plandry@.newsgroups.nospam"
<plandrynewsgroupsnospam@.discussions.microsoft.com> wrote in message
news:24B7CB1C-2F21-46AB-9664-AA95EFAAF46E@.microsoft.com...
> Here's my problem:
> I need a multi-line header on every page, that is populated through a
> dataset. Since I can't access a dataset from inside the page header (which
> I
> think is a pretty serious shortcoming), I thought maybe I could put a
> header
> on the table that would appear on every page. This header is populated
> from
> its own dataset. I'm open to other ways of accomplishing this -- but
> basically I need information from a dataset to appear at the top of every
> page.
> "Sergey Fedorenko" wrote:
>> > Hi, I need to access a secondary dataset inside a table header.
>> Wherefore?
>>