View Single Post
  #4 (permalink)  
Old July 28th, 2007, 07:12 AM
Ashfaque Ashfaque is offline
Authorized User
 
Join Date: May 2006
Location: , , India.
Posts: 47
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Ashfaque
Default

You can also do it in other way..

Create simple query and make a report. Once you made the report, goto design mode of report and created header over Category field n set the property as below:
Group header = Yes, Group Footer = No, Group on = Each Value, Group Interval = 1 and Keep Together = No.

The place one unbound textbox in detail section (near to PRODUCT text box) and put in there =1 as source.

This way you will get counter that counts how many item of Meat and Fish bla bla..

Hope this helps. If not, send me your email id I will send you a sample.
Ashfaque_Online@yahoo.com
Reply With Quote