Create 2 columns on Page 2 of a 2 page report only?

[padlocked17]

I am looking to create a 2 page report per individual. On the second page of the report, I want to have two columns.

Is there a way to accomplish this? I'd love to be able to specify which section (according to a SectionID in a table) which column that particular section would go in.

Do I need to create subreports to accomplish this? If so, how do I specify that I want the columns on only page 2?

To further piggyback on this, can I create two reports (Page 1 & Page 2) and then somehow create a PDF by combining the two reports based on the MemberID?

Thanks.

 

[dkinley]

I think for columns in reports it's an all-or-nothing sort of deal, so I would be prepared for subreports.

It would be alot to type, but I will offer this link as a reference. There is a sample I put on there which may provide some insight ... well, as to how I would approach the problem.

This particular sample uses columns but once you see the subreports I think you will get the gist of how to go about your first page (single-column) and your second page (multi-column). If you look at the underlying queries for the sample of the subreports and main report - you should be able to follow that to link on your MemberID (whereas the sample uses State name).

HTH,
-dK

 

[padlocked17]

I took a look. Are you thinking I'll need to create two separate reports and then combine then?

 

[dkinley]

My initial proposal would be you only need to create the 2nd one (for the columns). This would hinge on the underlying query driving the main report. If it has the MemberID that you want to use for the linking of the column report then you should be good to go. In this manner, the main report and subreport will only show information for that particular member (probably structured much like the forms you probably have built for the data input).

In the past I have had to build them seperately and used a different type of query to join them all together on the same report ... again, this depends on the data structure but if you do it for the forms - it should not be an issue for following the same method for the reports.

The only other piece I would advocate is using a hard line-break in the report in the details section between the 1st report and the 2nd (sub) report.

-dK