Live Reporting in CrystalViewer

[jmancuso]

I'm having difficulties ensuring that a report refreshes automatically when loaded. The data in the report is old and does not reflect recent modifications to the data it is pulling. I've developed this report in the .NET interface and have checked "discard Saved data when loading reports".

Can anyone please help with this, it is driving me nutts!

Thank you.

 

[kulrom]

Probably you need to do this as you have changed structure of your DB:
in design view > Field Explorer > Database Fields > right click > Verify Database > "OK"

Cheers

btw, can you send the code that loads the report/s?

 

[jmancuso]

Thank you for the response. I have tried verifying my datatbase over, but to no avail. Any other ideas would be appreciated.

This is my code to load the reports:


Try

'Load report

If strReport <> "" Then

vwrReports.ReportSource = strPATH & strReport

vwrReports.Refresh()

Else

MsgBox("Please select report to view.")

End If

Catch ex As Exception

MsgBox(ex.Message)

End Try

 

[kulrom]

"discard Saved data when loading reports".

Could you explain the logic behind that?
I know we will resolve this but i'm afraid i don't know what is it that you've checked there ... Cheers

hey ... nearly i forgot to ask you about conn ... which conn type you are using there ? ODBC, OLE DB .... ?

 

[jmancuso]

Thanks for your continued help. I'm about witts end.

The report has been live for about a month now and data in it is about a week old, nothing has changed (minus criteria changing slightly in one of the SQL queries, I highly doubt this would impact it and I did verify database afterward).

First thing I do in my code is construct the path name and report name (I do this through ADO).
vwrReports.ReportSource = strPATH & strReport
In a sample case strPath = "S:\\Shared\\TEST"
strReport = "rpt_Test.rpt"

The data populating the variables is mined from a database.

The report and everything load fine, again the data is old. I modifying the query logic so that it would return no results and still everything showed up on the form. It is almost as though something in the file has gone corrupt.

Thanks.

 

[kulrom]

I'm almost positive that you have changed something in DB's structure .. datatype, field name or something ... and cr's files are very sensitive on these kind of changes ... anyway we could resolve this except we need a more time ... hmm do you have Yahoo IM?
Contact me via Yahoo messenger ... i'll help you out ... cheers