Two groups in CrystalReport - embeded groups

Nel

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.
Can anybody please help me?
Thanks

P.S. I use one datatable from the dataset for the report.

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nel14y ago
I tried with subreports. It is ok now but again I can not insert a tytle for every group
Nel14y ago
Hi Pravin,
Whenever I try to do what you suggested me
1)Insert 2 groups in crystal report & group both this 2 group by "id" field.
2)In 1 st group expert , in Suppress write condition id<10
3)In 2 nd group expert , in Suppress write condition id>10

both groups change, not only the one where I make the codnition. For example in the first group expert -> options->options->Use formula as a group name->ToText({DataTable1.idpod} <= "10")
If I open the second group, the same way as above, it is already changed like the first one. If I write here >10, it automatically changes in the first group expert:(. So, the both groups are same, and every time I see only one type of records, made either by the first condition, if I leave id<=10, or >10 if I set the condition in the second group. I can not see two groups, in both ways only one group is shown.

So, I don't know what to do:(
Pravin Ghadge14y ago
Nel,

Have u got the solution?
If no then reply
Pravin Ghadge14y ago
This is very simple.
In first group where id<10 , here you hardcode the text object as "PR"
and same for second group
Nel14y ago
But how to set the text object before every group to have appropriate value i.e. if id<=10 the text12.text to be "Pr" and if not text12.text, which is in the report, to have value "Is" before the groups, as a tytle? And on that way both the groups would be separated by the title?
Pravin Ghadge14y ago
For time being,comment out the group selection formula & tried my setting.

I think it must work.
Nel14y ago
I have already tried this setting the condition in the Group Selection Formula in the first group <=10 and when I write >10 in the second it automatically changes the first Group Selection Formula the same way I wrote the last condition. So this makes the both groups to have a same condition for the both groups
Pravin Ghadge14y ago
1)Insert 2 groups in crystal report & group both this 2 group by "id" field.
2)In 1 st group expert , in Suppress write condition id<10
3)In 2 nd group expert , in Suppress write condition id>10

Hope this may help you.
Nel14y ago
Yes, "id" field (from the example above, 01, 02, 03, 22, 23, 25)
Pravin Ghadge14y ago
Hi Nel,

May i know from which field you have grouped your report.