Report design in rows and columns

[Khushalay]

Hi Friends

I have a form and nearly 3000 records. I need to generate a certain kind of report grouped on Delivery date arranged in blocks/tables as attached.

How can I design this type of structure in access reports.

Please help.

 

[Khushalay]

Here's is the sample in Excel.

 

[CJ_London]

if you just wanted the blocks to be presented vertically, you would simply group by the delivery date (that is grouping/sorting per the report design, not the recordsource) and design accordingly. But if you want them horizontally, for each block you will need a subreport control and a hidden field on a main report.

design your subreport report as required to appear in the block - note you only need the one since it can be used by all the subreport controls.

on your main report populate the hidden field with the delivery date for the 'related' subreport control and in each subreport control set the link master property to the name of the hidden control and the linkchild property to the name of the delivery date field in the subreport.

note that to get all the delivery dates to appear in one row to populate the main report hidden fields, you will probably need to use a crosstab query for the main report recordsource.

 

[stopher]

Create a single sub report to generate a block. Add it to you main report group so that the sub report runs for each date. At this stage the blocks will be listed vertically so go into Page Setup=>Columns and change the columns to 3. Change the Column layout to "Across then down".

 

[CJ_London]

go into Page Setup=>Columns and change the columns to 3. Change the Column layout to "Across then down".

nice one

 

[Khushalay]

Thank you so much CJ, it worked.

 

[CJ_London]

also look at stopher's suggestion - might be more flexible for you