I m making reports with datavision but the problem i m facing is of outer join with Mysql.MySql doesn't have views, I have such requirement in my report which can be filled through outer join
I m not getting how it can be solved.
DataVision only does "regular" joins right now. Without views, I do not think there is a way to do what you want. On the other hand, I am definitely NOT a database expert, so perhaps somebody more knowledgable can give you a more satisfying answer.
If you join the DataVision users' mailing list, you could ask your question there and see if anybody else has come up with a solution for MySQL.