SSRS 2008 Retrieve Option List/ Dropdown Name By Query

*Note Word with red color

SELECT DP.vw_name AS 'DPRNo',Co.FullName AS 'PersonnelName',
Ves.vw_name AS 'VesselName',PE.vw_Role,PersonnelRole.Value AS 'PersonnelRole',
PE.vw_OnHireDate AS 'OnHire',PE.vw_OffHireDate AS 'OffHire'

FROM vw_personnelEngagementExtensionBase AS PE INNER JOIN
MetadataSchema.Entity AS Entity ON Entity.Name = 'vw_personnelengagement' LEFT OUTER JOIN
stringmap AS PersonnelRole ON
PersonnelRole.AttributeName = 'vw_Role' AND PersonnelRole.AttributeValue = PE.vw_Role AND 
PersonnelRole.ObjectTypeCode = Entity.ObjectTypeCode LEFT OUTER JOIN
vw_vesselExtensionBase AS Ves ON Ves.vw_vesselId =  PE.vw_BargeVesselId LEFT OUTER JOIN
contactBase AS Co ON Co.ContactId = PE.vw_PersonnelNameId LEFT OUTER JOIN
vw_dailyprogressExtensionBase AS DP ON DP.vw_dailyprogressId = PE.vw_DPRNoId

Query that i use to retrieve the dropdown or option list name. Using MetadataSchema.
This work for crm 2011. Reporting to retrieve the name.

Repeat Table Header On Each Page Of The Report

In the SSRS 2008,  table headers won’t repeat on every page by default when you print or export or print preview the report. To configure the repeat table header in this scenario, you can change the xml behind the RDL file.

Search for TablixRowHierarchy for the given Tablix control and look for the section with a TablixMember and KeepWithGroup

        <TablixRowHierarchy>
          <TablixMembers>
            <TablixMember>
              <KeepWithGroup>After</KeepWithGroup>
            </TablixMember>            <TablixMember>
              <Group Name=”Details2″ />
            </TablixMember>
          </TablixMembers>
        </TablixRowHierarchy>

Update the TablixMember with two additional element properties – RepeatOnNewPage and KeepTogether.

        <TablixRowHierarchy>
          <TablixMembers>
            <TablixMember>
              <KeepWithGroup>After</KeepWithGroup>
              <RepeatOnNewPage>true</RepeatOnNewPage>
              <KeepTogether>true</KeepTogether>            </TablixMember>            <TablixMember>
              <Group Name=”Details2″ />
            </TablixMember>
          </TablixMembers>
        </TablixRowHierarchy>

Save the RDL file and repeating header rows should be visible when you print preview, print, or export the report.

Table headers will repeat on every page by default when you print, print preview, or export the report.

Haven Tested yet. Will test soon as i get this information from Google. If possible to work i will upload the step soon.

SSRS 2008

SQL Server Reporting Services 2008 Beginning of SSRS 2008.