Topic: group by of SQL in Crystal report Posted: 23 Aug 2011 at 3:24am
Hello,
How could I make a group by in Crystal reports. I need it to make a max of a group with same values. The problem that I have is duplicated records with same values.
I need that in show SQL query get "group by", any idea?
Joined: 16 Oct 2008
Location: United States
Online Status: Offline
Posts: 255
Posted: 23 Aug 2011 at 3:51am
is this the same as the previous posted question?
to create a group
click on the field you want to group by
right click
insert group
duplicate records are caused by joins, but to get rid of the duplicate records if you create a group and place the field in the group it will return the 1st unique value for the group.
I need it to make a max of a group with same values?????
I need that in show SQL query get "group by", any idea????
can you be more specific, it is easier to help you.
If I click on a "Field explorer" the table that I want to group by, I have only this options:
Insert to report
Browse data
Data expert
Set Datasource Location...*
Log on or Off server
Find in formulas
Show Field type
Refresh
I dont find insert group, the only way
Yes, I need to make a max of a group with same values
The las question I mean that if I click Database tap on top, then Show SQL Qery...I have the query that Crystal report has created automatically, but I have not got to see group by...
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
IP Logged
