ssrs reports using rectangles

• dianerstein 8713

  SSCrazy

  Points: 2197

  More actions

  December 11, 2016 at 8:42 pm

  #332672

  My task is to have up to 5 'letters' appear on separate page where data is obtained from 1 varchar(max) column in a sql server 2012 database field. I am looking for your suggestion and/or potentially how to setup my suggestion in an ssrs 2008 report.

  I am thinking of having 5 separate rectangles and embedding those 5 rectangles into one overall rectangle.

  I am going to setup these rectangles so page breaks will occur between each letter that is stored in a rectangle.

  Each rectangle will know which letter of 5 letters  it to use. Each letter is represented by '<p>par1</p>' I am using this has a placeholder fora letter that is sent to a customer. I am trying to simplify what I am planning to do. The <div id=letter1 /> tag following each letter would be the unique tag each rectangle would look for

  All the data is stored in a varchar(max) field in a column called stringLetter

  The following is a simplified version of what the data would look like:

  <p>par1</p>

  <div id=letter1 />

  <p>par2</p>

  <div id=letter2 />

  <p>par3</p>

  <div id=letter3 />

  <p>par4</p>

  <div id=letter4 />

  <p>par5</p>

  <div id=letter5 />

  in the stringLetter field.

  Thus I have the following questions:

  1. How would each rectangle how to look for the <div id=letter1 /> tag?

  2. For each rectangle to pick only the parts of the field that it needs, would I use the filter option on a rectangle?

  3. Would you show me examples on how to accomplish this goal?