locked
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?

     

    Thanks

    Tuesday, May 6, 2008 3:44 PM

Answers

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

     

    -- Robert

    Tuesday, May 6, 2008 4:23 PM