InfoQube IM - Community

Submitted by seanlu21 on 2017/07/25 02:08

Hi, in some of my Grid, it has an option said ' to drag a field ' to have a 'group by' view.

but in some of grid i created by myself, it doesn't have this option,

then I also can not find from the menu,

can anyone tell me how , in a grid, to have a 'Group By' view , by chose any field ?

Best regards,

Sean

Comments

Grid>Sort>[select "Group-By-Bar"]

Left click column header you want to group by, hold down the mouse key, and drag it to the Group-by-Bar.

Wayne

Thank you Wayne.

----

sean lu

I have another question need help:

I would like to export a grid , after I apply "group by" a column, which should looks like this :

group 1

item 1 / column 1 value / column 2 value / etc

item 2 / column 1 value / column 2 value / etc

group 2

item 3 / column 1 value / column 2 value / etc..

item 4 / column 1 value / column 2 value / etc..

what I need is to export this exact looks in to a email body.

I tried to export it into Excel.. but it lost the 'group by' column after exporting.. and I had struggled with Excel but can not find an function to do the same function of 'group by' column in Excel , i remember they called 'group' in excel , but found out the 'group' function in Excel now is something totally funny! and also i tried the 'pivat table' and it is only for calculating counting related.

Then I tried to 'print' out the grid view to just attach a pic of it in a email as the last option. but I also can not find out 'print' menu.

Do any of your experienced users have the similar requirement as export the grouped item's grid into a text body ? if not, can there be any alternative way to achieve an similar result?

Thank you.

Sean Lu

----

sean lu

Sean, did you try to Print to HTML?

I not sure understand this[quote=seanlu21]

Then I tried to 'print' out the grid view to just attach a pic of it in a email as the last option. but I also can not find out 'print' menu.

[/quote]I never noticed that print is not available via any of the menus -- although File >Print Preview works.

For HTML print:

Select the items you want to export (from the top down - order of selection is order of printing IIRC) - or select all

press Ctrl+P shortcut or menu: File >Print Preview

Select option #2

Select desired options in the next dialogue

I never use the grouping feature -- but do use sort a good bit (I group by sorting anyways) so I'm not sure how grouping exports,

Tom

I tried "print preview" for the first time and it locked up the file. Thought it was just taking its time because it was a large grid but then I tried another file with a single item in the grid and it locked that up, too.

Any ideas on how to get it to unlock? Pretty sure I'm going to lose work on this. I usually save before trying something new but neglected to this time.

Wayne

[quote=WayneK]

Any ideas on how to get it to unlock? Pretty sure I'm going to lose work on this. I usually save before trying something new but neglected to this time.

Wayne

[/quote]

I don't think you'll loose anything.

Everything is saved almost instantly, unless it's something in the HTML pane you just wrote a few seconds ago, or if it's a specific grid "setup" (item order, expended hierarchies, etc. - those are saved when the grid is refreshed or savec)

[quote=WayneK]

I tried "print preview" for the first time and it locked up the file.

[/quote]

Humm... the only thing I can see is that when the WYSIWYG print preview opens, it deactivates the main IQ window. Perhaps the previewer was open but behind another window and you tried to go back to IQ without closing it

Pierre_Admin

IQ Designer

I didn't lose anything. I just tried it again and got the same result. It occurs when I select the first option (print the whole grid). Don't think another window pops up because it should show up on the taskbar. If it doesn't, and is hid behind the main window, I can't access it because the main window is frozen (can't move it, ,minimize it, or close it). Only way I could find to get out of it was to kill the process it task manager.

First thought it was because I inadvertently tried to print a large grid but it also happened with a grid containing just one item.

Wayne

[quote=WayneK]

Don't think another window pops up because it should show up on the taskbar. If it doesn't, and is hid behind the main window, I can't access it because the main window is frozen (can't move it, ,minimize it, or close it).

[/quote]

Strange. Do you have a printer set as the default printer ?

In v100, I no longer disable the main IQ window. A message is now shown before showing the Preview window. That should prevent any lock-up

Pierre_Admin

IQ Designer

Yes, I have default set to a physical printer (not pdf), which is turned off.

Wayne

Hi Tom, I am sorry for failed to noticed the "print preview" in the File menu, may be I was only searching for "print", I deeply apologize.

However, the HTML printing only display all items instead of showing the grouped field's name at the upper left corner of each grouped items as we see in IQ. but I managed to use the wysiwyg printing to a text file then I can get the grid's display as a text file, except I can not figure out how to hide those item # on the left edge, ie , 1.1... 2.1..2.2. .. 3.1 .etc.

Thank you very much.

----

sean lu

[quote=seanlu21]
but I managed to use the wysiwyg printing to a text file then I can get the grid's display as a text file, except I can not figure out how to hide those item # on the left edge, ie , 1.1... 2.1..2.2. .. 3.1 .etc.
[/quote]

1) I'm curious: how do you print to a text file (I dont see it as an option: also I thought WYSIWYG is only to image format)

2) does hiding the # column not work ? (hide simply involves 'minimising' it)

hmm, I tested this with WYSIWYG and it still shows a little bit of that column (in PNG & EMF formats at any rate)

Hi Sean,

Print > Preview > WYSIWYG mode will generate a PDF or image file that you can include in the email. Other copy / paste or print will not keep the grouping information.

I'll see if copy / paste can be improved

Pierre_Admin

IQ Designer

[quote=Pierre_Admin]

I'll see if copy / paste can be improved

[/quote]

Copy / Paste was improved for grouped grids

HTH !

Pierre_Admin

IQ Designer

Pierre/Sean - thank you, I tested copy/paste grid with group by field.

I can paste all items selected no problem, but the grouped 'field's value, which is at the upper lefter corner as a title for each groups of items, disappeared when copy/paste.

but , never mind, I can still obtain the desired result by printing to a text converter.

best regards.

----

sean lu

OK.

The improved copy / paste is available in v100, to be released in a few days

Pierre_Admin

IQ Designer