Crystal Report with multiple grouping
Hello,
I have a CrystalReport in which I want to devide the records in two groups depending on datatable field "id". In the first group I want to have the records which have id value less then or equal to 10, and in the second group >10. Also within the group I also want to have another group depending on id.
If the id<=10 I want the textobject in the crystal report to have value "Pr" and if >10 to have value "IS"
It should look like:
Pr (First group if id<=10)
id Name Price
01 ppp 124 (Embedded groups)
01 ppp 56
-------
180
02 kkk 67
03 nnn 89
Is (Second group if id>10)
22 mmm
23 bbb
25 ddd
I inserted group selection formula and chose is less then or equal to 10, but now I get only one group, I can not see the other group for the case if id>10 and Text12 has value "Is". I don't know what to do, how to solve this.
I tried with this formula in Group Selection Formula:
if ({DataTable1.idpod} <= "10") then Text12.text="Priem" else Text12.Text="Isplata"
but there was an error occured when trying to save it.
Can anybody please help me?
Thanks
P.S. I use one datatable from the dataset for the report