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
Mac Punsalang
NA
3
0
Need Help! No data when I export my crystal report into pdf file
Oct 30 2009 2:31 AM
Guys,
Can you help me how to debug my codes, I was stuck and i can't find the error why there's no data appeared when i export on pdf file.
DSData as my DATASET
DTR_Report as my Crystal REport
here's my code:
DataOpen()
cmd.CommandText = "Select BIOID, afpsn, Dept, Lname, Fname, CONVERT(char(10), date, 101)Date, Day, AM_IN, AM_OUT, PM_IN, PM_OUT, OT_IN, OT_OUT, DeptHead, DeptPost, TimeLate from AllDTR where BIOID = '" & users & "' AND Date > '08/31/2009' ORDER BY Date"
da = New SqlClient.SqlDataAdapter(cmd.CommandText, cmd.Connection)
ds = New DSDTR
da.Fill(ds, "PrintDTR")
cmd.Connection.Close()
Dim rpt As New ReportDocument
rpt.Load(Server.MapPath("CrystalReports/DTR_Report.rpt"))
rpt.SetDataSource(ds)
Dim expOption As ExportOptions
Dim destination As DiskFileDestinationOptions
Dim Fname As String
Fname = Server.MapPath("App_Data/Temp/" & Session.SessionID.ToString & ".pdf")
destination = New DiskFileDestinationOptions()
destination.DiskFileName = Fname
expOption = rpt.ExportOptions
With expOption
.DestinationOptions = destination
.ExportDestinationType = ExportDestinationType.DiskFile
.ExportFormatType = ExportFormatType.PortableDocFormat
End With
rpt.Export()
Response.ClearContent()
Response.ClearHeaders()
Response.ContentType = "application/pdf"
Response.WriteFile(Fname)
Response.Flush()
Response.Close()
System.IO.File.Delete(Fname)
Reply
Answers (
4
)
Add data(rows) via datagridview
excel insert if not exists in sql server