473,326 Members | 2,124 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

[Display record according to combobox selection in crystal report]

Kamya,
I have a problem in displaying the records from the database table after character matching from the combo box in crystal report.I m using combo box as dropdown.
I have used this code on the text changed event of combo box:

CrystalReportViewer1.ReportSource = New rpt_custsale
CrystalReportViewer1.ReportSource = cryRpt
CrystalReportViewer1.SelectionFormula = "{rpt_custpur.pur_from} like '" & cbo_pur.Text & "%'"
CrystalReportViewer1.Show()
Please help me…..
Dec 16 '11 #1
0 1390

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: mary | last post by:
I need to display 10 fields (columns) to display in a crystal Report. When I am trying to print the report some of the columns are cutting off from the report. Is there any way to display the...
0
by: FeveZ | last post by:
I want to call a general purpose webservice that will return a dataset with the required data for a given report. Each '.rpt' file is stored on a users PC, where I want to pass a ReportID to it...
0
by: michael | last post by:
Hi all, i want to know how to display multiple lines in one crystal report chart in asp.net i wrote some codes but it always display 2 lines in separate chart(please refer to the codes...
2
by: Ceri | last post by:
I have been trying to display dataset data in a Crystal Report in a Crystal Reports Viewer using VB.Net. Displaying the data from the default xtreme.mdb Access database was no problem, but when...
2
by: Ray | last post by:
Hi all, I am a new user of vb.net. I would like to ask how to choose one record from sql database in vb.net and only show that record in the crystal report. Now, I only know how to bind the sql...
2
by: krunom | last post by:
Hi, i am a newby in Crystal Reports design, and i wrote a c# windows form application that creates a DataSet. And, now i want to pass this DataSet to CrystalReport (via DataSource?) and i do...
3
by: agarwalsunitadhn | last post by:
hi... Currently i have a need for creation of crystal report. here user search according to some criteria and i want to display that search data in crystal report. So here what i need is to bind...
1
by: Rosie | last post by:
I have a main form with header info w/ 'tHeader' as the control source. I have a subform with 'tDetail' as a control source. They're strung together by a field named MA_ID. This works...
1
by: kkshansid | last post by:
i have some crystal reports but no related forms i made new simple form and copy pasted contents of a crystal report form to this new form and changed Dim Report As New CrystalReport6 according to...
2
by: Ayan Dasgupta | last post by:
I have used the =Count(*) function to display the count of records in the report footer section. Unfortunately, the display shows #Error. Please suggest me a solution to overcome this problem. ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.