Crystal Report binding with Dataview for runtime sorting

08-04-04, 02:44 PM

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 [url down] ***
Don't just participate in USENET...get rewarded for it!

08-04-04, 03:51 PM

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,

Similar Threads
Data binding a Crystal report to an object in a web app Hello, We want to use Crystal Reports to print a page with customer info. However, we cannot connect a new report to our object! We have looked at the samples and done the...
Binding a dataset to Crystal Reports at Runtime I tried to bind a dataset to a crystal report(Windows form) at runtime as follows: Dim obj as crystalreport1 obj.setdatasource(ds.tables(0)) The problem is though dataset...
Binding DataTable to a Crystal Report Hi, Which is the best way to bind DataTable to a Crystal Report in Winforms application. I am using a stored procedure to get the dataset. But I could'nt find a proper...
Crystal Report Data Binding problem HI, I have a problem in Crystal Report with VS.NET 2003. I am adding data to the report at design time. The problem is that I have 2 databases. First I ran report with First...
ADO Recordset binding to a crystal report at runtime I don't know if all C++ users are as frustrated as I am by the inexistent documentation of CR for C++, but I'm trying to use the equivalent of...