Comments by kalaiselvansurya

kalaiselvansurya 9-Nov-13 5:58am View

My Codeing Working in Running time but not work after deployment copy i instaled crystal report v 13. one person tell me u instal netget after working fine but still same problem.
Dim con As New ConnectionInfo
Dim con1 As New ConnectionInfo
Dim db1 As Database
Dim dbs As Tables
Dim db As Table
Dim tab As TableLogOnInfo
Dim rpt As New CrystalDecisions.CrystalReports.Engine.ReportDocument
With con
.UserID = "sa"
.Password = "sa"
.DatabaseName = "TASHEEL"
.ServerName = "Admin-PC"
End With
rpt.Load(Server.MapPath("..\Report\COVER_FEES.rpt"))
db1 = rpt.Database
dbs = db1.Tables
For Each db In dbs
tab = db.LogOnInfo
tab.ConnectionInfo = con
db.ApplyLogOnInfo(tab)
Next
CrystalReportViewer1.SelectionFormula = str
CrystalReportViewer1.ReportSource = rpt
CrystalReportViewer1.ShowFirstPage()
CrystalReportViewer1.RefreshReport()
'rpt.ExportToDisk(ExportFormatType.PortableDocFormat, pdfFile)

kalaiselvansurya 9-Nov-13 5:57am View

My Codeing Working in Running time but not work after deployment copy i instaled crystal report v 13. one person tell me u instal netget after working fine but still same problem.
Dim con As New ConnectionInfo
Dim con1 As New ConnectionInfo
Dim db1 As Database
Dim dbs As Tables
Dim db As Table
Dim tab As TableLogOnInfo
Dim rpt As New CrystalDecisions.CrystalReports.Engine.ReportDocument
With con
.UserID = "sa"
.Password = "sa"
.DatabaseName = "TASHEEL"
.ServerName = "Admin-PC"
End With
rpt.Load(Server.MapPath("..\Report\COVER_FEES.rpt"))
db1 = rpt.Database
dbs = db1.Tables
For Each db In dbs
tab = db.LogOnInfo
tab.ConnectionInfo = con
db.ApplyLogOnInfo(tab)
Next
CrystalReportViewer1.SelectionFormula = str
CrystalReportViewer1.ReportSource = rpt
CrystalReportViewer1.ShowFirstPage()
CrystalReportViewer1.RefreshReport()
'rpt.ExportToDisk(ExportFormatType.PortableDocFormat, pdfFile)

kalaiselvansurya 9-May-13 6:30am View

Dim value = New ParameterDiscreteValue()
value.Value = "kalai"
rpt.ParameterFields("@Name").CurrentValues.Add(value)

Missing parameter values. Please send any sample solution

kalaiselvansurya 8-May-13 22:48pm View

now i get error-- Missing parameter values.

kalaiselvansurya 8-May-13 11:22am View

i set date field also. now i call string value. only again same problem

kalaiselvansurya 8-May-13 7:25am View

rpt.SetParameterValue("@F_DATE", "Test") this line i get the exception? @F_DATE this is my report field(From date field)

kalaiselvansurya 18-Apr-13 11:16am View

My report viewer coding
but I take some report working fine.

rptname = Session("rptname")
str = Session("Str")
Dim rpt As New CrystalDecisions.CrystalReports.Engine.ReportDocument

With con
.UserID = "sa"
.Password = "sa"
.DatabaseName = "TASHEEL"
.ServerName = "server"
End With

If rptname = "inv_rep.rpt" Then

rpt.Load(Server.MapPath("..\Report\INV_LIST1.rpt"))
End If
db1 = rpt.Database
dbs = db1.Tables
For Each db In dbs
tab = db.LogOnInfo
tab.ConnectionInfo = con
db.ApplyLogOnInfo(tab)
Next
CrystalReportViewer1.SelectionFormula = str
CrystalReportViewer1.ReportSource = rpt
CrystalReportViewer1.ShowFirstPage()

kalaiselvansurya 7-Apr-13 12:18pm View

My Export Excel coding
" Dim form As New HtmlForm()
Dim attachment As String = "attachment; filename=Patients.xls"
Context.Response.ClearContent()
Context.Response.AddHeader("content-disposition", attachment)
Context.Response.ContentType = "application/ms-excel"
Dim stw As New StringWriter()
Dim htextw As New HtmlTextWriter(stw)
form.Controls.Add(GridView1)
Me.Controls.Add(form)
form.RenderControl(htextw)
Context.Response.Write(sb.ToString())"

MyConnection = New system.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0; " & _
"data source=C:\Users\develope\Downloads\Patients.xls; " & "Extended Properties=Excel 8.0;")

This is my connection string but i get same error
"External table is not in the expected format. "

Comments by kalaiselvansurya (Top 8 by date)