Bug 161520 - Add existing resultSetColumn to cell
Summary: Add existing resultSetColumn to cell
Status: REOPENED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: 2.1.1   Edit
Hardware: PC Linux
: P3 enhancement (vote)
Target Milestone: Future   Edit
Assignee: Rima Kanguri CLA
QA Contact:
URL:
Whiteboard:
Keywords: plan
Depends on:
Blocks:
 
Reported: 2006-10-19 04:06 EDT by Alexander Bieber CLA
Modified: 2010-02-09 17:22 EST (History)
2 users (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Alexander Bieber CLA 2006-10-19 04:06:09 EDT
Hi all,

after switching from 2.1.0 to 2.1.1 the Report Designer behaves differently when adding ad "Data" element to table cells. 
The previous version presented a table of currently existing resultSetColumns and allowed changing and adding to them with table cell editors. 
The new version forces the user to define a new column, so the only way of adding an existing column to a cell is by adding it in the xml.
Imho the old behavoiur is more reasonable as it allows both, adding new and existing columns.

Best regards
Alexander Bieber
Comment 1 Wenfeng Li CLA 2006-10-20 20:08:00 EDT
the context menu on the data item allows switching to an existing column. so the stp could be DnD a new data item to the cell without define a new column, then use the context menu to select an existing resultSetcolumn.

Another way is to DnD the field from the data explorer to the table cell in stead of cteating a new data item.

Will continue to review this UI, any suggestion is welcome.
Comment 2 Alexander Bieber CLA 2006-11-02 04:28:15 EST
Thanks for the hint with the context menu, I didn't know that. 
However, there is imho no intuitive way of adding resultSetColumns that do not appear in the data explorer (e.g. aggregations) without creating them on the fly.

Maybe DnD support for the "Binding" tab in the "Property Editor" View would be a good idea. This way one could drag all existing columns into a table cell.

Comment 3 Rima Kanguri CLA 2007-08-09 01:10:24 EDT
1) Based on UI feedback and comments the behavior was changed in BIRT 2.1.1

2) About your latest comments that there is not easy way to defining aggregations
- In BIRT 2.2, the new aggregation builder has been added. User can drag aggregation item from paletter to report item and define a new aggregation.

I will mark this bug as resolved.
Please review the feature and re-open the bug if you have comments.
Comment 4 Alexander Bieber CLA 2007-08-22 07:21:34 EDT
Sorry for the late reply.
I've reviewed the feature and I still think the workflow is strange somehow:

After you've created a table with column bindings you want to add one of these bindings to the table:
1. Select 'Data' item in the palette
2. Click in the table at the place you want to place it
3. Now, in order not to add a new binding you have to cancel the dialog, which seems strange to me
4. Now use the context menu to change the column binding

Maybe a switch in the dialog would be reasonable where the user can choose between:
  'Add a new column binding' or
  'Select from an existing binding'

Best regards
Alex
Comment 5 Wenfeng Li CLA 2007-08-28 18:43:54 EDT
move to 2.3.0 to further consider this UI improvement.
Comment 6 Rima Kanguri CLA 2008-06-02 18:43:03 EDT
Based on usability feedback, we removed the switch as the feedback we got was showing the two choices was confusing.

There is another way you can add a new data item which refers to an existing resultset column
- DND a data item to layout view
- Click on the expression button to show the expression builder
- In the expression builder select the result set column under 'Available column bindings' 

Comment 7 Rima Kanguri CLA 2008-06-02 18:47:55 EDT
Request to move this bug to 2.3.1. 
We can look into it along with other data binding usability issues. Thanks
Comment 8 Wenfeng Li CLA 2010-02-09 17:22:30 EST
st to future until there is more concrete UI mockup.  Add plan key word.