### I think its a bug ### - Export to excel

Hi:
I have a report with 2 tables in it, both have drillthroughs. I need to
toggle the visibility between the two tables based on the report parameters,
and hence have an expression in the visibility of the tables properties.
1) Loss of data when exported to excel (sublevels not exported)
The problem caused with this is that when I export to excel the
drillthroughs whihc usually get exported as levels in excel are not being
exported. I remove the visibility expression in the table it works fine.
2) When the visibilty function is present even though only one table is
visible in the report, when i export it i see both the tables. This is a
little inconvenient but fine because it was excess data. But definetly 1 is
an issue that needs to be dealt with.
For now I'll just create two separate reports, or have the second table in a
subreport.
ThanksDo you really have toggles in your report or you just conditinally hide
items based on report parameters?
Could you send us the report, please?
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"NI" <NI@.discussions.microsoft.com> wrote in message
news:3DE5068D-E7F9-41A3-8CC1-1405F20B6277@.microsoft.com...
> Hi:
> I have a report with 2 tables in it, both have drillthroughs. I need to
> toggle the visibility between the two tables based on the report
parameters,
> and hence have an expression in the visibility of the tables properties.
> 1) Loss of data when exported to excel (sublevels not exported)
> The problem caused with this is that when I export to excel the
> drillthroughs whihc usually get exported as levels in excel are not being
> exported. I remove the visibility expression in the table it works fine.
> 2) When the visibilty function is present even though only one table is
> visible in the report, when i export it i see both the tables. This is a
> little inconvenient but fine because it was excess data. But definetly 1
is
> an issue that needs to be dealt with.
> For now I'll just create two separate reports, or have the second table in
a
> subreport.
> Thanks
>
>|||Hi Nico:
I conditionally hide the 2 tables, based on a parameter. This puts in this
section of code under
<Table>
<Visibility>
<Hidden>=IIF(Parameters!RP_SELECT.Value=2,false,true)</Hidden>
</Visibility>
</Table>
If I remove that visibility section they export fine to excel. If it remains
the sub levels do not export.
Thanks
PS: Couldnt find an option to attach here, and hence I inlined only a part
of the report. Hope this helps.
--
<Table Name="table1">
<Height>1.19669in</Height>
<ZIndex>2</ZIndex>
<Style>
<BackgroundColor>White</BackgroundColor>
<BorderStyle>
<Top>None</Top>
</BorderStyle>
</Style>
<Header>
<TableRows>
<TableRow>
<Height>0.19669in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox7">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>LightGrey</BackgroundColor>
<BorderWidth>
<Bottom>2pt</Bottom>
<Top>2pt</Top>
</BorderWidth>
<BorderColor>
<Bottom>DarkRed</Bottom>
<Top>Black</Top>
</BorderColor>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>Solid</Top>
</BorderStyle>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>19</ZIndex>
<CanGrow>true</CanGrow>
<Value>PROJECT</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox8">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>LightGrey</BackgroundColor>
<BorderWidth>
<Bottom>2pt</Bottom>
<Top>2pt</Top>
</BorderWidth>
<BorderColor>
<Bottom>DarkRed</Bottom>
<Top>Black</Top>
</BorderColor>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>Solid</Top>
</BorderStyle>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>18</ZIndex>
<CanGrow>true</CanGrow>
<Value>ACTIVITY HOURS</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox10">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>LightGrey</BackgroundColor>
<BorderWidth>
<Bottom>2pt</Bottom>
<Top>2pt</Top>
</BorderWidth>
<BorderColor>
<Bottom>DarkRed</Bottom>
<Top>Black</Top>
</BorderColor>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>Solid</Top>
</BorderStyle>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>17</ZIndex>
<CanGrow>true</CanGrow>
<Value>GROUP</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox12">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>LightGrey</BackgroundColor>
<BorderWidth>
<Bottom>2pt</Bottom>
<Top>2pt</Top>
</BorderWidth>
<BorderColor>
<Bottom>DarkRed</Bottom>
<Top>Black</Top>
</BorderColor>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>Solid</Top>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>900</FontWeight>
</Style>
<ZIndex>16</ZIndex>
<CanGrow>true</CanGrow>
<Value>TOTAL HOURS</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox18">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>LightCyan</BackgroundColor>
<BorderWidth>
<Bottom>2pt</Bottom>
<Top>2pt</Top>
</BorderWidth>
<BorderColor>
<Bottom>DarkRed</Bottom>
<Top>Black</Top>
</BorderColor>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>Solid</Top>
</BorderStyle>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>15</ZIndex>
<CanGrow>true</CanGrow>
<Value>GRANDTOTAL</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox23">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>LightCyan</BackgroundColor>
<BorderWidth>
<Bottom>2pt</Bottom>
<Top>2pt</Top>
</BorderWidth>
<BorderColor>
<Bottom>DarkRed</Bottom>
<Top>Black</Top>
</BorderColor>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>Solid</Top>
</BorderStyle>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>14</ZIndex>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox25">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>LightCyan</BackgroundColor>
<BorderWidth>
<Bottom>2pt</Bottom>
<Top>2pt</Top>
</BorderWidth>
<BorderColor>
<Bottom>DarkRed</Bottom>
<Top>Black</Top>
</BorderColor>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>Solid</Top>
</BorderStyle>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>13</ZIndex>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox26">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<Format>N</Format>
<BackgroundColor>LightCyan</BackgroundColor>
<BorderWidth>
<Bottom>2pt</Bottom>
<Top>2pt</Top>
</BorderWidth>
<BorderColor>
<Bottom>DarkRed</Bottom>
<Top>Black</Top>
</BorderColor>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>Solid</Top>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>900</FontWeight>
</Style>
<ZIndex>12</ZIndex>
<CanGrow>true</CanGrow>
<Value>= RunningValue(Fields!GroupHours.Value,Sum,
"GetProjectResourceHours")</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
</Header>
<DataSetName>GetProjectResourceHours</DataSetName>
<Top>2.25in</Top>
<TableGroups>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox28">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>=iif(RunningValue(Fields!ProjectName.Value,CountDistinct,Nothing) Mod 2, "Cornsilk", "White")</BackgroundColor>
<FontSize>8pt</FontSize>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>11</ZIndex>
<CanGrow>true</CanGrow>
<Value>= Fields!ProjectName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox29">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>=iif(RunningValue(Fields!ProjectName.Value,CountDistinct,Nothing) Mod 2, "Cornsilk", "White")</BackgroundColor>
<FontSize>8pt</FontSize>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>10</ZIndex>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox30">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>=iif(RunningValue(Fields!ProjectName.Value,CountDistinct,Nothing) Mod 2, "Cornsilk", "White")</BackgroundColor>
<FontSize>8pt</FontSize>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>9</ZIndex>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox31">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<Format>N</Format>
<BackgroundColor>=iif(RunningValue(Fields!ProjectName.Value,CountDistinct,Nothing) Mod 2, "Cornsilk", "White")</BackgroundColor>
<TextAlign>Center</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>8</ZIndex>
<CanGrow>true</CanGrow>
<Value>=SUM( Fields!GroupHours.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Grouping Name="table1_Group1">
<GroupExpressions>
<GroupExpression>=Fields!ProjectName.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</TableGroup>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox32">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>=iif(RunningValue(Fields!ActivityCode.Value,CountDistinct,Nothing) Mod 2, "LavenderBlush", "White")</BackgroundColor>
<BorderStyle>
<Bottom>None</Bottom>
</BorderStyle>
<FontSize>8pt</FontSize>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>7</ZIndex>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox33">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>=iif(RunningValue(Fields!ActivityCode.Value,CountDistinct,Nothing) Mod 2, "LavenderBlush", "White")</BackgroundColor>
<BorderStyle>
<Bottom>None</Bottom>
</BorderStyle>
<FontSize>8pt</FontSize>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>6</ZIndex>
<CanGrow>true</CanGrow>
<Value>= Fields!ActivityCode.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox34">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>=iif(RunningValue(Fields!ActivityCode.Value,CountDistinct,Nothing) Mod 2, "LavenderBlush", "White")</BackgroundColor>
<BorderStyle>
<Bottom>None</Bottom>
</BorderStyle>
<FontSize>8pt</FontSize>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>5</ZIndex>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox35">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<Format>N</Format>
<BackgroundColor>=iif(RunningValue(Fields!ActivityCode.Value,CountDistinct,Nothing) Mod 2, "LavenderBlush", "White")</BackgroundColor>
<BorderStyle>
<Bottom>None</Bottom>
</BorderStyle>
<FontSize>9pt</FontSize>
<TextAlign>Center</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>4</ZIndex>
<CanGrow>true</CanGrow>
<Value>=SUM(Fields!GroupHours.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Grouping Name="table1_Group2">
<GroupExpressions>
<GroupExpression>=Fields!ActivityCode.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Visibility>
<ToggleItem>textbox28</ToggleItem>
<Hidden>true</Hidden>
</Visibility>
</TableGroup>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox36">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>=iif(RunningValue(Fields!GroupName.Value,CountDistinct,Nothing) Mod 2, "LightYellow", "White")</BackgroundColor>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<rd:DefaultName>textbox36</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox37">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>=iif(RunningValue(Fields!GroupName.Value,CountDistinct,Nothing) Mod 2, "LightYellow", "White")</BackgroundColor>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>textbox37</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox38">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>=iif(RunningValue(Fields!GroupName.Value,CountDistinct,Nothing) Mod 2, "LightYellow", "White")</BackgroundColor>
<FontSize>8pt</FontSize>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<rd:DefaultName>textbox38</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>= Fields!GroupName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox39">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<Format>N</Format>
<BackgroundColor>=iif(RunningValue(Fields!GroupName.Value,CountDistinct,Nothing) Mod 2, "LightYellow", "White")</BackgroundColor>
<FontSize>8pt</FontSize>
<TextAlign>Center</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>textbox39</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=(Fields!GroupHours.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Grouping Name="table1_Group4">
<GroupExpressions>
<GroupExpression>=Fields!GroupName.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Visibility>
<ToggleItem>textbox33</ToggleItem>
<Hidden>true</Hidden>
</Visibility>
</TableGroup>
<TableGroup>
<Grouping Name="table1_Group3">
<GroupExpressions>
<GroupExpression>=Fields!ActivityCode.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Visibility>
<ToggleItem>textbox33</ToggleItem>
<Hidden>true</Hidden>
</Visibility>
</TableGroup>
</TableGroups>
<Visibility>
<Hidden>=IIF(Parameters!RP_SELECT.Value=2,false,true)</Hidden>
</Visibility>
<TableColumns>
<TableColumn>
<Width>2.625in</Width>
</TableColumn>
<TableColumn>
<Width>1.875in</Width>
</TableColumn>
<TableColumn>
<Width>2.5in</Width>
</TableColumn>
<TableColumn>
<Width>1.75in</Width>
</TableColumn>
</TableColumns>
</Table>
--
"Nico Cristache [MSFT]" wrote:
> Do you really have toggles in your report or you just conditinally hide
> items based on report parameters?
> Could you send us the report, please?
> --
> Nico Cristache [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "NI" <NI@.discussions.microsoft.com> wrote in message
> news:3DE5068D-E7F9-41A3-8CC1-1405F20B6277@.microsoft.com...
> > Hi:
> >
> > I have a report with 2 tables in it, both have drillthroughs. I need to
> > toggle the visibility between the two tables based on the report
> parameters,
> > and hence have an expression in the visibility of the tables properties.
> >
> > 1) Loss of data when exported to excel (sublevels not exported)
> > The problem caused with this is that when I export to excel the
> > drillthroughs whihc usually get exported as levels in excel are not being
> > exported. I remove the visibility expression in the table it works fine.
> >
> > 2) When the visibilty function is present even though only one table is
> > visible in the report, when i export it i see both the tables. This is a
> > little inconvenient but fine because it was excess data. But definetly 1
> is
> > an issue that needs to be dealt with.
> >
> > For now I'll just create two separate reports, or have the second table in
> a
> > subreport.
> >
> > Thanks
> >
> >
> >
>
>|||Will this be fixed in SP2? I have the same problem with toggeling visibility
on 2 tables and exporting to excel. I have tryed to install the latest SP2
beta but it didn't seem to fix the problem.
"NI" wrote:
> Hi Nico:
> I conditionally hide the 2 tables, based on a parameter. This puts in this
> section of code under
> <Table>
> <Visibility>
> <Hidden>=IIF(Parameters!RP_SELECT.Value=2,false,true)</Hidden>
> </Visibility>
> </Table>
> If I remove that visibility section they export fine to excel. If it remains
> the sub levels do not export.
> Thanks
> PS: Couldnt find an option to attach here, and hence I inlined only a part
> of the report. Hope this helps.
> -- Had to remove the report becouse my post was too long... --
>
> "Nico Cristache [MSFT]" wrote:
> > Do you really have toggles in your report or you just conditinally hide
> > items based on report parameters?
> > Could you send us the report, please?
> >
> > --
> > Nico Cristache [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "NI" <NI@.discussions.microsoft.com> wrote in message
> > news:3DE5068D-E7F9-41A3-8CC1-1405F20B6277@.microsoft.com...
> > > Hi:
> > >
> > > I have a report with 2 tables in it, both have drillthroughs. I need to
> > > toggle the visibility between the two tables based on the report
> > parameters,
> > > and hence have an expression in the visibility of the tables properties.
> > >
> > > 1) Loss of data when exported to excel (sublevels not exported)
> > > The problem caused with this is that when I export to excel the
> > > drillthroughs whihc usually get exported as levels in excel are not being
> > > exported. I remove the visibility expression in the table it works fine.
> > >
> > > 2) When the visibilty function is present even though only one table is
> > > visible in the report, when i export it i see both the tables. This is a
> > > little inconvenient but fine because it was excess data. But definetly 1
> > is
> > > an issue that needs to be dealt with.
> > >
> > > For now I'll just create two separate reports, or have the second table in
> > a
> > > subreport.
> > >
> > > Thanks
> > >
> > >
> > >
> >
> >
> >