Pls. help with Data Report

[fareezf]

Hi,

I am trying to design an invoice with data report. I am able to get all my data and I do not have any problems except the following.

The detail section of my data report include 4 fields namely A, B, C & D and I put lines around them. If there are 3 records the report appears as follows:

________________________________
| A | B | C | D | '1st Record
--------------------------------
________________________________
| A | B | C | D | '2nd Record
--------------------------------
________________________________
| A | B | C | D | '3rd Record etc.etc.
--------------------------------

Now the problem is if there aren't more than 3 records the rest of the page is left blank. What I need is a way to print blank lines on left,right,top and bottom until the end of the page even if there aren't any records.

Could someone please help me with an example? I will really appreciate it.

 

[fareezf]

Come on guys,

Somebody should have come across this problem before. Doesn't anybody have a solution for me? Please, this is urgent.

 

[johnwm]

I notice that you have so far found none of the answers given to be helpful. I suggest you review faq222-2244 carefully, especially para 15 to find out why you're not getting the answers that you want.

To answer your immediate question:

Use a fabricated recordset with the actual data in the first few lines and empty strings in the remaining records needed to fill the page. Set the DataReport recordsource to the fabricated recordset.

Also remember that this isn't a helpdesk - people will reply as and when they wish and some people will be turned off by perceived impatience.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'