Skip to main content
siddhants0001
New Participant
April 14, 2022
Question

is making reports using stored procedures is good practice or using expression rule ?? which is best and why?

is making reports using stored procedures is good practice or using expression rule ?? which is best and why?

    6 replies

    harshitb6843
    Brainy
    April 14, 2022

    I would always recommend using records or expression rules for reporting. 

    stefanhelzle0001
    Brainy
    April 14, 2022

    There is not general answer to this question. Yes / No / Maybe ...

    siddhants0001
    New Participant
    April 14, 2022

    as  appian developer what would you prefer ?

    stefanhelzle0001
    Brainy
    April 14, 2022

    The appropriate, based on the requirements. In general I try to do as much as possible inside Appian.

    christineh465186
    Participating Frequently
    April 20, 2022

    I would be curious as to the needs.. It could be about what you are making the user "wait" for.

    If your report needs to dynamically create a SQL to execute and get the data - then sure a stored proc
    If your report is manipulating data - then use a view
    If your report is pulling data from a table - use a table

    Using a stored proc for a report is a maybe (but should not be often)