Jump to content
Sign in to follow this  
Randy

Saving results of find/report

Recommended Posts

I have a commission report that summarizies the total commission due to each sales person on my staff. I have 2 questions related to this report -

1. If the find results in no records found, how can I print out a no commission due report?

2. I'd like to "save" these reports (find results) to have a record of what has been paid and for which projects. What is the best way to save these results? I have considered populating a 2nd set of duplicate fields with the results, but this seems awfully repetitive and not very efficient.

Thanks in advance!!

Randy

Share this post


Link to post
Share on other sites

First of all what is the report summarizing? What is the structure of your database like? What about the reports do you want to "save"?

I am sure that your questions are easily answered, but without more information about your setup, it will be difficult to answer them without being too generic and that may not really help you.

Share this post


Link to post
Share on other sites

Kurt,

Thanks for the reply.

My report summarizies total invoice amount, total job cost, etc., and then calculates a commission amount based on the net profit and a percentage. Some of the fields originate within the database that generates the report and some are being pulled from a related database.

I'd like the ability to view/reference the report after the original time it is generated. I'd guess I should explain that the report is based on a find that pulls all invoices that have been paid by the client and that the commission status field is not paid. Once the find has been completed and the report is printed, the commission status field is marked paid. The next time commissions are due a new batch of invoices are found, if the sales staff has been doing their job.

My question of "saving" a report really extends beyond this particular report. I have many databases and applications where this ability would be handy. I have considered exporting the report(s) to Excel and saving it as reference, but if I could keep all the data within the database it would be preferrable.

Thanks for your time and expertise.

Randy

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.