Need help using report as template for multiple datasets.

[thrainpa]

Hi,

I'm trying to use a single report as a letter template.
I have a subform datasheet of X amount of rows and Y amount of columns.
I want to use the report as a template to create X reports using data in the sheet.

Basically I want a report for each row using this 1 template.

Is this possible?

Thanks in advance!

 

[vbaInet]

You are thinking of Access as an Excel application. Access doesn't use Rows and Columns, it uses Records and Fields, so mentioning X rows and Y columns isn't helpful.

Create the report and link it to your table. Group by the field that uniquely identifies each record and set the Force New Page property of the group's Footer section to After Section.

 

[thrainpa]

You are thinking of Access as an Excel application. Access doesn't use Rows and Columns, it uses Records and Fields, so mentioning X rows and Y columns isn't helpful.

Create the report and link it to your table. Group by the field that uniquely identifies each record and set the Force New Page property of the group's Footer section to After Section.

Then I will be more specific, The datasheet is a subform in datasheet view which is filtered by a query.

I already have variables calculated to return the number of rows in the datasheet returned from the query, Let's call this Z, I want to open Z reports using the recordset from each row based on a single report template.

 

[vbaInet]

You will need to open a recordset which will loop through each record:

http://allenbrowne.com/ser-29.html

Then open the report using the WHERE part of the OpenReport command. See here:

http://baldyweb.com/wherecondition.htm

(Substitute OpenForm for OpenReport)

 

[thrainpa]

You will need to open a recordset which will loop through each record:

http://allenbrowne.com/ser-29.html

Then open the report using the WHERE part of the OpenReport command. See here:

http://baldyweb.com/wherecondition.htm

(Substitute OpenForm for OpenReport)

This worked, thank you.

 

[vbaInet]

Good to hear!