Crystal Report - This field name is not known error. Please Help

Hi obhasha07,

I have faced the same issue.

My report was working fine with the database source in which I have designed it. Then we decided to use different database name. I was providing the database name through config file, once I changed this database name I started getting the same error as you mentioned.

I resolved this by setting the database location as we required while executing it.

for that open ur report, select Database Expert, then select SetLocation option then create new connection and choose the database you are expecting while executing the report.

See if this works for you.........

http://www.tek-tips.com/viewthread.cfm?qid=493919[^]

Hi
try this solution

Private Sub btnPrint_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnIN.Click
Dim strSQL As String = "DataPrinter"
myCom = New SqlCommand(strSQL, conn)
myCom.CommandType = CommandType.StoredProcedure
myCom.Parameters.Clear()

myCom.Parameters.AddWithValue("@FROMDMY", CDate(mskFROMDMY.Text))
myCom.Parameters.AddWithValue("@TODMY", CDate(mskTODMY.Text))

Dim da As New SqlDataAdapter
da = New SqlDataAdapter(myCom)
Dim dt As New DataTable
da.Fill(dt)

Dim objRep As New ReportDocument
objRep = New rptReport
objRep.SetDataSource(dt)

Dim objX As ReportObject
For Each objX In objRep.ReportDefinition.ReportObjects
If TypeOf (objX) Is TextObject Then
If objX.Name = "txtTHEHEAD" Then
Dim objText As TextObject = CType(objX, TextObject)
'objText.Text = ToWordVND(dt2.Rows(0).Item("SumAmount"))
objText.Text = lblTHEHEAD.Text
End If

End If
Next


Dim f As New frm_Report
f.CrystalReportViewer1.ReportSource = objRep
f.CrystalReportViewer1.Refresh()
f.CrystalReportViewer1.DisplayGroupTree = False
f.WindowState = FormWindowState.Maximized
f.Refresh()

f.Show()
Me.Cursor = Cursors.Arrow

End Sub




/****
STORE PROC IN SQL SERVER :

CREATE PROC DataPrinter
@FROMDMY datetime,
@TODMY datetime
AS
SELECT DATE_RECEIPT, MACT, SOCT, ONGBA, DIENGIAI, TKNO, TKCO, amount, MON, RECKEY
FROM DataStorage
WHERE DATE_RECEIPT>=@FROMDMY AND DATE_RECEIPT<=@TODMY
ORDER BY DATE_RECEIPT, MACT, SOCT
GO

Try to set database location at runtime, e.g.

Dim re As New CRReport
 re.Database.Tables("DETAIL").Location = GlobalClass.destnPath & "\POWERFEE_REPORTDETAILS.xml"

I think this may help you....