I have gated error in my .rdl file
The Group expression for the grouping ‘list1_user’ refers to the field ‘user’. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope.
The SortExpression expression for the grouping ‘list1_user’ refers to the field ‘user’. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope.
Provide me solution regarding it...
Here i mention my code..
="1.0"="utf-8"
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition">
<DataSources>
<DataSource Name="mysql_production_asterisk">
<DataSourceReference>mysql_production_asterisk</DataSourceReference>
<rd:DataSourceID>38E14D3B-5A88-4BED-99B5-8C7A1C14412D</rd:DataSourceID>
<rd:SecurityType>None</rd:SecurityType>
</DataSource>
</DataSources>
<DataSets>
<DataSet Name="AgentTimeReport">
<Fields>
<Field Name="USER">
<DataField>user</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="USERNAME">
<DataField>full_name</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="AGENTTIME">
<DataField>agent_time</DataField>
<rd:TypeName>System.Date</rd:TypeName>
</Field>
<Field Name="WAIT">
<DataField>WAIT_SEC</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="TALK">
<DataField>TALK</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="DISPO">
<DataField>DISPO</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="DEAD">
<DataField>DEAD</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="PAUSE">
<DataField>PAUSE</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>mysql_production_asterisk</DataSourceName>
<CommandText>= "call GetAgentDetails('"
+ CDate(Parameters!Date.Value).ToString("yyyy-MM-dd")
+ "','"
+ CDate(Parameters!EndDate.Value).ToString("yyyy-MM-dd")
+ "','"
+ Join(Parameters!campaignId.Value, ",")
+ "','"
+ Join(Parameters!user.Value, ",")
+ "','"
+ Parameters!shift.Value + "')"</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="GetUsers">
<Fields>
<Field Name="user">
<DataField>user</DataField>
<rd:UserDefined>true</rd:UserDefined>
</Field>
<Field Name="user_label">
<DataField>user_label</DataField>
<rd:UserDefined>true</rd:UserDefined>
</Field>
</Fields>
<Query>
<DataSourceName>mysql_production_asterisk</DataSourceName>
<CommandText>= "CALL report_helper_agent_detail_get_users('"
+ CDate(Parameters!Date.Value).ToString("yyyy-MM-dd")
+ "','day_by_halfhour',' "
+ Join(Parameters!campaignId.Value, ",")
+ "',' " + "')"</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="GetCampaignsFromReportProjectID">
<Fields>
<Field Name="campaign_id">
<DataField>campaign_id</DataField>
<rd:UserDefined>true</rd:UserDefined>
</Field>
<Field Name="campaign_name">
<DataField>campaign_name</DataField>
<rd:UserDefined>true</rd:UserDefined>
</Field>
</Fields>
<Query>
<DataSourceName>mysql_production_asterisk</DataSourceName>
<CommandText>="CALL report_helper_get_campaigns_from_report_project_id("
+ Parameters!reportProjectId.Value
+ ")"</CommandText>
<QueryParameters>
<QueryParameter Name="var_report_project_id">
<Value>=Parameters!reportProjectId.Value</Value>
<rd:UserDefined>true</rd:UserDefined>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<Body>
<ReportItems>
<Tablix Name="List1">
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>5in</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>0.92in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Rectangle Name="List1_Contents">
<ReportItems>
<Tablix Name="matrix1">
<TablixCorner>
<TablixCornerRows>
<TablixCornerRow>
<TablixCornerCell>
<CellContents>
<Textbox Name="User">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>USER</Value>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontWeight>Bold</FontWeight>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>USER</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#6e9eca</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCornerCell>
</TablixCornerRow>
</TablixCornerRows>
</TablixCorner>
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>1.71875in</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>0.21in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="AGENTTIME">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!agent_time.Value)</Value>
<Style>
<FontFamily>Tahoma</FontFamily>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>agent_time</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>
<DataElementOutput>Output</DataElementOutput>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember>
<Group Name="matrix1_TimeMetricDisplay">
<GroupExpressions>
<GroupExpression>=Fields!user.Value</GroupExpression>
</GroupExpressions>
</Group>
<SortExpressions>
<SortExpression>
<Value>=IIF(Fields!user.Value.Equals("Summary"), 0,1)</Value>
</SortExpression>
</SortExpressions>
<TablixHeader>
<Size>0.21in</Size>
<CellContents>
<Textbox Name="PAUSE">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!PAUSE.Value</Value>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontWeight>Bold</FontWeight>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>PAUSE</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#6e9eca</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixHeader>
<DataElementOutput>Output</DataElementOutput>
</TablixMember>
</TablixMembers>
</TablixColumnHierarchy>
<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<Group Name="matrix1_full_name">
<GroupExpressions>
<GroupExpression>=Fields!full_name.Value</GroupExpression>
</GroupExpressions>
</Group>
<TablixHeader>
<Size>2.04167in</Size>
<CellContents>
<Textbox Name="USERNAME">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!full_name.Value</Value>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontWeight>Bold</FontWeight>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>USERNAME</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#6e9eca</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixHeader>
<DataElementOutput>Output</DataElementOutput>
</TablixMember>
</TablixMembers>
</TablixRowHierarchy>
<RepeatColumnHeaders>true</RepeatColumnHeaders>
<RepeatRowHeaders>true</RepeatRowHeaders>
<DataSetName>AgentTimeReport</DataSetName>
<Top>0.5in</Top>
<Height>0.42in</Height>
<Width>3.76042in</Width>
<Style />
</Tablix>
<Textbox Name="user">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!user.Value</Value>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>14pt</FontSize>
<Color>SlateGray</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>user</rd:DefaultName>
<Height>0.27in</Height>
<Width>5in</Width>
<ZIndex>1</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Style />
</Rectangle>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember />
</TablixMembers>
</TablixColumnHierarchy>
<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<Group Name="list1_user">
<GroupExpressions>
<GroupExpression>=Fields!user.Value</GroupExpression>
</GroupExpressions>
<PageBreak>
<BreakLocation>Between</BreakLocation>
</PageBreak>
</Group>
<SortExpressions>
<SortExpression>
<Value>=IIF(Fields!user.Value.Equals("Summary"), 0, 1)</Value>
</SortExpression>
<SortExpression>
<Value>=Fields!user.Value</Value>
</SortExpression>
</SortExpressions>
<DataElementOutput>Output</DataElementOutput>
<KeepTogether>true</KeepTogether>
</TablixMember>
</TablixMembers>
</TablixRowHierarchy>
<DataSetName>AgentTimeReport</DataSetName>
<PageBreak>
<BreakLocation>End</BreakLocation>
</PageBreak>
<Top>0.86in</Top>
<Height>0.92in</Height>
<Width>5in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>14pt</FontSize>
<Color>SlateGray</Color>
</Style>
</Tablix>
<Textbox Name="textbox1">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Agent Details</Value>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>20pt</FontSize>
<FontWeight>Bold</FontWeight>
<Color>SteelBlue</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox1</rd:DefaultName>
<Top>0.125in</Top>
<Left>2.16667in</Left>
<Height>0.41208in</Height>
<Width>2.95833in</Width>
<ZIndex>1</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Image Name="Image1">
<Source>Embedded</Source>
<Value>InktelXFrontline</Value>
<Sizing>FitProportional</Sizing>
<Top>0.02084in</Top>
<Left>0.04in</Left>
<Height>0.73833in</Height>
<Width>1.92in</Width>
<ZIndex>2</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Image>
</ReportItems>
<Height>1.78in</Height>
<Style />
</Body>
<ReportParameters>
<ReportParameter Name="reportProjectId">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>17</Value>
</Values>
</DefaultValue>
<Prompt>reportProjectId</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="Date">
<DataType>DateTime</DataType>
<DefaultValue>
<Values>
<Value>=Today()</Value>
</Values>
</DefaultValue>
<Prompt>Start Date: </Prompt>
</ReportParameter>
<ReportParameter Name="EndDate">
<DataType>DateTime</DataType>
<DefaultValue>
<Values>
<Value>=Today()</Value>
</Values>
</DefaultValue>
<Prompt>End Date:</Prompt>
</ReportParameter>
<ReportParameter Name="campaignId">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>Select Campaign(s): </Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>GetCampaignsFromReportProjectID</DataSetName>
<ValueField>campaign_id</ValueField>
<LabelField>campaign_name</LabelField>
</DataSetReference>
</ValidValues>
<MultiValue>true</MultiValue>
<UsedInQuery>True</UsedInQuery>
</ReportParameter>
<ReportParameter Name="user">
<DataType>String</DataType>
<Prompt>Select Users: </Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>GetUsers</DataSetName>
<ValueField>user</ValueField>
<LabelField>user_label</LabelField>
</DataSetReference>
</ValidValues>
<MultiValue>true</MultiValue>
<UsedInQuery>False</UsedInQuery>
</ReportParameter>
<ReportParameter Name="shift">
<DataType>String</DataType>
<Prompt>Shift:</Prompt>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>All</Value>
</ParameterValue>
<ParameterValue>
<Value>AM</Value>
</ParameterValue>
<ParameterValue>
<Value>PM</Value>
</ParameterValue>
</ParameterValues>
</ValidValues>
<MultiValue>false</MultiValue>
<UsedInQuery>False</UsedInQuery>
</ReportParameter>
</ReportParameters>
<Width>5.125in</Width>
<Page>
<LeftMargin>1in</LeftMargin>
<RightMargin>1in</RightMargin>
<TopMargin>1in</TopMargin>
<BottomMargin>1in</BottomMargin>
<Style />
</Page>
<Language>en-US</Language>
<ConsumeContainerWhitespace>true</ConsumeContainerWhitespace>
<rd:ReportID>4529ca7b-9459-48c5-aa3e-fc8c04eb8528</rd:ReportID>
<rd:ReportUnitType>Inch</rd:ReportUnitType>
</Report>
Thanks
Renish