Member Avatar for nirvaan

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

SMS.zip (71.6 KB)
  • 3 Contributors
  • 5 Replies
  • 66 Views
  • 4 Months Discussion Span
  • Latest Post Latest Post by kishore_kke
Member Avatar for kvprajapati

What is your problem?

Member Avatar for nirvaan

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

Member Avatar for kvprajapati

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

Member Avatar for nirvaan

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

Member Avatar for kishore_kke

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.