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
1  1123  
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
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Max |
last post by:
Hi wise people,
Has anyone encountered the Crystal Reports problem I describe below?
If so, how did you solve it? It seems that every article posted on
google regarding CR and logon problems is...
|
by: Spacy |
last post by:
Am creating a HTML Report in asp.net. To save this report to excel on
client-side, i write this code:
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader("content-disposition",...
|
by: ChrisWinterscheid |
last post by:
We are running DB2 8.1 on AIX 5.2.
DB2level shows:
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release
"SQL08016"
with level identifier "02070106".
Informational tokens are "DB2...
|
by: CSDunn |
last post by:
Hello,
I have a problem with field filtering between an Access 2000 Project form
(the application is called CELDT), and the report that shows the results of
the filter. Both the form and the...
|
by: David B |
last post by:
I have a report with 2 sub reports on it.
The report is an invoice and the sub reports are dropping data onto the invoice.
This worked fine if generating 1 invoice at a time.
I am trying to create...
|
by: Mal |
last post by:
I have an ACC 2000 database that has a strange behaviour
I have a small table, with just a few fields...
My report has very simple grouping and sorting, no code bar a NODATA
event.
I have a...
|
by: StBond |
last post by:
Hi everyone,
I am new to Access and Visual Basic so things my be getting across a
bit cloudy. I only started using VB for one week.
I am having a little problem with the database that I am...
|
by: Ian Davies |
last post by:
Hello
I would appreciate some help from someone who has knowledge of working with
css, php javascript and how they interact.
Ive been working on a task for the last few days and have started to...
|
by: sara |
last post by:
I have a report that runs fine with data. If there is no data, I have
its NO Data event sending a MsgBox and cancelling the report.
Then it seems I still get the 2501 message on the Open Report...
|
by: =?Utf-8?B?UmljaA==?= |
last post by:
On my development machine where I have Visual Studio 2005 loaded, I have an
app that uses the Report control. I can view data in report format with the
Report control -- the data renders OK in the...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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...
| |
