sql works fine in sql server management studio. 9 records are displayed.
But in crystal report, the same query repeats each record 14 times
I have attached the
Code:
string sql = "SELECT nav.scheme_name,portfolio_master.amt_invested from portfolio_master inner JOIN nav ON nav.scheme_code=portfolio_master.scheme_id and portfolio_master.user_id='" + Session["user_id"]
Leave a comment: