Member Avatar for savi_karthika

Hello
How to produce daily sales for each item in a month of a shop using dbgrid. It should give how much numbers sold for each item in every day of a month. Pls help

  • 3 Contributors
  • 3 Replies
  • 99 Views
  • 4 Months Discussion Span
  • Latest Post Latest Post by maheshsayani
Member Avatar for williamrojas78

HI

You could filter the dataset and then read the desired itmes with the filtered criteria. Like filtering the "Soda" from 1.1.06 thru 1.3.06 and then read the sales on that period of time.

Could you be a little more specific on the explanation? maybe explain the fields and fields type of the table.

Hope it helps

Regards

Member Avatar for maheshsayani

Take one combo box consists of month values

after selection of month display datagrid in the formtaof

days in month in horizontal form
item and count of items in vertical form

2 3 4 5 6 7 8 9 10

Member Avatar for maheshsayani

Hi

1 2
Itemname count on ist count on 2nd

Like Wise

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.