Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Group by, select fields Post Reply Post New Topic
Author Message
Melina291
Newbie
Newbie


Joined: 05 Mar 2013
Online Status: Offline
Posts: 8
Quote Melina291 Replybullet Topic: Group by, select fields
    Posted: 05 Mar 2013 at 10:56pm
Goodmorning
I want some help for a crystal report in Crystal Reports 11
My table in my database have a field that called 'name' with values 1,2,3
 
What i want is to seperate my crystal in 3 parts. So when the value is 1 collect all the data with 1 and put in first part same when the value is 2 collect data and put them in second part of crystal and finally same with 3.
So i dont know how to do it and i need some help. I dont know how to use group by.. For example
 
if 'name'=1 collect all the data with 1 value and put them in first part of crystal
IP IP Logged
Ganesh Khuspe
Newbie
Newbie


Joined: 06 Feb 2013
Online Status: Offline
Posts: 18
Quote Ganesh Khuspe Replybullet Posted: 06 Mar 2013 at 12:14am
Can u show the output of report thet you want??
IP IP Logged
Melina291
Newbie
Newbie


Joined: 05 Mar 2013
Online Status: Offline
Posts: 8
Quote Melina291 Replybullet Posted: 06 Mar 2013 at 12:49am
Yes

Cash of the day
----------------------------

1.
------
1.  george king    200$
2.  alex king         100$
3.   jim floyd         50$

sum=350$

2.
--------
1. buy products       100$
2. transfer products  50$
sum=150$

Total 1-2=200$

So its something like that i didnt put everything only the basic. Everything is on the same table.  If it is the value i said 1 its income if its 2 its spend. I want in my report to be seperate . so i want something like group by if my value is 1 to put it on top if its 2 to put lower on page
IP IP Logged
Ganesh Khuspe
Newbie
Newbie


Joined: 06 Feb 2013
Online Status: Offline
Posts: 18
Quote Ganesh Khuspe Replybullet Posted: 06 Mar 2013 at 3:04am

(If i am wrong then please make me Correct@All Senior members)



If your database field "Name" contains 1,2,3 and if you want to put Your record as per your given format then you can use Group By of main Crystal report.Insert Group and select Name as field and in ascending order..You will get the records as per the names...

Edited by Ganesh Khuspe - 06 Mar 2013 at 10:24pm
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2025 Brian Bischof. All Rights Reserved.