locked
which is best solution for my requirement RRS feed

  • Question

  • User540577793 posted

    All,

    I need to implement a module  and requirement is as following..

    There are four table in database and user wants to have an interface where he can choose a table and then column and apply some condition along with Join like left and right and he wants to save this as a report reason for it simple the no of record that are there in table are in millions so if we save it (somehwhere) and then have a window based service picking up that saved selection can generate that report.

    What is the best way to solve it.

    I've two things in mind one is use expression Builder but not sure how and where will i save this selected section another solution that I've in mind is to store these selected in database and have one proc making a proper SQL select statement.

    which solution is best in the given situation?

    my user wants to

    Saturday, August 10, 2013 2:45 AM

Answers

  • User-821857111 posted

    Whenever I have done this kind of thing, I store the selection criteria in a database and then use it to generate a dynamic SQL statement, which is what I execute using ADO.NET to produce the report. It's the easiest approach.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Saturday, August 10, 2013 4:10 AM