Question about data filtering in Crystal Report (Continue)

[Ray]

Dear Bernie,
Yes, if the same pfieldname is used. The same data will be filtered. But
I only use the code shown you before. I have not used any dataset or
datatable. How to fix the problem?
Thanks a lot,
Ray
"Bernie Yaeger" <be*****@cherwellinc.com> ¦b¶l¥ó
news:eg**************@TK2MSFTNGP15.phx.gbl ¤¤¼¶¼g...

Hi Ray,

No, the code looks fine.

Does the report use a physical table, a view, an sp or a dataset to report. I understand your point about it having been already filtered - that could
only happen, I think (since the report is closed and then again opened), if the report is using a dataset/datatable as its source.

Try this: in the second pass, use the same pfieldname; if it works, then you are correct and the data is filtered and has remained filtered. But that
would mean that the report is using a dataset/datatable. Once we know this, we should be able to fix it.

Bernie

"Ray" <so*****@microsoft.com> wrote in message
news:Ow**************@tk2msftngp13.phx.gbl...

Dear Bernie,
I use the text box to input the data name should be filtered and then
pass to the ReportDocument.
So I use the same code in the second time also. For the first time, I
call the report by input a data name to the text box while running the
program, then I close the report, then I input another data name to the
text
box and call the report again. For this time, the necessary data cannot be filtered out.
It seems that the report's data has been filtered to the data in the first time, and since the data in the second time is not within the data in the first time, so the data in the second time cannot be filtered out.
Is there any problems for my code?
Thanks a lot,
Ray

"Bernie Yaeger" <be*****@cherwellinc.com> ¦b¶l¥ó
news:eE**************@TK2MSFTNGP09.phx.gbl ¤¤¼¶¼g...

Hi Ray,

OK, looked at the code. When you call the report the second time, what
is
the value of pfieldname and what code calls the report? It must be
different code, because if you called this code again, pfieldname would

have

to be the same (ie, abc).

Bernie

"Ray" <so*****@microsoft.com> wrote in message
news:ud**************@TK2MSFTNGP11.phx.gbl...
> Hi all,
> While I use the ReportDocument of vb.net to set filter to the data to > the
> Crystal Report, it is successful for the first time while running the
> program. However, for the second time while running the program, when I > set
> filter to other set of data, all the data is lost.
>
> Please help.
> Thanks a lot,
> Ray
>
>