c# - MySQL database Reports using Views -

To create a view, instead of creating a report using Crystal Reports, the row-count of different tables and schemas Will return the series. .. etc .. ..

Using the counting, there are worries about inquiries of several tables and where the clause

What is the down side of this approach ??

Choose a small snippet from the IM making scene

  Select CCVC status as' COUNT '(' Status') from CCWC Group CCVCT union CCVC by ' Select 'WC_XCarded', 'CCVC' Association from Union 'WC_Outal', select 'Number' from, COUNT (ID) from CCWC, where effort = 3 union Select 'WC_NO_Attams', COUNT (ID) from CCWC Where Attention = 0 Select Union 'CcEmp calculation'    Note: This view will be used by a Winforms C # application for approximately 100 clients connected to Max SQL Server   < / Div> 
 
 
 There is no problem in querying the database in this manner to make me a view. The effects you are indicating are extremely negligible.