TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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
Reply
Answers (
2
)
Blank pages in ssrs pdf export because of long text in textfield
Crystal Report problem using with dataset