By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 904 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

Problem in Data Report

100+
P: 123
Hi,

I have following tables:

1)Customer Master:
Fields- Name
Address
StateId
CityId

2) State Master:
Fields- StateId
StateName

3) City Master
Fields- CityId
CityName
StateId

Now, I am designing a report which should display customer details.
I want to display State Name and City Name instead of StateId and CityId. So i have designed a query using SQL Builder.

SELECT tblCustomer.CustomerName, tblCustomer.Address, tblState.StateName, tblCity.CityName, tblCustomer.Phone FROM tblCustomer, tblState, tblCity WHERE tblCustomer.StateId = tblState.StateId AND tblCustomer.CityId = tblCity.CityId

So my command object contains: CustomerName, Address, StateName and CityName. I have dragged all the fields in Detail section of Data Report.

When I run the project and open a report, I get an error message, "Report Section Do Not Match Data Source". Why i get a message?

Kinldly let me know. I am stucked with this problem. Plz tell me
Apr 11 '07 #1
Share this Question
Share on Google+
1 Reply


Dököll
Expert 100+
P: 2,364
k
Hi,

I have following tables:

1)Customer Master:
Fields- Name
Address
StateId
CityId

2) State Master:
Fields- StateId
StateName

3) City Master
Fields- CityId
CityName
StateId

Now, I am designing a report which should display customer details.
I want to display State Name and City Name instead of StateId and CityId. So i have designed a query using SQL Builder.

SELECT tblCustomer.CustomerName, tblCustomer.Address, tblState.StateName, tblCity.CityName, tblCustomer.Phone FROM tblCustomer, tblState, tblCity WHERE tblCustomer.StateId = tblState.StateId AND tblCustomer.CityId = tblCity.CityId

So my command object contains: CustomerName, Address, StateName and CityName. I have dragged all the fields in Detail section of Data Report.

When I run the project and open a report, I get an error message, "Report Section Do Not Match Data Source". Why i get a message?

Kinldly let me know. I am stucked with this problem. Plz tell me
Hello, Shailja!

I think I know what you need. I have a post here dealing with DataReport, you will no have to write too much code for it. Please look in this forum for Re: Adodc You wil get step by step instructions. Find this in page 3 0r 4 of this forum.

If you have worked hard on your code, and you like it. Please ignore my option. Post the code, I'll have a look...

In a bit!

Dököll
Apr 12 '07 #2

Post your reply

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