Jump to content
Sign in to follow this  
mentairia

Need some Help with desired results

Recommended Posts

OK here is what I need to do!

I have a ledger report that my client wants to use but he wants it to be able to show weekly stats in landscape per employee. I got it in landscape and did all other changes just cannot get it to do the calculation that would equal the total per employee. All totals I put in page does whole report or does not function at all. I am sending the file unlocked look at it and tell me what I need to do.

Password is "master"

Thanks

The Mad Mage

LBOLEDGR.zip

Share this post


Link to post
Share on other sites

Put your SalesSummary4Report and RefundSummary4Report fields in your subsummary by employeeName part. If you don't want to see the individual info, remove your Body part and just use the Subsummary.

Share this post


Link to post
Share on other sites

OK I made the changes but the darn total will not do only one employee at a time here is changed file. It keeps calculating whole ledger

Share this post


Link to post
Share on other sites

Records must be sorted by the subsummary break field for a subsummary to be visible in Preview Mode, just in case you weren't aware.

Share this post


Link to post
Share on other sites

thanks Que Got it now

did a calc-field

getsummary(salessummary4report,employeename)-getsummary(refundssummary4report,employeename)

Worked first time thanks

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.