SQL Server Performance Forum – Threads Archive

crystal reports

hi <img src=’/community/emoticons/emotion-1.gif’ alt=’‘ /><br /><br />when i click on print button of the application using VB6, the crystal report has generate report however the data is not been retrieved from the database (mssql). <br />(it’s only header of the report)<br /><br />then i verify database in crystal reports application, it prompted :- <br /><br />The database file "&lt;table name&gt;" has changed. Proceeding to fix up the report! <br /><br />what actually the problem and what should i do?.. <br /><br /><br />thank u

---

You have modified the database schema after creating the report
Open the crystal report and do an update. then it should work And also, this section is for the reporting service of the SQL Server not for crystal reports. There is a good forum for crystal reports in www.codeguru.com —————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka

---

Open the Report Do verify Database and save it
It will work without problem Madhivanan Failing to plan is Planning to fail

---

You can even do the verifying of database before calling it from VB6 too.
So that even if the DB changes the error won’t be raised and everytime you don’t have do the verify manually.

---

thanks guys..<br /><br />i’m sorry got wrong channel for this discussion <img src=’/community/emoticons/emotion-1.gif’ alt=’‘ /> <br />the data will be retrieved from sql server so i thought this forum will be usefull to me..<br />anyway, thanks a lot dineshasanka <img src=’/community/emoticons/emotion-1.gif’ alt=’‘ /> for pointing me to the right forum.<br /><br />by the way, i’ve tried the solution that had given but i don’t see any changes sir..still the report appear without data..<br />and to mak eu clear, i got the prompted error mentioned before, while i did verify database in crystal report..<br /><br />pls guide me since i’m still new in crystal reports and mssql environment..<br /><br />thank u in advance.. <img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />

---

Open the report and goto preview mode
Are you seeing the records? Madhivanan Failing to plan is Planning to fail

---

i can’t see the data..only the header of the report that have been created earlier.. what should i do sir?..
do i need to recreate the report?
or is there anything with the source code of the vb application? thank u regards.

---

Make sure you have records in the table
Otherwise in the menu Goto Database and Do verify database
Set the Database Location also
Otherwise recreate the report Madhivanan Failing to plan is Planning to fail

---

Try to verify the report from VB end as if in near future if you change something in Db then you again need to verify manually so better is use crytal object property of verifying the db from VB end.
Create an object of crystal report in vb and check for that objects property.

---

]]>