is making reports using stored procedures is good practice or using expression rule ?? which is best and why?
Discussion posts and replies are publicly visible
I would always recommend using records or expression rules for reporting.
There is not general answer to this question. Yes / No / Maybe ...
as appian developer what would you prefer ?
The appropriate, based on the requirements. In general I try to do as much as possible inside Appian.
okay sir thank you
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 procIf your report is manipulating data - then use a viewIf your report is pulling data from a table - use a tableUsing a stored proc for a report is a maybe (but should not be often)