Problem : If you're using crystal report to design a report and the data displayed on the report won't change.
Solution : Go check the report. Open it, then make sure that on menu File -> Save Data With Report -> is NOT checked.
This is actually a minor problem, but sometimes, people forget or don't notice it.
About Me
- Steven Luck
- Is an ordinary man, with a little knowledge to share and high dreams to achieve. I'd be glad if I can help others, 'coz the only thing for the triumph of evil is for a good man to do nothing.
Popular Posts
-
Have just got a lovely blog award, my second one, from a friend, Mona ^^ But there is a rule to accept this award.. hehehe... Post it on yo... -
Error: Creation of the virtual directory http://localhost/web failed with error: Could not find the server 'http://localhost' on the... -
Are you learning Assembly language , and confused about how to compile assembly file? TASM20 is one of assembly compilers that works with ... -
If you are trying to update a table containing XML column via Linked Server in SQL Server, and you are not able to, you are not alone. There...
-
Error: Error converting data type int to nvarchar This error occurs when a stored procedure which returns a value is used. e.g CREATE P...
i have unchecked the "save Data With Report". But the problem is, the crystal report is won't show when i call it from VB...
ReplyDeleteThank's
please reply to my email new_baru17@yahoo.com..
Thanks for your help..
this is my code on vb...
ReplyDeleteCrystalReport1.SQLQuery = "SELECT * from cetak_periksa"
CrystalReport1.UserName = userDb
CrystalReport1.Password = passDb
CrystalReport1.Connect = cnStr
CrystalReport1.ReportFileName = App.Path & "\report\cetakperiksa.rpt"
CrystalReport1.PrintReport
usually i use that script and it work,,,but why suddenly it didn't work...
i ever get the same problem,,, but it solved by it self before i fixed it (i mean it fixed automatically without me)
Hmm, what kind of connection do you use for the report? I usually use either stored procedur (ODBC), or TTX. I prefer using TTX, it is more flexible.
ReplyDeleteYou can see how to use TTX on my earlier post : http://programmerslab.blogspot.com/2009/04/connecting-crystal-report-and-vb-using_14.html.
Set rs = New ADODB.Recordset
rs.Open "select CustomerID, CompanyName, ContactName from customers where customerid like 'A%'", conn, 1, 3
With CrystalReport1
.Reset
.Connect = conn
.SetTablePrivateData 0, 3, rs
.ReportFileName = App.Path & "\rptTest.rpt"
.WindowState = crptMaximized
.Destination = crptToWindow
.WindowShowPrintSetupBtn = True
.WindowShowSearchBtn = True
.WindowShowRefreshBtn = True
.WindowShowSearchBtn = True
.Action = 1
End With
This is how I do it with TTX. Remember, if you use TTX, the fields in the .TTX file must be exactly the same as in the datasource.