Summary report by date

hi JessTzn, I have one report Tender Summary by Date and by Cashier also some crystal report this may help you. please send your email. and rate me once you get it.

"JessTzn" wrote:

Akber Alwani,

Thanks. You can send it to me at snipped-for-privacy@aol.com.

"Akber Alwani" wrote:

Akber, Why don't you post these reports so everyone has access? It would help us all so much and you wouldn't have to email everyone seperately. Besides which I have asked you to email me reports in the past and you never did it. There's been many reports uploaded here(I've posted many myself) so I know it can be done easily. It would just be much easier, and benefit everyone. Craig

begin 666 Custom - Tender Detail Report.qrp M+R\M+2T@4F5P;W)T(%-U;6UA

We got the report and it works beautifully. I rated your reply as being useful.

Thank you so much.

"Akber Alwani" wrote:

Please forward this to me also snipped-for-privacy@addisoncollection.com Thanks

Hi Moh.Own

Thanks for effort....

How about getting the result from your reports comparing with this

SELECT Sum(TransactionEntry.Quantity * TransactionEntry.Price) FROM TransactionEntry,[Transaction] WHERE TransactionEntry.TransactionNumber=[Transaction].TransactionNumber AND Time >= '2007-08-01' -- for example AND Time < '2007-08-02' -- for example

if the records are the same => there is no problem, if not you have to re-check your report.

Hi,

Just wanted you to know that the report you forwarded had a problem on our system. The first 12 days of the month were always reported wrong (month became year, day became month, and year became day so 1 Sep 2007 would be reported as 2009-01-07).

The solution was to change the Style code from 1 to 101 in the line CONVERT(nvarchar, [Transaction].Time,1) AS Date

We use an older version of MDSE so I'm assuming it's a difference in SQL code from a full blown, up-to-date SQL Server package. Just in case anyone else ran into the problem, I thought I'd post this.

Anyway, thanks aga> hi JessTzn,

Akber,

Please send me the report also at snipped-for-privacy@msn.com. Thanks

"Akber Alwani" wrote:

Hello Akber,

Do you have any Z summary reports that can be filtered by day, week, etc

Also do you have a sales summary report that can be filtered by date and time. (Our liquor store is open untill 1 AM and I can't get the broken out sales over the "two day" period once sales has started on the next day?

Thanks so much in advance. snipped-for-privacy@agee.com

Jay

"Akber Alwani" wrote:

Hello Mahmoud, do you have a sales summary report that can be filtered by date and time. (Our store is open untill 1 AM and I can't get the sales broken over the "two day" period once sales have started at 8 AM on the next day...

Thanks so much in advance. snipped-for-privacy@agee.com

Jay

"Mahmoud Am> Hi Moh.Own

Honestly, I would just change my system time by two hours an know that all sales are off by this amount of time.

Hi Akber, Is this report in XML file??? cause that is the limitation for MSPOS.

Thanks

-Nick

"Akber Alwani" wrote:

Hi Akber,

I just ran into this thread. Would be possible if you can send me the report snipped-for-privacy@hotmail.com

Thanx

"Akber Alwani" wrote: