1. when i open query designer and select some columns and click 'Done'. the generated query comes on query textarea present on 2nd step.
and then if I chnage my mind to add one more column and click query designer again then query textarea becomes empty and in query designer it doesnt show me the graphical structure of the tables which i selected previously.
So I have to start again from the beginning just to add one more column. Can something be done about this?
3. In expression tab can we have 'SUM' also? I want to sum up one of the column , but could not do so. In later steps we have facilty to SUM the numeric field but it doesnt work..may be I am doing something wrong but its not evident.
So I have to write SUM explicitly in the query manullay.
Tweaking sql manually can be a big turn off for the biggies of my company before whom I am proposing Pentaho reporting.