For Programmers: Free Programming Magazines  


Home > Archive > Visual Basic Crystal Reports > January 2006 > Refresh of the recordset after loading report









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Refresh of the recordset after loading report
Gac

2006-01-22, 7:24 pm

Hi,

I'm using CR as a COM component. I pass ADO DB Recordset as datasource for
the report.
Everything works fine, but....

Imagine the following scenario:

- user designs his report using designer and views the provided
recordset
- user saves the report into a file
- user closes CRViewer
- user launches CRViewer (with updated recordset) again and loads the
report saved before

I would like that the user is able to view previously designed report, but
with new recordset (of course columns are the same, only rows are updated).
When I click REFRESH, the Connection Wizard appears. When i set manually the
source for the Report object afer loading of the report, the error occurs.
What should I do ? :-)


Regards

Gac


Shariq

2006-01-24, 7:07 pm

Did you refresh code is like the following?

- - - - - - - - -
CrystalReportViewer1.ReportSource = frmReport
CrystalReportViewer1.Refresh()

"Gac" wrote:

> Hi,
>
> I'm using CR as a COM component. I pass ADO DB Recordset as datasource for
> the report.
> Everything works fine, but....
>
> Imagine the following scenario:
>
> - user designs his report using designer and views the provided
> recordset
> - user saves the report into a file
> - user closes CRViewer
> - user launches CRViewer (with updated recordset) again and loads the
> report saved before
>
> I would like that the user is able to view previously designed report, but
> with new recordset (of course columns are the same, only rows are updated).
> When I click REFRESH, the Connection Wizard appears. When i set manually the
> source for the Report object afer loading of the report, the error occurs.
> What should I do ? :-)
>
>
> Regards
>
> Gac
>
>
>

Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com