470,641 Members | 1,566 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,641 developers. It's quick & easy.

crystal report refresh update ide

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
2 2822
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
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.

Similar topics

reply views Thread by Dr. Indera | last post: by
1 post views Thread by Bob Skutnick | last post: by
4 posts views Thread by Grant Stanley | last post: by
reply views Thread by Jason | last post: by
1 post views Thread by rdshultz | last post: by
3 posts views Thread by Diggler | last post: by
1 post views Thread by Korara | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.