forms for the report

[edwardcateuse]

How to make forms that look like accpac forms for the reports. I have a report done with crystal reports and its asks me to put to and from date. If I just open it I get an unformatted form. It is ok for a smaller report but for a one with many variables it is difficult. Do I have to develop something is VB ?
Please advice if you can I'll be grateful even if its just a word

 

[ettienne]

Use a VBA macro to create your report front end with the prompts and then send the parameters to the report.
Start by recording a macro while you print a report, you will get the part where the parameters are sent to the report, then add your front end.

 

[edwardcateuse]

Ok I get the parameters to send to the report. How do I display the report front-end. Say I am just copying a report called Trial balance to Trial balance 2. Everything is just the same so to understand the process I start the macro and run trial balance print
If I now go in report section and say "new" macro I just get a trial balance with all selected. That is not what I want. I have got the second section of taking values and printing a report correct. What I need is to replicate the same Trial balance from that is used to "collect" the variables into Trialbalance 2.
Who do I do that?

 

[ettienne]

Add a form to the macro and recreate the standard TB report front end.
The macro's starting point is MainSub(), your first line should be UserForm1.Show to show the form.
Add a Print button to the form and move your code to print the TB to the Print button click event.

 

[125teckme]

How do I modify the Payroll register into Excel file
for each employee
which can store all pay periods and by the total deduction per pay period.

example:

file name john Doe

jan 01, 08 total earning, cpp, ei, taxes, total deduction Net amount
Feb 01, 08 total earning, cpp, ei, taxes, total deduction Net amount

 

[ettienne]

You should start your own thread, not add to an unrelated thread.
Anyways, look at exporting the payroll register report to Excel, or just extract the data using a query.

 

[125teckme]

Sorry about adding my thread on your continuity.
I have difficulties to extract the data to excel because I do not know all the codes.
Any helps?

 

[DjangMan]

What experience do you have with Crystal reports or with reporting from Databases? The reason that I ask is that your question requires a long explanation. Most of us replying are Accpac consultants and while we don't mind answering questions and assisting we don't have time to do full consulting on these forums. Give us a specific question and we'll be able to answer it.

Regards,

DjangMan