Mismatch column name in report viewer and PDF export?

• rlabellana3

  Newbie

  Points: 8

  More actions

  September 7, 2014 at 11:59 pm

  #299153

  I have text box in the header and populated dynamically. If my query result is more than 1 page, when i go to next page, the column value will change but when i export it to PDF or Word, only the column value of the first page will appear.

  Please see image below:

  

  What's wrong here?

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  September 8, 2014 at 12:33 am

  #1743776

  How does such an expression look like?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• rlabellana3

  Newbie

  Points: 8

  More actions

  September 8, 2014 at 1:59 am

  #1743792

  Hi Koen,

  Koen Verbeeck (9/8/2014)

  ---

  How does such an expression look like?

  =ReportItems!STORENOG1.Value

  where STORENOG1 is from my Stored Proc

  STORENOG1 VARCHAR(10) DEFAULT NULL