By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,830 Members | 682 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,830 IT Pros & Developers. It's quick & easy.

Report Data Problem

P: 35

I have a report named Sale & Stock Statement.
I have opened said report from date (01/01/2018) to date (19/01/2018) using parameter. I want to set my "Balance" as "Opg.Bal" on changing my dates for next month i.e. from date (01/02/2018) to date (28/02/2018). Can anyone help me?? Picture is also attached alongwith this question.
Attached Images
File Type: jpg Pic.jpg (73.4 KB, 33 views)
Jan 23 '18 #1
Share this Question
Share on Google+
4 Replies

Expert Mod 2.5K+
P: 3,205
Aftab Ahmad,

I'm not sure exactly what you are asking. Could you provide a little greater detail about the specifics and then let us know what you have tried in the past and what the results were?

Jan 24 '18 #2

Expert 100+
P: 1,430
Much depends if you have the Db set up correctly.

You should have a table of products and a table of transactions (Receipts & Sales) and the balance at ANY point of time (specifically at the beginning of the month) is simply the sum of all receipts to the specific date - the sales to that date.

Jan 24 '18 #3

P: 35
Thanks guys problem solved with a different method. I have used bypass queries for getting my values
Jan 31 '18 #4

Expert Mod 15k+
P: 31,418
Aftab Ahmad:
I have used bypass queries for getting my values
Would that be PassThru queries you're referring to?

May I suggest that getting past a single problem is not your most important issue. Problematic design can easily be got past. Nevertheless, until it's dealt with you will never stop suffering from related problems.
Feb 1 '18 #5

Post your reply

Sign in to post your reply or Sign up for a free account.