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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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