473,573 Members | 2,791 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Crystal Report binding with Dataview for runtime sorting



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!
Nov 16 '05 #1
1 3136
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**********@e spnv.com> wrote in message
news:%2******** ********@TK2MSF TNGP10.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!

Nov 16 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
1897
by: Tabo | last post by:
Hi! all, I have a problem. When i created a dataset in ASP.net, then, i tried to push that dataset to crystal report. At the runtime, an error always prompted "logon failed!". How can i solve this problem? Thanks for help!. Tabo
0
1085
by: Vetril Group | last post by:
Respected sir, I created 3 parameters in Crystal Report, In my runtime form consits of main menu, if we click that menu we can data entry in the form, and if they click on the particular report the corresponding report will come. Now i come to my problem what are all the Items which i entered in data entry form it is not displayed in
1
2143
by: Joe | last post by:
Hi friends, I need dynamically generate the crystal line graph from the c# application. i used stored procedure.but i don't know how to connect the C#, stored procedure and crystal report. 1. how to call the stored procedure from C#? 2. How to integrate stored procedure and Crystal report at the runtime? If anyone knows please let me...
1
342
by: Michael Chong | last post by:
How can I change the sql query in my crystal report document during runtime? TQ Michael.
0
935
by: techsatish | last post by:
hi all, I have designed a chart using Crystal report 9.0 which comes along with Visual Studio.NET V1.1 2003.I have set the background color for my chart using the ChartExpert option...My color setting is reflected during the design mode,but not reflected during the runtime...i.e while viewing in IE 6.0 browser pls help. Thanks in advance....
1
2855
by: Eric | last post by:
Hi, Can somebody tell me a way to change the value of a textobject in a report at runtime. By the way if anyone know a way to know how many page my report are going to had in code it will be appreciate to Thanks for your help.
0
265
by: PAPutzback | last post by:
Is it possible to have a form where a user could select option for which fields they want to group a report. I'd like to have a default detail band and allow the user to group on up to two fields based on what they choose on the windows forms. Thanks, Phil
4
6439
by: kharearchana | last post by:
How can I refresh my crystal report dynamicaly at runtime ? It does not show newly added records. Archana Khare
0
1135
by: mailtogops | last post by:
Hi All, I am new to crystal report and done a small report for a project. I have a problem now. I am using Crystal Report 9.0 which comes with Visual Studio 2003 at my development envrionment. But our customer is having Crystal Report 11.0 runtime at their server envrionment which is a production site now. I supposed to go to the...
0
7676
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7991
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8045
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6376
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5567
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5275
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
1
2178
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1280
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1018
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.