By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,362 Members | 3,489 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,362 IT Pros & Developers. It's quick & easy.

crystal report refresh update ide

P: n/a
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).
Nov 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.

"aldous scotch" <al****@discussions.microsoft.com> wrote in message
news:0c****************************@phx.gbl...
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).

Nov 20 '05 #2

P: n/a
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.

"aldous scotch" <al****@discussions.microsoft.com> wrote in message
news:0c****************************@phx.gbl...
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).

Nov 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.