Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 335718

Summary:

Show/Hide Output Columns in DataSet

Product:

z_Archived

Reporter:

sushma <sushmasatish>

Component:

BIRT

Assignee:

Birt-Data-inbox <Birt-Data-inbox>

Status:

REOPENED ---

QA Contact:

Xiaoying Gu <bluesoldier>

Severity:

enhancement

Priority:

CC:

balzerd, bluesoldier, lchan

Version:

unspecified

Target Milestone:

Future

Hardware:

OS:

Windows XP

Whiteboard:

Attachments:

Description	Flags
33571_ShowOrHide.jpg file shows the current Ouput Columns listing quantity, price and total fields	none
Preview_Results.jpg shows all the fields listed in Output Columns	none

Description sushma

2011-01-28 13:11:02 EST

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.

Comment 1 sushma

2011-01-28 13:14:41 EST

Created attachment 187859 [details]
33571_ShowOrHide.jpg file shows the current Ouput Columns listing quantity, price and total fields

Comment 2 sushma

2011-01-28 13:16:37 EST

Created attachment 187860 [details]
Preview_Results.jpg shows all the fields listed in Output Columns

Comment 3 Linda Chan

2011-05-18 00:14:32 EDT

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?

Comment 4 Linda Chan

2011-05-18 16:03:17 EDT

No response so far on a valid use case for this enhancement request. 
Please feel free to reopen if applicable.

Comment 5 Dmitry Balzer

2011-06-07 04:44:54 EDT

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.

Comment 6 Linda Chan

2011-06-07 20:39:20 EDT

(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.?

Comment 7 Dmitry Balzer

2011-06-10 11:41:47 EDT

Hi Linda,

that is all correct. Thanks!