Wednesday, March 13, 2013

XML code for Grouping in SSRS Reports

<?xml version="1.0" encoding="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="global">
      <ConnectionProperties>
        <DataProvider>System.Data.DataSet</DataProvider>
        <ConnectString>/* Local Connection */</ConnectString>
      </ConnectionProperties>
      <rd:DataSourceID>760a313d-7bf2-4ccc-a32e-ad6c4d5b93c1</rd:DataSourceID>
    </DataSource>
  </DataSources>
  <DataSets>
    <DataSet Name="DataSet">
      <Fields>
        <Field Name="locName">
          <DataField>locName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="locCode">
          <DataField>locCode</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="asrProjectText">
          <DataField>asrProjectText</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="asrReuseCondText">
          <DataField>asrReuseCondText</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="ADM_DEPT_MST">
          <DataField>ADM_DEPT_MST</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="ADM_DEPT_MSTReference">
          <DataField>ADM_DEPT_MSTReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AdmLocationMst">
          <DataField>AdmLocationMst</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AdmLocationMstReference">
          <DataField>AdmLocationMstReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsmMntCostDtls">
          <DataField>AsmMntCostDtls</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsmMntDues">
          <DataField>AsmMntDues</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsmMntInwardMpgs">
          <DataField>AsmMntInwardMpgs</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsmMntInwardTrxes">
          <DataField>AsmMntInwardTrxes</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsmMntOutwardMpgs">
          <DataField>AsmMntOutwardMpgs</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsmMntOutwardTrxes">
          <DataField>AsmMntOutwardTrxes</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsmMntScheduleDtls">
          <DataField>AsmMntScheduleDtls</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsmMntTrxes">
          <DataField>AsmMntTrxes</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsoIncidentMpgs">
          <DataField>AsoIncidentMpgs</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsoIncidentMpgs1">
          <DataField>AsoIncidentMpgs1</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsoIncidentTrxes">
          <DataField>AsoIncidentTrxes</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsoTrfInwardNoteMpgs">
          <DataField>AsoTrfInwardNoteMpgs</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsoTrfInwardNoteMpgs1">
          <DataField>AsoTrfInwardNoteMpgs1</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsoTrfScheduleAssetMpgs">
          <DataField>AsoTrfScheduleAssetMpgs</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsoTrfScheduleAssetMpgs1">
          <DataField>AsoTrfScheduleAssetMpgs1</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsoTrfScheduleHdrs">
          <DataField>AsoTrfScheduleHdrs</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetActivityHdrs">
          <DataField>AsrAssetActivityHdrs</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetActivityResourceDtls">
          <DataField>AsrAssetActivityResourceDtls</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetAssociationDtls">
          <DataField>AsrAssetAssociationDtls</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetClassMst">
          <DataField>AsrAssetClassMst</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetClassMstReference">
          <DataField>AsrAssetClassMstReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetKbDtls">
          <DataField>AsrAssetKbDtls</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetMiscInfs">
          <DataField>AsrAssetMiscInfs</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetMntHdrs">
          <DataField>AsrAssetMntHdrs</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetMntResourceDtls">
          <DataField>AsrAssetMntResourceDtls</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetMsts">
          <DataField>AsrAssetMsts</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetSovDtls">
          <DataField>AsrAssetSovDtls</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetStatutoryDtls">
          <DataField>AsrAssetStatutoryDtls</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetTypeMst">
          <DataField>AsrAssetTypeMst</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetTypeMstReference">
          <DataField>AsrAssetTypeMstReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetWarrantyDtls">
          <DataField>AsrAssetWarrantyDtls</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AssAsnActivityAssetDtls">
          <DataField>AssAsnActivityAssetDtls</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AssAsnActivityAssetMpgs">
          <DataField>AssAsnActivityAssetMpgs</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AssDslDutySlipAssetMpgs">
          <DataField>AssDslDutySlipAssetMpgs</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AssDslDutySlipAssetMpgs1">
          <DataField>AssDslDutySlipAssetMpgs1</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AssDslDutySlipTrxes">
          <DataField>AssDslDutySlipTrxes</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AssSchActivityAssetDtls">
          <DataField>AssSchActivityAssetDtls</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AssSchActivityAssetMpgs">
          <DataField>AssSchActivityAssetMpgs</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="CustodyEmpEmployeeMst">
          <DataField>CustodyEmpEmployeeMst</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="CustodyEmpEmployeeMstReference">
          <DataField>CustodyEmpEmployeeMstReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="DealerVndVendorMst">
          <DataField>DealerVndVendorMst</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="DealerVndVendorMstReference">
          <DataField>DealerVndVendorMstReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="MakeVndVendorMst">
          <DataField>MakeVndVendorMst</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="MakeVndVendorMstReference">
          <DataField>MakeVndVendorMstReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="OwnerEmpEmployeeMst">
          <DataField>OwnerEmpEmployeeMst</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="OwnerEmpEmployeeMstReference">
          <DataField>OwnerEmpEmployeeMstReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="ParentAsrAssetAssociationDtls">
          <DataField>ParentAsrAssetAssociationDtls</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="ParentAsrAssetMst">
          <DataField>ParentAsrAssetMst</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="ParentAsrAssetMstReference">
          <DataField>ParentAsrAssetMstReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="PrjProjectInf">
          <DataField>PrjProjectInf</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="PrjProjectInfReference">
          <DataField>PrjProjectInfReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="VndVendorModelDtl">
          <DataField>VndVendorModelDtl</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="VndVendorModelDtlReference">
          <DataField>VndVendorModelDtlReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="XacConReuse">
          <DataField>XacConReuse</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="XacConReuseReference">
          <DataField>XacConReuseReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="XacCtgAsset">
          <DataField>XacCtgAsset</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="XacCtgAssetReference">
          <DataField>XacCtgAssetReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="XacSttMaintenance">
          <DataField>XacSttMaintenance</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="XacSttMaintenanceReference">
          <DataField>XacSttMaintenanceReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="asrActive">
          <DataField>asrActive</DataField>
          <rd:TypeName>System.Byte</rd:TypeName>
        </Field>
        <Field Name="asrBizUnit">
          <DataField>asrBizUnit</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int16, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrCategory">
          <DataField>asrCategory</DataField>
          <rd:TypeName>System.Int16</rd:TypeName>
        </Field>
        <Field Name="asrClass">
          <DataField>asrClass</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int16, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrCode">
          <DataField>asrCode</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="asrCrtdBy">
          <DataField>asrCrtdBy</DataField>
          <rd:TypeName>System.Int16</rd:TypeName>
        </Field>
        <Field Name="asrCrtdOn">
          <DataField>asrCrtdOn</DataField>
          <rd:TypeName>System.DateTime</rd:TypeName>
        </Field>
        <Field Name="asrCustody">
          <DataField>asrCustody</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrDFld1">
          <DataField>asrDFld1</DataField>
          <rd:TypeName>System.Nullable`1[[System.DateTime, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrDealer">
          <DataField>asrDealer</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrDept">
          <DataField>asrDept</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrDesc">
          <DataField>asrDesc</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="asrImage">
          <DataField>asrImage</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="asrLocation">
          <DataField>asrLocation</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int16, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrMake">
          <DataField>asrMake</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrMandatory">
          <DataField>asrMandatory</DataField>
          <rd:TypeName>System.Nullable`1[[System.Byte, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrMntCond">
          <DataField>asrMntCond</DataField>
          <rd:TypeName>System.Int16</rd:TypeName>
        </Field>
        <Field Name="asrModBy">
          <DataField>asrModBy</DataField>
          <rd:TypeName>System.Int16</rd:TypeName>
        </Field>
        <Field Name="asrModOn">
          <DataField>asrModOn</DataField>
          <rd:TypeName>System.DateTime</rd:TypeName>
        </Field>
        <Field Name="asrModel">
          <DataField>asrModel</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrNFld1">
          <DataField>asrNFld1</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrNFld2">
          <DataField>asrNFld2</DataField>
          <rd:TypeName>System.Nullable`1[[System.Byte, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrName">
          <DataField>asrName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="asrOwner">
          <DataField>asrOwner</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrPK">
          <DataField>asrPK</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="asrParent">
          <DataField>asrParent</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrPartNo">
          <DataField>asrPartNo</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="asrProject">
          <DataField>asrProject</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrRegnNo">
          <DataField>asrRegnNo</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="asrRemarks">
          <DataField>asrRemarks</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="asrReuseCond">
          <DataField>asrReuseCond</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int16, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrStatus">
          <DataField>asrStatus</DataField>
          <rd:TypeName>System.Nullable`1[[System.Byte, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrTFld1">
          <DataField>asrTFld1</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="asrTFld2">
          <DataField>asrTFld2</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="asrType">
          <DataField>asrType</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int16, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrYear">
          <DataField>asrYear</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int16, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrxFlag">
          <DataField>asrxFlag</DataField>
          <rd:TypeName>System.Nullable`1[[System.Byte, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="EntityKey">
          <DataField>EntityKey</DataField>
          <rd:TypeName>System.Data.EntityKey</rd:TypeName>
        </Field>
        <Field Name="ExtensionData">
          <DataField>ExtensionData</DataField>
          <rd:TypeName>System.Runtime.Serialization.ExtensionDataObject</rd:TypeName>
        </Field>
      </Fields>
      <Query>
        <DataSourceName>global</DataSourceName>
        <CommandText>/* Local Query */</CommandText>
      </Query>
      <rd:DataSetInfo>
        <rd:DataSetName>global</rd:DataSetName>
      </rd:DataSetInfo>
    </DataSet>
  </DataSets>
  <Body>
    <ReportItems>
      <Tablix Name="Tablix2">
        <TablixBody>
          <TablixColumns>
            <TablixColumn>
              <Width>1.25048in</Width>
            </TablixColumn>
            <TablixColumn>
              <Width>2.00049in</Width>
            </TablixColumn>
            <TablixColumn>
              <Width>1.61384in</Width>
            </TablixColumn>
            <TablixColumn>
              <Width>1.67756in</Width>
            </TablixColumn>
            <TablixColumn>
              <Width>1.55258in</Width>
            </TablixColumn>
          </TablixColumns>
          <TablixRows>
            <TablixRow>
              <Height>0.25in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox1">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>Location Name</Value>
                              <Style>
                                <FontFamily>Verdana</FontFamily>
                                <FontWeight>Bold</FontWeight>
                                <Color>#506c92</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox1</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>#c6d3e7</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>#dee3ed</BackgroundColor>
                      </Style>
                    </Textbox>
                    <ColSpan>2</ColSpan>
                  </CellContents>
                </TablixCell>
                <TablixCell />
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox6">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>Location Code</Value>
                              <Style>
                                <FontFamily>Verdana</FontFamily>
                                <FontWeight>Bold</FontWeight>
                                <Color>#506c92</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox6</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>#c6d3e7</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>#dee3ed</BackgroundColor>
                      </Style>
                    </Textbox>
                    <ColSpan>3</ColSpan>
                  </CellContents>
                </TablixCell>
                <TablixCell />
                <TablixCell />
              </TablixCells>
            </TablixRow>
            <TablixRow>
              <Height>0.25in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="LocationMaster">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=Code.HTMLDecode(Fields!locName.Value)</Value>
                              <Style>
                                <FontStyle>Normal</FontStyle>
                                <FontFamily>Verdana</FontFamily>
                                <FontSize>9pt</FontSize>
                                <FontWeight>Normal</FontWeight>
                                <Color>#263d62</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <Style>
                        <Border>
                          <Color>#c6d3e7</Color>
                          <Style>Solid</Style>
                        </Border>
                      </Style>
                    </Textbox>
                    <ColSpan>2</ColSpan>
                    <rd:Selected>true</rd:Selected>
                  </CellContents>
                </TablixCell>
                <TablixCell />
                <TablixCell>
                  <CellContents>
                    <Textbox Name="locationCode">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=Code.HTMLDecode(Fields!locCode.Value)</Value>
                              <Style>
                                <FontStyle>Normal</FontStyle>
                                <FontFamily>Verdana</FontFamily>
                                <FontSize>9pt</FontSize>
                                <FontWeight>Normal</FontWeight>
                                <Color>#263d62</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <Style>
                        <Border>
                          <Color>#c6d3e7</Color>
                          <Style>Solid</Style>
                        </Border>
                      </Style>
                    </Textbox>
                    <ColSpan>3</ColSpan>
                  </CellContents>
                </TablixCell>
                <TablixCell />
                <TablixCell />
              </TablixCells>
            </TablixRow>
            <TablixRow>
              <Height>0.25in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox11">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>Code</Value>
                              <Style>
                                <FontFamily>Verdana</FontFamily>
                                <FontWeight>Bold</FontWeight>
                                <Color>#506c92</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox1</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>#eef3fb</BackgroundColor>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox17">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>Name</Value>
                              <Style>
                                <FontFamily>Verdana</FontFamily>
                                <FontWeight>Bold</FontWeight>
                                <Color>#506c92</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox1</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>#eef3fb</BackgroundColor>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox18">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>Location</Value>
                              <Style>
                                <FontFamily>Verdana</FontFamily>
                                <FontWeight>Bold</FontWeight>
                                <Color>#506c92</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox1</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>#eef3fb</BackgroundColor>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox19">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>Project</Value>
                              <Style>
                                <FontFamily>Verdana</FontFamily>
                                <FontWeight>Bold</FontWeight>
                                <Color>#506c92</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox1</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>#eef3fb</BackgroundColor>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox20">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>Condition</Value>
                              <Style>
                                <FontFamily>Verdana</FontFamily>
                                <FontWeight>Bold</FontWeight>
                                <Color>#506c92</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox1</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>#eef3fb</BackgroundColor>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
              </TablixCells>
            </TablixRow>
            <TablixRow>
              <Height>0.27083in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="asrCode2">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=Code.HTMLDecode(Fields!asrCode.Value)</Value>
                              <Style>
                                <FontStyle>Normal</FontStyle>
                                <FontFamily>Verdana</FontFamily>
                                <FontSize>9pt</FontSize>
                                <FontWeight>Normal</FontWeight>
                                <Color>#263d62</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>asrCode</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>#c6d3e7</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>#ffffff</BackgroundColor>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox21">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=Code.HTMLDecode(Fields!asrName.Value)</Value>
                              <Style>
                                <FontStyle>Normal</FontStyle>
                                <FontFamily>Verdana</FontFamily>
                                <FontSize>9pt</FontSize>
                                <FontWeight>Normal</FontWeight>
                                <Color>#263d62</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox4</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>#c6d3e7</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>#ffffff</BackgroundColor>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="AdmLocationMst2">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=Code.HTMLDecode(Fields!locName.Value)</Value>
                              <Style>
                                <FontStyle>Normal</FontStyle>
                                <FontFamily>Verdana</FontFamily>
                                <FontSize>9pt</FontSize>
                                <FontWeight>Normal</FontWeight>
                                <Color>#263d62</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>AdmLocationMst</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>#c6d3e7</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>#ffffff</BackgroundColor>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="PrjProjectInf2">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=IIf(IsNothing(Fields!asrProjectText.Value), "Idle Project",Fields!asrProjectText.Value)</Value>
                              <Style>
                                <FontStyle>Normal</FontStyle>
                                <FontFamily>Verdana</FontFamily>
                                <FontSize>9pt</FontSize>
                                <FontWeight>Normal</FontWeight>
                                <Color>#263d62</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>PrjProjectInf</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>#c6d3e7</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>#ffffff</BackgroundColor>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="XacConReuse2">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=Code.HTMLDecode(Fields!asrReuseCondText.Value)</Value>
                              <Style>
                                <FontStyle>Normal</FontStyle>
                                <FontFamily>Verdana</FontFamily>
                                <FontSize>9pt</FontSize>
                                <FontWeight>Normal</FontWeight>
                                <Color>#263d62</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>XacConReuse</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>#c6d3e7</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>#ffffff</BackgroundColor>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
              </TablixCells>
            </TablixRow>
          </TablixRows>
        </TablixBody>
        <TablixColumnHierarchy>
          <TablixMembers>
            <TablixMember />
            <TablixMember />
            <TablixMember />
            <TablixMember />
            <TablixMember />
          </TablixMembers>
        </TablixColumnHierarchy>
        <TablixRowHierarchy>
          <TablixMembers>
            <TablixMember>
              <KeepWithGroup>After</KeepWithGroup>
            </TablixMember>
            <TablixMember>
              <Group Name="Group2">
                <GroupExpressions>
                  <GroupExpression>=Fields!asrLocation.Value</GroupExpression>
                </GroupExpressions>
              </Group>
              <SortExpressions>
                <SortExpression>
                  <Value>=Fields!asrType.Value</Value>
                </SortExpression>
              </SortExpressions>
              <TablixMembers>
                <TablixMember>
                  <KeepWithGroup>After</KeepWithGroup>
                </TablixMember>
                <TablixMember>
                  <Visibility>
                    <Hidden>true</Hidden>
                    <ToggleItem>LocationMaster</ToggleItem>
                  </Visibility>
                  <KeepWithGroup>After</KeepWithGroup>
                </TablixMember>
                <TablixMember>
                  <Group Name="Details1" />
                  <Visibility>
                    <Hidden>true</Hidden>
                    <ToggleItem>LocationMaster</ToggleItem>
                  </Visibility>
                </TablixMember>
              </TablixMembers>
            </TablixMember>
          </TablixMembers>
        </TablixRowHierarchy>
        <DataSetName>DataSet</DataSetName>
        <Left>0.00001in</Left>
        <Height>1.02083in</Height>
        <Width>8.09495in</Width>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
        </Style>
      </Tablix>
    </ReportItems>
    <Height>1.04167in</Height>
    <Style />
  </Body>
  <ReportParameters>
    <ReportParameter Name="HeaderImage">
      <DataType>String</DataType>
      <Nullable>true</Nullable>
      <AllowBlank>true</AllowBlank>
      <Prompt>ReportParameter1</Prompt>
    </ReportParameter>
    <ReportParameter Name="FromDate">
      <DataType>String</DataType>
      <Nullable>true</Nullable>
      <AllowBlank>true</AllowBlank>
      <Prompt>ReportParameter1</Prompt>
    </ReportParameter>
    <ReportParameter Name="ToDate">
      <DataType>String</DataType>
      <Nullable>true</Nullable>
      <AllowBlank>true</AllowBlank>
      <Prompt>ReportParameter1</Prompt>
    </ReportParameter>
  </ReportParameters>
  <Code>Function HTMLDecode(byVal EncodedString) As String
  Dim DecodedString, i
  DecodedString = EncodedString
  DecodedString = Replace(DecodedString, "&amp;quot;", chr(34) )
  DecodedString = Replace(DecodedString, "&amp;lt;"  , chr(60) )
  DecodedString = Replace(DecodedString, "&amp;gt;"  , chr(62) )
  DecodedString = Replace(DecodedString, "&amp;amp;" , chr(38) )
  DecodedString = Replace(DecodedString, "&amp;nbsp;", chr(32) )
  For i = 1 to 255
    DecodedString = Replace(DecodedString, "&amp;#" &amp; i &amp; ";", chr( i ) )
  Next
  Return DecodedString
End Function</Code>
  <Width>8.09497in</Width>
  <Page>
    <PageHeader>
      <Height>1.157in</Height>
      <PrintOnFirstPage>true</PrintOnFirstPage>
      <PrintOnLastPage>true</PrintOnLastPage>
      <ReportItems>
        <Image Name="Image3">
          <Source>External</Source>
          <Value>=Parameters!HeaderImage.Value</Value>
          <MIMEType>image/png</MIMEType>
          <Left>0.11082in</Left>
          <Height>1.157in</Height>
          <Width>2.597in</Width>
          <Style>
            <Border>
              <Style>None</Style>
            </Border>
          </Style>
        </Image>
        <Textbox Name="Textbox3">
          <CanGrow>true</CanGrow>
          <KeepTogether>true</KeepTogether>
          <Paragraphs>
            <Paragraph>
              <TextRuns>
                <TextRun>
                  <Value>Asset By Locations</Value>
                  <Style>
                    <FontFamily>Times New Roman</FontFamily>
                    <FontSize>18pt</FontSize>
                    <FontWeight>Bold</FontWeight>
                  </Style>
                </TextRun>
              </TextRuns>
              <Style>
                <TextAlign>Center</TextAlign>
              </Style>
            </Paragraph>
          </Paragraphs>
          <rd:DefaultName>Textbox3</rd:DefaultName>
          <Top>0.49517in</Top>
          <Left>2.93207in</Left>
          <Height>0.35416in</Height>
          <Width>3.80208in</Width>
          <ZIndex>1</ZIndex>
          <Style>
            <Border>
              <Style>None</Style>
            </Border>
            <PaddingLeft>2pt</PaddingLeft>
            <PaddingRight>2pt</PaddingRight>
            <PaddingTop>2pt</PaddingTop>
            <PaddingBottom>2pt</PaddingBottom>
          </Style>
        </Textbox>
      </ReportItems>
      <Style>
        <Border>
          <Style>None</Style>
        </Border>
      </Style>
    </PageHeader>
    <PageFooter>
      <Height>0.29167in</Height>
      <PrintOnFirstPage>true</PrintOnFirstPage>
      <PrintOnLastPage>true</PrintOnLastPage>
      <ReportItems>
        <Textbox Name="Textbox2">
          <CanGrow>true</CanGrow>
          <KeepTogether>true</KeepTogether>
          <Paragraphs>
            <Paragraph>
              <TextRuns>
                <TextRun>
                  <Value>Generated Through : Grand Trust</Value>
                  <Style />
                </TextRun>
              </TextRuns>
              <Style>
                <TextAlign>Left</TextAlign>
              </Style>
            </Paragraph>
          </Paragraphs>
          <rd:DefaultName>Textbox1</rd:DefaultName>
          <Top>0.01041in</Top>
          <Height>0.20139in</Height>
          <Width>3.06764in</Width>
          <Style>
            <Border>
              <Style>None</Style>
            </Border>
          </Style>
        </Textbox>
        <Textbox Name="Textbox5">
          <CanGrow>true</CanGrow>
          <KeepTogether>true</KeepTogether>
          <Paragraphs>
            <Paragraph>
              <TextRuns>
                <TextRun>
                  <Value>="Page " + Globals!PageNumber.ToString() + " of " + Globals!TotalPages.ToString()</Value>
                  <Style />
                </TextRun>
              </TextRuns>
              <Style>
                <TextAlign>Right</TextAlign>
              </Style>
            </Paragraph>
          </Paragraphs>
          <rd:DefaultName>Textbox2</rd:DefaultName>
          <Top>0.01041in</Top>
          <Left>6.13542in</Left>
          <Height>0.22917in</Height>
          <Width>1.95955in</Width>
          <ZIndex>1</ZIndex>
          <Style>
            <Border>
              <Style>None</Style>
            </Border>
            <PaddingLeft>2pt</PaddingLeft>
            <PaddingRight>2pt</PaddingRight>
            <PaddingTop>2pt</PaddingTop>
            <PaddingBottom>2pt</PaddingBottom>
          </Style>
        </Textbox>
      </ReportItems>
      <Style>
        <Border>
          <Style>None</Style>
        </Border>
      </Style>
    </PageFooter>
    <LeftMargin>1in</LeftMargin>
    <RightMargin>1in</RightMargin>
    <TopMargin>1in</TopMargin>
    <BottomMargin>1in</BottomMargin>
    <Style />
  </Page>
  <rd:ReportID>c1519f46-fed8-4b94-8026-7a2a2af605de</rd:ReportID>
  <rd:ReportUnitType>Inch</rd:ReportUnitType>
</Report>
- No comments:
Subscribe to: Posts (Atom)

Using Authorization with Swagger in ASP.NET Core

 Create Solution like below LoginModel.cs using System.ComponentModel.DataAnnotations; namespace UsingAuthorizationWithSwagger.Models {     ...