Crystal Report binding with Dataview for runtime sorting

[saima ashraf]

Hi,
I am trying to sort the data in my crystal report at runtime. The
problem is that i can only query the database once and that is at the
loading of the report. At that time i fill up my dataset. Afterwards
when the sorted data is required, i use the Dataview's sort method and
sort the data. This sorted data is perfectly shown in the datagrid. Now
i want this data to be shown in my crystal report object too. Its not
working!!!

Can anyone tell me how can i make my dataview object bound to my crystal
report viewer object successfully?

The CRViewer object is bound successfully with the dataset object but
not with dataview object. Anybody knows y?

Any help is appreciated in advance.An an early reply is what i need ;)

regards,Saima.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

One possible way is to create a new dataset and copy the data from the old
one using the dataview, I agree that this is not the most efficient solution
but it certainly solve it :)

Another possible solution is to sort the report data using a parameter, I
haven't tried this though. you will have to try it yourself.
Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"saima ashraf" <sa**********@espnv.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

Hi,
I am trying to sort the data in my crystal report at runtime. The
problem is that i can only query the database once and that is at the
loading of the report. At that time i fill up my dataset. Afterwards
when the sorted data is required, i use the Dataview's sort method and
sort the data. This sorted data is perfectly shown in the datagrid. Now
i want this data to be shown in my crystal report object too. Its not
working!!!

Can anyone tell me how can i make my dataview object bound to my crystal
report viewer object successfully?

The CRViewer object is bound successfully with the dataset object but
not with dataview object. Anybody knows y?

Any help is appreciated in advance.An an early reply is what i need ;)

regards,Saima.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!