Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Supression of fields or data. User able to select what they want shown

Status
Not open for further replies.

pectin232

Technical User
Jan 22, 2011
67
US
Main Report has many subreports. Every subreport has their own SQL[with procedures in Oracle] and different tables. This report is generated using a JAVA web application when user enters a certain User ID and it searches and finds all relevant information pertaining to that account. In one of the subreports [additional workers], all data is being populated in the report. The user wants to be able to select who he/ she wants displayed in the final report by using a listbox table and then if the user selects user 1,3,4,6 then only records 1,3,4 and 6 is shown. How do I supressed 2 and 5? The subreport has a standard USERID parameter which picks up all relevant data on that person like what he or she buys, types of things purchased, quantity, etc etc.. a lot more.I am not sure if I have been explict enough. Please advise on how to supressed this the easiest/ best way. Thanks
 
This could be done using parameters, both fields and sections have suppress options. Right-click and choose the formula icon (x+2 and a pencil)

[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top