locked
Running Value in Reporting RRS feed

  • Question

  • User-146807150 posted
    Hi EveryBody,
     
    I'm currently doing Report Server concept.
    Now, i have a 3 columns like material_Quantity, Category_Name & Rev.
     
    Upto now what i'm doing is for Rev wise , for same category what are the materila's having and what are the quantity for those material's i'm displaying upto now.
     
    
                           Rev0                                  Rev1
              category1          category2
     qty1    qty2    qty3       qty1  qty2  qty3
    

     
     
    Expression for Quantity Column is
     
    =SUM(Fields!Material_Quantity.Value)

     

    Now, what is question is for Rev0 ,Category1,qty1 is 2.5. and Rev1,category1,qty1 is 1.5. Now i want to display the Running value.
     
    Ex:
     
    In Rev1,Category1,qty1 i want to display 2.5+1.5=4.
     
    How to do this for this i'm using RunningValue concept buti'm not getting the whatever i'm expecting ...
     
    Please help me how to resolve this issue....
    Sunday, February 10, 2013 11:51 PM

All replies

  • User460370150 posted

    For this you have to concatenate strings

    try this out

    Fields!Rev0qty1.Value & "+" & Fields!Rev1qty1.Value & "=" & (Fields!Rev0qty1.Value  + Fields!Rev1qty1.Value )

    If there is further any query ask in comments.

    Thanks

    Mark as answer if it helps.

    Monday, February 11, 2013 12:49 AM
  • User-146807150 posted

    This is the Expression for Rev

    ="Rev." + Fields!Dwg_Rev_No.Value

    this is the expression for category

    =Fields!Dwg_Category_Short_Desc.Value

    this is the expression for Quantity

    =SUM(Fields!Material_Quantity.Value)

    please tell me how to concatinate this

    your telling something like "Rev0Qty1" but i don't have a column like this.....

    please give me some suggestions out of my information whatever i provide


    Monday, February 11, 2013 1:04 AM
  • User460370150 posted

    Look you have a sum function on quantity field i.e

    SUM(Fields!Material_Quantity.Value)

    What is the actual value you are getting from DB?
    Monday, February 11, 2013 1:49 AM
  • User-146807150 posted

    Here i'm getting the value for Rev0 , Category type "A", material_type "RCC" the value of that is 1.

    simillarly in Rev1, category "A", material_type "RCC" the value is 0...

    so in Rev1 i want to display 1+0=1.

    Monday, February 11, 2013 2:09 AM