SQL Server Performance

crystal reports

Discussion in 'SQL Server Reporting Services' started by alinysyahril, Sep 29, 2005.

  1. alinysyahril New Member

    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
  2. dineshasanka Moderator

  3. Madhivanan Moderator

    Open the Report Do verify Database and save it
    It will work without problem


    Failing to plan is Planning to fail
  4. ranjitjain New Member

    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.
  5. alinysyahril New Member

    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=':)' />
  6. Madhivanan Moderator

    Open the report and goto preview mode
    Are you seeing the records?


    Failing to plan is Planning to fail
  7. aliny New Member

    quote:Originally posted by Madhivanan

    Open the report and goto preview mode
    Are you seeing the records?


    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

  8. Madhivanan Moderator

    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


    Failing to plan is Planning to fail
  9. ranjitjain New Member

    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.

Share This Page