Weird behavior, content change in exported file (xls, pdf).

Question

Post reply

Weird behavior, content change in exported file (xls, pdf).

mario17

SSCertifiable

Points: 6078
More actions
April 4, 2016 at 4:02 pm

#312913

Hi, all
I made report that works fine once run in VS (2012), but when I export in into xls then I have different content, all my group name header coded as ReportItem start behave like First(ReportField), so I don't have proper group name on the page header.
My report read file made group by Vendor and made invoice style pages, with page break for each group.
I'm attaching photo that will help to illustrated this phenomenon.
I also will try to post my test rdl which is self contained and can be run on clean setup.
Thanks
M

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

mario17 SSCertifiable Points: 6078 More actions · Answer 1

In next reply I pasted my rdl, sorry if too long, i'm limited in providing link here. Tx

mario17 SSCertifiable Points: 6078 More actions · Answer 2

<?xml version="1.0" encoding="utf-8"?>

<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

<Body>

<ReportItems>

<Tablix Name="Tablix3">

<TablixBody>

<TablixColumns>

<TablixColumn>

<Width>1.53125in</Width>

</TablixColumn>

<TablixColumn>

<Width>2in</Width>

</TablixColumn>

<TablixColumn>

<Width>1in</Width>

</TablixColumn>

</TablixColumns>

<TablixRows>

<TablixRow>

<Height>0.25in</Height>

<TablixCells>

<TablixCell>

<CellContents>

<Textbox Name="Textbox6">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>=Fields!Vendor.Value & ".. Fields!Vendor"</Value>

<Style>

<FontFamily>Tahoma</FontFamily>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<rd:DefaultName>Textbox6</rd:DefaultName>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<BackgroundColor>PaleTurquoise</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="Textbox23">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>=Fields!Vendor.Value</Value>

<Style>

<FontFamily>Tahoma</FontFamily>

<FontWeight>Bold</FontWeight>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<rd:DefaultName>Textbox16</rd:DefaultName>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<BackgroundColor>Khaki</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="Textbox56">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>Fields!Vendor</Value>

<Style>

<FontStyle>Italic</FontStyle>

<FontFamily>Tahoma</FontFamily>

<FontSize>9pt</FontSize>

<FontWeight>Normal</FontWeight>

</Style>

</TextRun>

</TextRuns>

<Style>

<TextAlign>Right</TextAlign>

</Style>

</Paragraph>

</Paragraphs>

<rd:DefaultName>Textbox56</rd:DefaultName>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<BackgroundColor>Khaki</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

</TablixCells>

</TablixRow>

<TablixRow>

<Height>0.25in</Height>

<TablixCells>

<TablixCell>

<CellContents>

<Textbox Name="Textbox7">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value />

<Style>

<FontFamily>Tahoma</FontFamily>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<rd:DefaultName>Textbox7</rd:DefaultName>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<BackgroundColor>PaleTurquoise</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="Textbox13">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>=ReportItems!Vendor.Value</Value>

<Style>

<FontFamily>Tahoma</FontFamily>

<FontWeight>Bold</FontWeight>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<rd:DefaultName>Textbox7</rd:DefaultName>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<BackgroundColor>Khaki</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="Textbox25">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>ReportItem</Value>

<Style>

<FontStyle>Italic</FontStyle>

<FontFamily>Tahoma</FontFamily>

<FontSize>9pt</FontSize>

<FontWeight>Normal</FontWeight>

</Style>

</TextRun>

</TextRuns>

<Style>

<TextAlign>Right</TextAlign>

</Style>

</Paragraph>

</Paragraphs>

<rd:DefaultName>Textbox25</rd:DefaultName>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<BackgroundColor>Khaki</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

</TablixCells>

</TablixRow>

<TablixRow>

<Height>0.375in</Height>

<TablixCells>

<TablixCell>

<CellContents>

<Textbox Name="Textbox8">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>Vendor(Invisible)</Value>

<Style>

<FontFamily>Tahoma</FontFamily>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<rd:DefaultName>Textbox8</rd:DefaultName>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<BackgroundColor>PaleTurquoise</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="Textbox22">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>Code</Value>

<Style>

<FontFamily>Tahoma</FontFamily>

<FontWeight>Bold</FontWeight>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<rd:DefaultName>Textbox22</rd:DefaultName>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<BackgroundColor>Khaki</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="Textbox24">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>Rate</Value>

<Style>

<FontFamily>Tahoma</FontFamily>

<FontWeight>Bold</FontWeight>

</Style>

</TextRun>

</TextRuns>

<Style>

<TextAlign>Right</TextAlign>

</Style>

</Paragraph>

</Paragraphs>

<rd:DefaultName>Textbox24</rd:DefaultName>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<BackgroundColor>Khaki</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

</TablixCells>

</TablixRow>

<TablixRow>

<Height>0.2in</Height>

<TablixCells>

<TablixCell>

<CellContents>

<Textbox Name="Vendor">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>=Fields!Vendor.Value</Value>

<Style>

<FontFamily>Tahoma</FontFamily>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<rd:DefaultName>Vendor</rd:DefaultName>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<BackgroundColor>PaleTurquoise</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="CODE">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>=Fields!CODE.Value</Value>

<Style>

<FontFamily>Tahoma</FontFamily>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<rd:DefaultName>CODE</rd:DefaultName>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<BackgroundColor>Khaki</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="Rate">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>=Fields!Rate.Value</Value>

<Style>

<FontFamily>Tahoma</FontFamily>

</Style>

</TextRun>

</TextRuns>

<Style>

<TextAlign>Right</TextAlign>

</Style>

</Paragraph>

</Paragraphs>

<rd:DefaultName>Rate</rd:DefaultName>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<BackgroundColor>Khaki</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

</TablixCells>

</TablixRow>

<TablixRow>

<Height>0.25in</Height>

<TablixCells>

<TablixCell>

<CellContents>

<Textbox Name="Textbox12">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value />

<Style>

<FontFamily>Tahoma</FontFamily>

<FontWeight>Bold</FontWeight>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<rd:DefaultName>Textbox12</rd:DefaultName>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<BackgroundColor>PaleTurquoise</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="Textbox16">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>Total for </Value>

<Style>

<FontFamily>Tahoma</FontFamily>

<FontWeight>Bold</FontWeight>

</Style>

</TextRun>

<TextRun>

<Value>=Fields!Vendor.Value</Value>

<Style>

<FontFamily>Tahoma</FontFamily>

<FontWeight>Bold</FontWeight>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<rd:DefaultName>Textbox16</rd:DefaultName>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<BackgroundColor>Khaki</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="Textbox17">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>=Count(Fields!Rate.Value)</Value>

<Style>

<FontFamily>Tahoma</FontFamily>

<FontWeight>Bold</FontWeight>

</Style>

</TextRun>

</TextRuns>

<Style>

<TextAlign>Right</TextAlign>

</Style>

</Paragraph>

</Paragraphs>

<rd:DefaultName>Textbox17</rd:DefaultName>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<BackgroundColor>Khaki</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

</TablixCells>

</TablixRow>

<TablixRow>

<Height>0.25in</Height>

<TablixCells>

<TablixCell>

<CellContents>

<Textbox Name="Textbox21">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value />

<Style>

<FontWeight>Bold</FontWeight>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<rd:DefaultName>Textbox21</rd:DefaultName>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="Textbox69">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>Total ALL</Value>

<Style>

<FontFamily>Tahoma</FontFamily>

<FontWeight>Bold</FontWeight>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<rd:DefaultName>Textbox69</rd:DefaultName>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<BackgroundColor>Khaki</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="Textbox85">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>=Count(Fields!Rate.Value)</Value>

<Style>

<FontFamily>Tahoma</FontFamily>

<FontWeight>Bold</FontWeight>

</Style>

</TextRun>

</TextRuns>

<SpaceBefore>3pt</SpaceBefore>

<Style>

<TextAlign>Right</TextAlign>

</Style>

</Paragraph>

</Paragraphs>

<rd:DefaultName>Textbox83</rd:DefaultName>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<BackgroundColor>Khaki</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

</TablixCells>

</TablixRow>

<TablixRow>

<Height>0.25in</Height>

<TablixCells>

<TablixCell>

<CellContents>

<Textbox Name="Textbox14">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value />

<Style>

<FontSize>9pt</FontSize>

<FontWeight>Normal</FontWeight>

<Color>DimGray</Color>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<rd:DefaultName>Textbox14</rd:DefaultName>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="Textbox11">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Label>RunDate_Tacoma10_DimGray</Label>

<Value>TimeStamp</Value>

<Style>

<FontSize>9pt</FontSize>

<FontWeight>Normal</FontWeight>

<Format>g</Format>

<Color>DimGray</Color>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<rd:DefaultName>Textbox11</rd:DefaultName>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<BackgroundColor>Khaki</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

<ColSpan>2</ColSpan>

</CellContents>

</TablixCell>

<TablixCell />

</TablixCells>

</TablixRow>

</TablixRows>

</TablixBody>

<TablixColumnHierarchy>

<TablixMembers>

<TablixMember>

<Visibility>

<Hidden>true</Hidden>

</Visibility>

</TablixMember>

<TablixMember />

</TablixMembers>

</TablixColumnHierarchy>

<TablixRowHierarchy>

<TablixMembers>

<TablixMember>

<TablixHeader>

<Size>2.80208in</Size>

<CellContents>

<Textbox Name="Textbox54">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>BODY: Group Vendor</Value>

<Style>

<FontFamily>Tahoma</FontFamily>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<rd:DefaultName>Textbox54</rd:DefaultName>

<Visibility>

<Hidden>true</Hidden>

</Visibility>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<BackgroundColor>PaleTurquoise</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixHeader>

<FixedData>true</FixedData>

<KeepWithGroup>After</KeepWithGroup>

<RepeatOnNewPage>true</RepeatOnNewPage>

<KeepTogether>true</KeepTogether>

</TablixMember>

<TablixMember>

<TablixHeader>

<Size>2.80208in</Size>

<CellContents>

<Textbox Name="Textbox18">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>BODY: Report Item </Value>

<Style>

<FontFamily>Tahoma</FontFamily>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<rd:DefaultName>Textbox18</rd:DefaultName>

<Visibility>

<Hidden>true</Hidden>

</Visibility>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<BackgroundColor>PaleTurquoise</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixHeader>

<KeepWithGroup>After</KeepWithGroup>

<RepeatOnNewPage>true</RepeatOnNewPage>

</TablixMember>

<TablixMember>

<TablixHeader>

<Size>2.80208in</Size>

<CellContents>

<Textbox Name="Textbox2">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>Vendor Group (Invisible)</Value>

<Style>

<FontFamily>Tahoma</FontFamily>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<rd:DefaultName>Textbox2</rd:DefaultName>

<Visibility>

<Hidden>true</Hidden>

</Visibility>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<BackgroundColor>PaleTurquoise</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixHeader>

<TablixMembers>

<TablixMember />

</TablixMembers>

<KeepWithGroup>After</KeepWithGroup>

<RepeatOnNewPage>true</RepeatOnNewPage>

<KeepTogether>true</KeepTogether>

</TablixMember>

<TablixMember>

<Group Name="VendorGrp">

<GroupExpressions>

<GroupExpression>=Fields!Vendor.Value</GroupExpression>

</GroupExpressions>

<PageBreak>

<BreakLocation>Between</BreakLocation>

</PageBreak>

</Group>

<SortExpressions>

<SortExpression>

<Value>=Fields!Vendor.Value</Value>

</SortExpression>

</SortExpressions>

<TablixHeader>

<Size>2.80208in</Size>

<CellContents>

<Textbox Name="VendorGrp">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>=Fields!Vendor.Value</Value>

<Style>

<FontFamily>Tahoma</FontFamily>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<Visibility>

<Hidden>true</Hidden>

</Visibility>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<BackgroundColor>PaleTurquoise</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixHeader>

<TablixMembers>

<TablixMember>

<Group Name="Details" />

<SortExpressions>

<SortExpression>

<Value>=Fields!Vendor.Value</Value>

</SortExpression>

</SortExpressions>

<TablixMembers>

<TablixMember />

</TablixMembers>

</TablixMember>

<TablixMember>

<KeepWithGroup>Before</KeepWithGroup>

</TablixMember>

</TablixMembers>

</TablixMember>

<TablixMember>

<TablixHeader>

<Size>2.80208in</Size>

<CellContents>

<Textbox Name="Textbox68">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>Total ALL</Value>

<Style>

<FontWeight>Bold</FontWeight>

</Style>

</TextRun>

</TextRuns>

<SpaceBefore>3pt</SpaceBefore>

<Style />

</Paragraph>

</Paragraphs>

<rd:DefaultName>Textbox68</rd:DefaultName>

<Visibility>

<Hidden>true</Hidden>

</Visibility>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixHeader>

<KeepWithGroup>Before</KeepWithGroup>

</TablixMember>

<TablixMember>

<TablixHeader>

<Size>2.80208in</Size>

<CellContents>

<Textbox Name="Textbox10">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value />

<Style />

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<rd:DefaultName>Textbox10</rd:DefaultName>

<Style>

<Border>

<Color>LightGrey</Color>

<Style>Solid</Style>

</Border>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixHeader>

<KeepWithGroup>Before</KeepWithGroup>

</TablixMember>

</TablixMembers>

</TablixRowHierarchy>

<DataSetName>DataSet1</DataSetName>

<Height>1.825in</Height>

<Width>7.33333in</Width>

<Style>

<Border>

<Style>None</Style>

</Border>

</Style>

</Tablix>

</ReportItems>

<Height>2.075in</Height>

<Style />

</Body>

<Width>8.7625in</Width>

<Page>

<PageHeader>

<Height>0.68958in</Height>

<PrintOnFirstPage>true</PrintOnFirstPage>

<PrintOnLastPage>true</PrintOnLastPage>

<ReportItems>

<Rectangle Name="Rectangle1">

<ReportItems>

<Textbox Name="textbox1">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value xml:space="preserve"> </Value>

<Style>

<FontFamily>Tahoma</FontFamily>

<FontSize>14pt</FontSize>

<FontWeight>Bold</FontWeight>

<Color>DimGray</Color>

</Style>

</TextRun>

<TextRun>

<Value>HEADER Test Invoice </Value>

<Style>

<FontFamily>Tahoma</FontFamily>

<FontSize>14pt</FontSize>

<FontWeight>Bold</FontWeight>

<Color>Teal</Color>

</Style>

</TextRun>

<TextRun>

<Value> Page </Value>

<Style>

<FontFamily>Tahoma</FontFamily>

<FontSize>14pt</FontSize>

<FontWeight>Normal</FontWeight>

</Style>

</TextRun>

<TextRun>

<Value>=Globals!PageNumber</Value>

<Style>

<FontFamily>Tahoma</FontFamily>

<FontSize>14pt</FontSize>

<FontWeight>Normal</FontWeight>

</Style>

</TextRun>

</TextRuns>

<SpaceBefore>1pt</SpaceBefore>

<Style>

<TextAlign>Center</TextAlign>

</Style>

</Paragraph>

<Paragraph>

<TextRuns>

<TextRun>

<Value xml:space="preserve"> </Value>

<Style>

<FontSize>9pt</FontSize>

<FontWeight>Normal</FontWeight>

<Format>g</Format>

</Style>

</TextRun>

</TextRuns>

<Style>

<TextAlign>Center</TextAlign>

</Style>

</Paragraph>

<Paragraph>

<TextRuns>

<TextRun>

<Value xml:space="preserve"> </Value>

<Style>

<FontSize>9pt</FontSize>

<FontWeight>Normal</FontWeight>

<Format>g</Format>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<rd:DefaultName>textbox1</rd:DefaultName>

<Height>0.68958in</Height>

<Width>7.33333in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</ReportItems>

<KeepTogether>true</KeepTogether>

<Height>0.68958in</Height>

<Width>8in</Width>

<Visibility>

<Hidden>=Parameters!ExcelFormat.Value=true</Hidden>

</Visibility>

<Style>

<Border>

<Style>None</Style>

</Border>

</Style>

</Rectangle>

</ReportItems>

<Style>

<Border>

<Style>None</Style>

</Border>

</Style>

</PageHeader>

<PageFooter>

<Height>0.01042in</Height>

<PrintOnFirstPage>true</PrintOnFirstPage>

<PrintOnLastPage>true</PrintOnLastPage>

<Style>

<Border>

<Style>None</Style>

</Border>

</Style>

</PageFooter>

<LeftMargin>1in</LeftMargin>

<RightMargin>1in</RightMargin>

<TopMargin>1in</TopMargin>

<BottomMargin>1in</BottomMargin>

<Style />

</Page>

<AutoRefresh>0</AutoRefresh>

<DataSources>

<DataSource Name="ClarHSD">

<DataSourceReference>ClarHSD</DataSourceReference>

<rd:SecurityType>Integrated</rd:SecurityType>

<rd:DataSourceID>e547033a-d3cb-47c7-ac3f-5f2ef7aa3f6f</rd:DataSourceID>

</DataSource>

</DataSources>

<DataSets>

<DataSet Name="PROV_NAMEParam">

<Query>

<DataSourceName>ClarHSD</DataSourceName>

<CommandText>

SELECT '*All' AS USer_id, '*All' AS Name

UNION

SELECT USER_ID, NAME

FROM Clarity.dbo.CLARITY_EMP

WHERE (USER_ID IN ('MKOGAN', 'MFEDDERS', 'JLIEB', 'KNARSINH', 'HMIN'))

</CommandText>

</Query>

<Fields>

<Field Name="USer_id">

<DataField>USer_id</DataField>

<rd:TypeName>System.String</rd:TypeName>

</Field>

<Field Name="Name">

<DataField>Name</DataField>

<rd:TypeName>System.String</rd:TypeName>

</Field>

</Fields>

</DataSet>

<DataSet Name="DataSet1">

<Query>

<DataSourceName>ClarHSD</DataSourceName>

<CommandText>SELECT Vendor, CODE, Rate

FROM (SELECT 'Vendor__1' AS Vendor, '1 Alpha' AS CODE, 111 AS Rate

UNION

SELECT 'Vendor__1' AS Vendor, '1 Bravo' AS CODE, 122 AS Rate

UNION

SELECT 'Vendor__1' AS Vendor, '1 Charlie' AS CODE, 133 AS Rate

UNION

SELECT 'Vendor_02' AS Vendor, '2 Papa' AS CODE, 2000 AS Rate

UNION

SELECT 'Vendor_02' AS Vendor, '2 Wiskey' AS CODE, 2022 AS Rate

UNION

SELECT 'Vendor_333' AS Vendor, '3 Romeo' AS CODE, 3331 AS Rate

UNION

SELECT 'Vendor_333' AS Vendor, '3 Hotel' AS CODE, 3332 AS Rate

UNION

SELECT 'Vendor_333' AS Vendor, '3 Zulu' AS CODE, 3334 AS Rate

UNION

SELECT 'Vendor_333' AS Vendor, '3 Juliett' AS CODE, 3333 AS Rate) AS g</CommandText>

</Query>

<Fields>

<Field Name="Vendor">

<DataField>Vendor</DataField>

<rd:TypeName>System.String</rd:TypeName>

</Field>

<Field Name="CODE">

<DataField>CODE</DataField>

<rd:TypeName>System.String</rd:TypeName>

</Field>

<Field Name="Rate">

<DataField>Rate</DataField>

<rd:TypeName>System.Int32</rd:TypeName>

</Field>

</Fields>

</DataSet>

</DataSets>

<ReportParameters>

<ReportParameter Name="EligDate">

<DataType>DateTime</DataType>

<DefaultValue>

<Values>

<Value>=DateAdd(DateInterval.Day, -0,DateAdd(DateInterval.Day, 1-Weekday(today),Today)) ' last day of prev week</Value>

</Values>

</DefaultValue>

<Prompt>Eligibility Date</Prompt>

</ReportParameter>

<ReportParameter Name="ExcelFormat">

<DataType>Boolean</DataType>

<DefaultValue>

<Values>

<Value>false</Value>

</Values>

</DefaultValue>

<Prompt>Remove Page Header for export to Excel ? </Prompt>

<Hidden>true</Hidden>

<ValidValues>

<ParameterValues>

<ParameterValue>

<Value>true</Value>

<Label>Yes</Label>

</ParameterValue>

<ParameterValue>

<Value>false</Value>

<Label>No</Label>

</ParameterValue>

</ParameterValues>

</ValidValues>

</ReportParameter>

<ReportParameter Name="Wait">

<DataType>String</DataType>

<AllowBlank>true</AllowBlank>

<Prompt>Click on "View Report" to run</Prompt>

</ReportParameter>

</ReportParameters>

<Language>en-US</Language>

<ConsumeContainerWhitespace>true</ConsumeContainerWhitespace>

<rd:ReportUnitType>Inch</rd:ReportUnitType>

<rd:ReportID>b3c5ab10-9fe4-4d15-ae08-da203d00bc77</rd:ReportID>

</Report>

mario17 SSCertifiable Points: 6078 More actions · Answer 3

I played again with this, making brand new xml, making all columns visible and still not avail.

The only my guess that Export utility doesn't like ReportsItem!.

Tx again.

M