none
SSRS Forms with IIf Statements RRS feed

  • General discussion

  • Team:

    Trying to design a form (2) based on a dataset (1) with four fields and results from a SP. The end-result would be that the Count numbers would populate over to the form (3). The manual way I have this currently is:

    1. dataset results to an Excel sheet
    2. The final form is being populated by reference in cell =qryTCOJ!D3

    I tried using an IIf statement, but having issues with logic:

    =IIf(Fields!field_name.Value ="A_M_L", Fields!COUNT.Value, "")

    A= D3

    B = D2

    C = D5

    D = D4

    I may have to write the SP, but hoping someone here could help.

    Regards,


    jer

    • Changed type jr7138 Monday, June 11, 2018 2:17 PM no answers
    Friday, June 8, 2018 6:48 PM