Can anyone help with Crystal Reports

Question

2.00/5 (1 vote)

See more:

Hi guys

I have a crystal report with 3 parameters company,city,lastname

I made a form with 3 ComboBoxes
cbCompany take values from company
cbCity from city and ComboBox3 from lastname

This is how I fill the ComboBoxes

VB

Private Sub fill_city()
        cn = New SqlConnection(strCon)
        cn.Open()
        cm = New SqlCommand("Select distinct City From Staff", cn)
        dr = cm.ExecuteReader
        While dr.Read
            cbCity.Items.Add(dr("City").ToString)
        End While
        cn.Close()
    End Sub

    Private Sub fill_company()
        cn = New SqlConnection(strCon)
        cn.Open()
        cm = New SqlCommand("Select distinct Company From Staff", cn)
        dr = cm.ExecuteReader
        While dr.Read
            cbCompany.Items.Add(dr("Company").ToString)
        End While
        cn.Close()
    End Sub

The problem is that I want when I choose a value from cbCompany
the cbCity to take values only for this company

Thanks in advance

Posted 19-Jan-13 1:40am

jomachi

Updated 19-Jan-13 1:46am

Tharaka MTR

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tharaka MTR · Answer 1 · 2013-01-19T02:07:00

Solution 1

I am doubt your question is regarding Crystal Report or the form combo box logic?
your combo box should work as cascade combobox.

first fill the item to the company combo box cbCompany. then load the city combo when the user select a company. you can load the city combo with cbCompany SelectedIndexChanged event.

you have to modify the City combo stored procedure as

C#

string selectedCompany= cbCompany.SelectedValue;
cm = New SqlCommand("Select distinct City From Staff Where Company='" + selectedCompany + "'", cn)

I'm not much familer with VB.net coding. may be syntax are not correct.

Posted 19-Jan-13 2:07am

Tharaka MTR

Comments

jomachi 19-Jan-13 8:13am

Probably the syntax is wrong because now the cbCity don't show any values

Tharaka MTR 19-Jan-13 8:21am

yep, that because I'm not much familiar with VB.NET. but I think you have an idea what I'm explaining here. so, I hope you can resolve this.

please add a debug point to string selectedCompany= cbCompany.SelectedValue; place. and check wheter selected value is correctly pass to the sql or not.

jomachi 19-Jan-13 8:23am

Anyway thank you my friend