SSRS Report Problem

• Question

• 

  

  0

  Sign in to vote

  I have this expression

  =Fields!Value.Value
  

  The report output is :

  Header Information

  Date:01/01/2020~10/06/2020

  Correspondent group/Correspondent:Correspondent

  A/P Dept:ALL

  Output data:Present data

  Vchr Tax:-999,999,999,999,999~999,999,999,999,999

  Vchr Tax(SC):-9,999,999,999,999.99~9,999,999,999,999.99

  Vchr Amt:-999,999,999,999,999~999,999,999,999,999

  Vchr Amt(SC):-9,999,999,999,999.99~9,999,999,999,999.99

  Post pad:White

  Approval status:All

  Issue status:All

  Issue M. Pay notice:All

  Import flag:Normal input,Import,Linkage

  Status:Unsettled,Settling,Settled

  Journalize:Object,None

  Detail Information

  A/C group/A/C /SubA/C:A/C

  Dr/Cr type:Dr,Cr

  Amt Bfr Tax:-99,999,999,999,999~99,999,999,999,999

  Amount:-99,999,999,999,999~99,999,999,999,999

  Tax:-99,999,999,999,999~99,999,999,999,999

  Amt Bfr Tax(SC):-999,999,999,999.99~999,999,999,999.99

  Amt(SC):-999,999,999,999.99~999,999,999,999.99

  Tax(SC):-999,999,999,999.99~999,999,999,999.99

  UserQty:-9,999,999,999.9999~9,999,999,999.9999

  A/P Information

  UserQty:-9,999,999,999.9999~9,999,999,999.9999

  Sort:Date

  Output detail data

  
  

  What I want to get is only one data and this is the Date:01/01/2020~10/06/2020

  
  

  How?

  • Moved by Xingyu ZhaoMicrosoft contingent staff Wednesday, October 21, 2020 2:15 AM SSRS related

  Tuesday, October 6, 2020 1:37 AM