Hello Sir,
I am doing a project realted to Jewellery Valuation. I want a report generating specifically on a customer. For that i have created a query in ACCESS to group requried tables for generating report. Now if i drop down the customer name in Page Header Section (Which is Section2). At that position i want Customer Name to be displayed which is from database. If i insert Customer Name and their products the lable for the products get repeated as well as the customer name. And If i insert a Group Header by creating a parent-child relationship in dataenvironment, it gives me error (General Error). Please suggest me any other alternative so that i can display Customer Name at top of the report. Please see the attachment if not understand.
sumeetpingale
0
Newbie Poster
Recommended Answers
Jump to PostHi,
Use SHAPE Command
sSQL = "SHAPE {SELECT CustName FROM CustMaster} AS C " & _ " APPEND ({SELECT * FROM Sales } AS S " _ & " RELATE " & _ " CustID To ID ) AS Cust_Sales "
Regards
Veena
Jump to PostHi,
That query is For the Command Object on which you design the Datareport..
Change Table/Field Names according to your database..
Regards
Veena
All 5 Replies
QVeen72
104
Posting Shark
sumeetpingale
0
Newbie Poster
QVeen72
104
Posting Shark
sumeetpingale
0
Newbie Poster
alpesh_08b091
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.