Community
Participate
Working Groups
Build Identifier: 20100617-1415 New Feature Request: In: Report DataSet Request: DataSet -> Output Columns. Provide an ability (checkbox) to show or hide columns. For ex: Assume a DataSet has following fields (id, name, quantity and price). When I add a computed column ex: total = (quantity * price), the total field lists up in Output columns which is great. Now in "Preview Results", all the 5 fields (id, name, quantity, price and total) would list up. There is no option to not show (quantity and price) in Preview Results. Reproducible: Always Steps to Reproduce: 1. Open "xxx.rptdesign" file in Eclipse IDE for Java and Report Developers Version: Helios Release, Build id: 20100617-1415 2. Create New DataSet with fields(id, name, quantity and price). Go to Output Columns, you will see [Name, Type, Alias, Display Name, Display Name Key] column headers. Listing the 4 fields. 3. Go to Computed Columns, define "total" computed field to be (quantity * price). 4. Go back to Output Columns, you should see the new field "total" listed there. 5. Go to Preview Results, you should see all the 5 fields. What we want to see is in Output columns, an extra header(Show/hide) and for each field a checkbox, Checking this would show the corresponding field in Preview Results else the field will not be listed in Preview Results.
Created attachment 187859 [details] 33571_ShowOrHide.jpg file shows the current Ouput Columns listing quantity, price and total fields
Created attachment 187860 [details] Preview_Results.jpg shows all the fields listed in Output Columns
What is the use case for wanting to hide some data set columns in the Data Set Editor's preview? The Data Set Editor's preview page is intended to help users to verify the data set design, and thus shows all the columns that the data set will return. It is when binding data set columns to a report item like a table, one would then choose the specific data set columns to apply. Doing a report preview would show data from only those data set columns. It seems that you might be trying to use the Data Set Editor's preview functionality for other purpose?
No response so far on a valid use case for this enhancement request. Please feel free to reopen if applicable.
It's a convenience purpose. We bind datasets to a lot of fields in our reports and we find that we always need to remove the same sets of "intermediate" fields from the binding - or live with seeing these unusable bindings on the fields. It would be great to have these fields "hidden" when we bind a dataset to a report element. Thanks.
(In reply to comment #5) I see. So the enhancement request is *not* to hide selected data set columns in the Preview Results page of the Data Set Editor, as indicated in the original description? But to hide them wherever else the data set columns might be displayed, e.g. in the Data Explorer tree, and in all UI controls where the list of data set columns are displayed for selection, such as in the JavaScript Expression Builder dialog, Filter Condition dialog, Sort Key dialog, etc.?
Hi Linda, that is all correct. Thanks!
