I need to write a query for the given crystal report.
The database tables and the report is attached.Please see to it.

Recommended Answers

All 5 Replies

What is your problem?

i want to write the query for this report.using these tables.pleasse help me write the query.M totally clueless:(

You should use Cross-Tab crystal report design. Do you know that?
If no then purchase good books - read them and implement your ideas.

but we need 2 again subdivid it into 2.how 2 do that?

SQL Query to generate a Crystal Report using Ms Access database

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.