Adding entries from a query to the detail section of a report

[johnbtic]

Hi all

I've had some great success here in the past so I thought I'd try again for some help.

I have a query with various entries, pertaining to various invoices. Each line of the query corresponds to a piece of work done, and there may be several lines in the query pertaining to one invoice. I've written the code to input data to a report. If there are multiple lines in the query to be added to the one invoice, I don't know how to write code that will add those multiple lines in the detail section. Same type of data on each line, just basically pertains to several different lines of work.

Apologies if that's not clear, makes perfect sense to me it could be garbage to the rest of the world though

Many thanks in advance for any help and Happy Holidays to all

John

 

[Mihail]

Indeed, I don't understand your issue.
For me, a INVOICE should be in a table, and the details for that INVOICE in a child table.
Then all is simple: A report with a subreport.

 

[johnbtic]

Hi Mihail

Okay I'll provide a little more detail. Basically it's a query made of two tables. Each entry in the query relates to a piece of work and invoices are sent once monthly so if there are several pieces of work for one client in one month, these several pieces need to go into a report. I'd like to put it into a report so I can then save the reports as .pdf files and send them on to the client. The issue I have is, one client gets one invoice/report per month. I'd like to add the several pieces of work that are in the query in the detail in the report. So one detail sections, but several actual details if that makes sense.

 

[Mihail]

Create the report based on your query then, at report level, group by client.