Printing with Groups

rbuser

I have is a stored procedure that gives me multiple rows of data and each
row of data needs to be displayed in two different formats.

I want to display the data on my report in a certain way for the group and
then in another way on a new page for the same group or row of data. I've
tried using a subreport but that does not give me the results I'm looking
for. Now I'm trying to use a region to display the data. Is there a way to
print this region on a new page then go to the next group and do the same.
Any suggestions?

Thanks for any help,
Jay

nicocizik

Hi Jay,

How exactly would you like your report to look differently page to page?
The only way to perhaps get an effect like this using Regions would be to
toggle the visibility of two separate regions based on the page number.
Please provide me with a little more information on how you would like your
report to look and I'll find the best solution for your needs.

--

rbuser

Thank you for your reply. On the first page I am formatting an invoice for
an agency which shows the total due less commissions. On the second
page I want to print information specific to the commissions. All the
information needed for the report is from one stored proc. There is no
problem
with this unless the agency has more than one individual agent and each
receives an invoice. So I need to print the main invoice then the
information
concerning the commssions for each agent.

What I've done to date is use a region for the second page and drag it to
the bottom of the page which forces a new page to be printed. Not sure
this is the best solution and what would happen if the invoice is more than
one page.

Related to this invoice I'd like to split the page in two halfs. On each
line is a different date with each agent and it can become quite long. To
save paper
is there a way to start printing on the second half after the first half
fills.

Thanks,
Jay

nicocizik

Hi Jay,

You could create the invoice in the main report, then place a Section Style
Subreport below that, separated into two columns to print the commission
information. Section Style Subreports will by default start on a new page
and act as separate reports so they should work well for your needs. If you
separate it into two columns, the page will be split and once room runs out
at the bottom, the next column will start.

--