crystal report refresh update ide

[aldous scotch]

I designed a Crystal Report .rpt from within Microsoft
Development Environment 2003 Version 7.1.3088 (VB .NET
IDE).
I selected database fields from the left side Field
Explorer onto the Details (Section3) of the .rpt.

Also, I added a new web form myWebform.aspx and a web
object CystalReportViewer - CrystalReportViewer1 and had a
code behind in ReportSource

coded as Me.CrystalReportViewer1.ReportSource
= "C:\InetPub\wwwroot\....\myCrystalReport.rpt"
Me.CrystalReportViewer1.DataBind()

I could successfully view the crystal report in my
browser. It shows the 'powered by Crystal Report' logo.
However, the report wouldn't show the updated data even
when I have the data already updated from both MS Access
and SQL 2000 databases.
The report still displays the original data during the
time I have designed the report.
How do you refresh the report to reflect modified data
from the database? (The code
Me.CrystalReportViewer1.RefreshReport() does not work).

(Pls. include website address in your response because my
current browser is also having problem browsing Microsoft
discussion tree sites.
THus, I could click on your address instead of unavailabe
tree of newsgroup topics from this microsoft web site. I
use linked addresses from ms to access this discussion
page. And pardon me posting in this ng but as mentioned
above, i could get only to the appropriate ng).

 

[Sahil Malik]

Frankly

Crystal reports sucks - especially for web. And it's EXPENSIVE.

Try datadynamics.com/activereports

To answer your question in crystal domain only,

You would have to
a) Author the crystal report in vs.net so it creates a codebehind
b) Create the fields in the crys report thru a strongly typed ds or a dummy
stored procs with exact parameter datatype match
c) datasource = the same strongly typed dataset used above
.. whenever you want the report to update the data, just refresh that
dataset, and refresh the page.

Later,
- Sahil Malik
Independent consultant.