Hi! I have a complicated problem here. So, I think it is better if you can login to take a look of my problem. User ID and password is tester
<!-- m --><a class="postlink" href="http://portfolio.findingsteve.net/production_system/member_login.asp">http://portfolio.findingsteve.net/produ ... _login.asp</a><!-- m -->
There are 2 sample sales report inside. The focus is DK No 0826 which is in page no 6 in sales report 2 and date 22-05-2004 in sales report 1.
How come after group together in one date, the value change?
My code is in
<!-- m --><a class="postlink" href="http://portfolio.findingsteve.net/production_system/sample_sales_report_code.zip">http://portfolio.findingsteve.net/produ ... t_code.zip</a><!-- m -->
I have put necessary code there. I zip it because I don't how to display my length code. Thanks.I can't seem to find what you are referring to... how does one 'group by date' ?
I found the entry - 0826/2004 22-05-2004 Teo Hang Sam Dai-Dan Co., Ltd.
...but there doesn't seem to be any options for sorting/grouping. If i try to click on the report to view it, access is denied.Sorry, now the link should be fine.
Actually what I meant by group by date is eg I have 5 dk no
dk no: 0826
dk no: 0824
dk no: 0823
dk no: 0825
dk no: 0826.1
with all the date is 22-05-2004.
So, when you go to sales report 1 which is group by date, these 5 dk no will be one because all of them is 22-05-2004.
Actually, I'm doing this way just for dig deep to find out what is the problem.for a group by to work you must have an item that will be duplicate and a non-duplicatable item. Like your DK.... that is a primary key I would assume.
<!-- m --><a class="postlink" href="http://portfolio.findingsteve.net/production_system/member_login.asp">http://portfolio.findingsteve.net/produ ... _login.asp</a><!-- m -->
There are 2 sample sales report inside. The focus is DK No 0826 which is in page no 6 in sales report 2 and date 22-05-2004 in sales report 1.
How come after group together in one date, the value change?
My code is in
<!-- m --><a class="postlink" href="http://portfolio.findingsteve.net/production_system/sample_sales_report_code.zip">http://portfolio.findingsteve.net/produ ... t_code.zip</a><!-- m -->
I have put necessary code there. I zip it because I don't how to display my length code. Thanks.I can't seem to find what you are referring to... how does one 'group by date' ?
I found the entry - 0826/2004 22-05-2004 Teo Hang Sam Dai-Dan Co., Ltd.
...but there doesn't seem to be any options for sorting/grouping. If i try to click on the report to view it, access is denied.Sorry, now the link should be fine.
Actually what I meant by group by date is eg I have 5 dk no
dk no: 0826
dk no: 0824
dk no: 0823
dk no: 0825
dk no: 0826.1
with all the date is 22-05-2004.
So, when you go to sales report 1 which is group by date, these 5 dk no will be one because all of them is 22-05-2004.
Actually, I'm doing this way just for dig deep to find out what is the problem.for a group by to work you must have an item that will be duplicate and a non-duplicatable item. Like your DK.... that is a primary key I would assume.