doing a calculation using data from two different source tables RRS feed

  • Question


    I use the following report expression for my SSRS report.


    =SUM(Fields!CBNonAccr.Value) / SUM(Fields!TotNonAccr.Value)*ReportItems!HE__Non_Accruals.Value



    When I try to preview the report , I get a error massege saying "report item expression can only refer to other report items within the same group grouping scope.


    Fields!CBNonAccr.Value and Fields!TotNonAccr.Value come from one table. But HE_Non_Accruals.Value comes from another table which does not have a relationship with the first one. Its a seperate table.

    So I'm wondering how do I do this now?



    Tuesday, May 6, 2008 3:44 PM


  • You will need to join the tables already in the dataset query.


    -- Robert

    Tuesday, May 6, 2008 4:23 PM