Each record as separate report

Hai,
I had developed one program to creating resume in pdf form by accessing the data from database.
Software used Asp.Net 2005,Ms Access 2000, Crystal Report XI.

What should be happen in my program?:

For example consider 3 rows in my database and fields as id,name,qfn,exp,softknown,edu,....in detailed manner.
If I run my program first row should be read and make the pass the values to the report designed and save by using the name and exp values from database. And then the second record, then third record.

What is Happening?

Values are passing properly. Reports are creating and saving as we need. but only thing is in all the pdf's all the three records are displying.
I need in first pdf, first row of the database,.
I need in second pdf, second row of database.
same for third.

My code

Dim intIdx, rcount As Integer
Dim intId As Integer
Dim reportPath, QUERY_STRING As String
CandidateReport = New ReportDocument()
reportPath = Server.MapPath("ResumeReport.rpt")
CandidateReport.Load(reportPath)
QUERY_STRING = "Select * from ReportTable"
If Cache("ResumeDataSet") Is Nothing Then
'myDataSet = DatasetConfiguration.ResumeDataSet
myDataSet = ds.Resumedataset(QUERY_STRING)
Cache("ResumeDataSet") = myDataSet
Else
myDataSet = CType(Cache("ResumeDataSet"), DataSet)
End If
rcount = myDataSet.Tables("ReportTable").Rows.Count
For intIdx = 0 To 2
File_name = myDataSet.Tables("ReportTable").Rows(intIdx)("Cand idatename")
File_name = File_name & "_" & myDataSet.Tables("ReportTable").Rows(intIdx)("Work exp")
intId = myDataSet.Tables("ReportTable").Rows(intIdx)("Cand idateid")

CandidateReport.SetDataSource(myDataSet.Tables("Re portTable").Rows(intIdx).Item("Candidatename"))
ReportView.ReportSource = CandidateReport
If Not IsPostBack Then
Exporttypeslist.DataSource = System.Enum.GetValues(GetType(ExportFormatType))
End If
ExportSetup()
ExportSelection()
ExportCompletion()
'ds.Resumedataset(QUERY_STRING1).Reset()
Next
[2138 byte] By [g1m0v0n5] at [2007-11-20 11:48:35]
# 1 Re: Each record as separate report
Crystal Report's function is only to show data that you give. If you provide 3 records, report shows 3 records; if you provide 1 record, report only show 1 record. So, it's up to you.

There is another way to do this. You can group Candidatename in report, and then set group section "Keep Together".
jasonli at 2007-11-9 11:54:07 >
# 2 Re: Each record as separate report
HAi,
Thanks for reply.
Problem sorted out.
g1m0v0n5 at 2007-11-9 11:55:09 >