Supression of fields or data concept

[pectin232]

I am not exactly sure on how to do this. A main report has dozen of subreports with dozens of parameters with each subreport focusing on a particular area like finance, last purchase, what was purchased, etc. But it seems data is passed using 1 or 2 primary data through a Command query. It seems most data is using a command query. A user wants this report modified to be able to do this... he/ she is able to select what records they want to show and who they want instead of everything is being pumped out onto the report. From a web based application, the user wants to select who or what purchases are to be displayed only and the others are hidden. It is based more for management reporting. In which area do I need to put code to hide what is selected from the user? As I will not know what is and not selected. Ideas/ suggestions? My colleague told me it is very easy but I am not sure how to implement this. Thanks

 

[hilfy]

You probably don't want to think of this in terms of suppressing data. Instead, you want to look at filtering the data using parameters and selection criteria so that the report is not processing as much data as it would when suppressing fields.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[pectin232]

In the section where I created... do I put code behind the text field itself like this? How do I make it where the user can then enter the invoice number only [separated with a comma]or from a populated invoice no list box?... then from the invoice number... another sub report will display all the items the invoice no has...

{Command.ADDITIONAL_PURCHASES} in ("")

 

[pectin232]

In Select Expert how do I create it where values can be populated and the user can multi select the values they want shown in the report? or could this not be done. It does not have to be perfect.