Crystal Report

[viral123]

Hi all

I have Branch name, employee name and some of the fields in my database. I have to create attendance report using crystal.

The problem is in my report I want to display employee names order by their branch name. for e.g.

in my crystal report i want to display data in this way

Brooklyn Branch name

Mr. kevin
Miss zuilaana
Mr. craig

Canberra Branch name

Mr. don
Mrs. kim

I tried to use two separate commands but it didn't work.

Please Let me know as soon as possible that how could I solve this?????????

Thanks you all for trying to solve this in advance

[viral123]

Hi all

again it is the same question regarding the crystal report query

Actually I need to display each Branch on new page in crystal report.

I want the employee name order by branch name and the department name is well for e.g.

Branch1: page1

Department1

Employees

Department2

Employees
.
.

Branch2: Page2

Department1

Employees

Department2

Employees
.
.

Thank You all in advance to solve it.

[lakshmanarayanan]

Hi viral123,

I tried to display every branch and employer name in new page order by branch name

Use this coding in page_load

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArg s) Handles MyBase.Load
'Put user code to initialize the page here

Dim rpt As New CrystalReport2
Dim mydatareader As SqlDataReader
Dim myConnection As SqlConnection = New SqlConnection(" Server=Gopi;ini tial catalog=Northwi nd;User Id=sa;Password= ;")
Dim MyCommand As SqlCommand = New SqlCommand("sel ect brname, empname from BRANCH order by brname", myConnection)
Dim myDA As New SqlDataAdapter
Dim myDS As New Dataset4


myDA.SelectComm and = MyCommand
myConnection.Op en()
myDA.Fill(myDS, "BRANCH")
myConnection.Cl ose()
rpt.SetDataSour ce(myDS)
CrystalReportVi ewer1.ReportSou rce = rpt

Dim s As System.IO.Memor yStream = CType(rpt.Expor tToStream(Cryst alDecisions.Sha red.ExportForma tType.PortableD ocFormat), System.IO.Memor yStream)
Response.Clear( )
Response.Buffer = True
Response.Conten tType = "applicatio n/pdf"
Response.Binary Write(s.ToArray ())
Response.End()
s.Close()
s = Nothing
End Sub


and

In crystal report
click --> Detailed Section --> Format Section --> Check New page After

then u will get branch name and details with each page

Wish you success

[lakshmanarayanan]

Hi viral123,

Do the following stepts, u will get your result

1. first place the fields in crystal report
2. clikc the field (in right click) in crystal report and choose format options
3. In format option, choose column tab.
4. In column table chek the option suppress if duplicates
5. click <ok>

u will get like this

branch name1

employeename
employeename
employeename

branchname2

employeename
employeename
employeename

wish u success