I have a VB active report that has many different attributes in the report include the area, balance, id and status in report and current My area has been grouped in Now what I need to do is remove all the lines from the report where the equilibrium is equal to 0 and the position is equal to the diactive. The information of the active report is from my database, so I think the best way would be to select Records only where the balance is not 0 and the status is not equal to Dynamic. Is there a way that I can query from my database and the active report can be based on query results? Is there an easy way to do this? Thanks for any help.
Yes, the best way to do this is to change the query so that you only need a minimum record The documents that are actually coming in the report show that in the duration of the dynamically in code, that code is to modify that SQL statement.
You can hardly report SQL queries to the code you should probably just modify the SQL in design time within the designer. You discover how to do this.
You can also control the visibility of areas / boxes based on the data using the form of the control section of the program (most likely Detail_Format ), but It seems to me that modifying SQL queries is your best bet.
Comments
Post a Comment