Using a Sharepoint List to add data to a specific column

• mschaper

  Ten Centuries

  Points: 1120

  More actions

  September 22, 2016 at 9:41 am

  #330478

  I have a SharePoint list for 16 different reason code descriptions for several different languages. The reason codes go from 1 to 16. Each column represents a different reason code. RC1 = Reason Code 1, RC2 = Reason Code 2, etc. The list looks like this:

  Language RC1 RC2 .................. RC16

  EN CUSTOMER SAT CHARGE DAYS .................. OTHER

  FR SATISFACTION CLIENT JOURS FACTURES ................. AUTRES

  ES SATISFACCION CLIENTE DIAS CARGADOS ................ ORTO

  I'd like to use this list as a dataset and then use an expression in one of the report columns to pull the actual description. In the report Description column, if the language is EN and the reason code is 16, the report would show OTHER in the Description column. If the language is FR and the reason code - 2, then the Description column would show JOURS FACTURES.

  We use a SharePoint List to display the Report Headings in different languages based on a user selected prompt. I'm trying to take the query code from that and modify it for this purpose but I'm getting stuck. The code I'm trying to modify is as follows:

  <RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

  <ListName>Reason Code</ListName>

  <ViewFields>

  <FieldRef Name="Title" />

  <FieldRef Name="Language" />

  <FieldRef Name="RC1" />

  <FieldRef Name="RC2" />

  <FieldRef Name="RC3" />

  <FieldRef Name="RC4" />

  <FieldRef Name="RC5" />

  <FieldRef Name="RC6" />

  <FieldRef Name="RC7" />

  <FieldRef Name="RC8" />

  <FieldRef Name="RC9" />

  <FieldRef Name="RC10" />

  <FieldRef Name="RC11" />

  <FieldRef Name="RC12" />

  <FieldRef Name="RC13" />

  <FieldRef Name="RC14" />

  <FieldRef Name="RC15" />

  <FieldRef Name="RC16" />

  <FieldRef Name="LinkTitleNoMenu" />

  <FieldRef Name="LinkTitle" />

  <FieldRef Name="ID" />

  <FieldRef Name="ContentType" />

  <FieldRef Name="Modified" />

  <FieldRef Name="Created" />

  <FieldRef Name="Author" />

  <FieldRef Name="Editor" />

  <FieldRef Name="_UIVersionString" />

  <FieldRef Name="Attachments" />

  <FieldRef Name="Edit" />

  <FieldRef Name="DocIcon" />

  </ViewFields>

  <Query>

  <Where>

  <And>

  <Eq>

  <FieldRef Name="Title" />

  <Value Type="Text">

  #######################################

  <Parameter Name="LANGUAGE" />

  </Value>

  </Eq>

  <Eq>

  <FieldRef Name="FLDTYPE" />

  <Value Type="Text">LONGDESCR</Value>

  #######################################

  </Eq>

  </And>

  </Where>

  </Query>

  </RSSharePointList>

  I don't have a parameter for the language as one of the columns in the report will have EN or FR or ES on every row. I'm guessing I may have to use variables for the FLDTYPE and LONGDESCR as these were from the original list for the headings.

  I appreciate the help. Thanks for taking the time to look at this........