Creating reports and dashboards | Stimulsoft community forum

How can i group for more than one field? Eg. In a GroupBand i would like to group for "Invoice number" (Integer)and "Invoice date" (DateTime), displaying both of them in the same group. Must i create two groups, one for each field, and in the second group i must display the two fields?

Thanks.

Yes such a way is possible. But also in the condition of the same group you may type the following expression:
In that case you may use only one group.

Thank you.

I wanted to add that in my case one field is datetime and one is integer.

Doing a grouping:

{ToString(MyDate)} {MyIntegerCode}

gave bad performance and uncorrect grouping.

Doing
{ToString(MyDate)} {ToString(MyIntegerCode)}

everything worked fine and performance where ok.

Thanks.

Thank you for the tip. All expressions must be cast to the type string in the group condittion.

The same result you may achieve via the following:

{ToString(MyDate) + ToString(MyIntegerCode)}

Thank you.