
Creating a Report over a scanned image???
I am writting a vb5 payroll program. I have all the database code done.
Now I am left with having to send my biweek payroll information to a
printed form.
My problem. I know I can creat a cr report and scan an image in (the form
to be printed on) .. From there I can drop the database fields onto it
where I want it to be printed.
What I am unsure of : the form has a header that will be the same on all
pages, under that it will list the employee names and hours and pay for
that biweek. and do the same on all pages until done. Now, How to I keep
the header on all pages (which is an access field from a table), and have
the listing underneath it (employee data from another table) change down
the page?
Also, how do I send a parameter from vb5 to change the date range of the
report for each payroll period?
Can I run a Report from a recordset or resultset I query in vb5? Or do I
have to
have a table that I delete all rows each biweek, and add new payroll to ?
Example of what I want:
This date
should be updateable
---------------------------------------------------------------------------
-------------------------------------
| Employer Name .... Address . ..... Payroll Date 1/1 -
1/15 |
----------------------------------------------------------------------------
-------------------------------------
| Empoyee 1 information |
| Emoyee2 Information
............................................................... ....
|
| Employee 3 info....................................................
|
| " |
| " |
| "
|
| " |
| " |
| "
page 1 |
|---------------------------------------------------------------------------
------------------------------------|
----------------------------------------------------------------------------
-------------------------------------
| Employer Name .... Address . ..... Social Sec. Num.
.. |
----------------------------------------------------------------------------
-------------------------------------
| Empoyee 10 information |
| Emoyee Information
............................................................... ....
|
| Employee info....................................................
|
| " |
| " |
| "
|
| " |
| " |
| "
page 2 |
|---------------------------------------------------------------------------
------------------------------------|
Any help on this would be greatly appreciated!
John Barden