Nel

Nel

  • NA
  • 716
  • 1.1m

Crystal Report with multiple grouping

Jun 29 2012 4:11 AM
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

Answers (2)