Crystal Reports XI report problem URGENT

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 ?:eek2:

It can be done at sql server side
Develope a new SP that :
1.- Create a temp table with all the needed fields (results from your other sp's)
2.- Update each field from the temp table by executing every SP
3.- Select * from temp table ... this will be the recordset that CR will see

Ok how you do create percentage columns based on the values of two separate fields in SQL in this case the individual count value/total count value ? I didn't think this could be accomplished on the SQL side. As the sum total gets calculated on the report itself and not before and then on the basis of that the percentages get calculated with the total being the denominator in the ratio times 100.

That could be calculated at CR side

Quote:

---

Originally Posted by jggtz

That could be calculated at CR side

---

How is this calculated on the CR side exactly ?