Ok I have multiple stored procedures that are are on the same form to put together counts and sums lined up next one another in various categories.

Problem number one: to line up the resultant fields next to one another like so
with these being the column headers

Received Amount Received Decisioned Amount Decisioned Approved

Amt Approved

I was initially trying doing this by using subreports and this became messy as each of the results generated a boundary in the design mode of the report so I couldn't move the subreport on the same line as the results above it.

Essentially to line up next to each other like above like they are part of one table in terms of the data.

Problem number two:I need to generate percentage columns as well in the same report based on the individual counts and the grand totals computed below them.

The total count.

Even after google searching this for a while I came up with nothing.What is the formula I need to create to handle this and do I need to use crosstab format for the report to make this happen ?

The problem is I was handed an excel spreadsheet as an idea of what the users wanted to see on this report. Excel behaves that you can put x formula in whatever cell and it will compute the result and I am not familar if crystal behaves in the same way. It seems awkward at best. I am really stuck here and have been extremely frustrated. Any ideas ?