• State Not Answered
  • Replies 6 replies
  • Subscribers 6 subscribers
  • Views 1348 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Reports

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

siddhant08
Certified Senior Developer

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

Parents
  • 0
    Certified Lead Developer

    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)

Reply
  • 0
    Certified Lead Developer

    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)

Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.