call stored procedure and populate sql ce tables

I'm coding in a black hole that has a moving target in it.

Ok, I now need to call an stored procedure and with the results from the stored procedure I need to populate my tables on my handheld.

Any ideas on how I can do this? I was using inline sql "select col1, col2, from table1" and doing my rda pull from that, but now I need to call stored procedures to do this and one sp takes a parameter. How can I accomplish this on handheld ?

Pull without tracking and use "exec sp_name <param1value>, <param2value>"

Calculation with Excel rendred values

We have a problem with Excel rendering. The target of Excel rendering should
be, that end users could use the rendered values for further calculations.
But, independent of the format of the values, we assigned within the report,
all cells have to be converted manually after excel rendering in order to be
able to use them for calculations. Where are we wrong?We are having the same problem when exporting to Excel. We're formatting our
cells using the following: #,##0.00;(#,##0.00)
The reason for this format is to show the numbers without the currency
symbol. Unfortunately, when we use this format Excel interprets it as text
instead of a specific number format. Like you, we have to manually convert
the cells to numbered formats to use them for calculations.
"Niklas" wrote:
> We have a problem with Excel rendering. The target of Excel rendering should
> be, that end users could use the rendered values for further calculations.
> But, independent of the format of the values, we assigned within the report,
> all cells have to be converted manually after excel rendering in order to be
> able to use them for calculations. Where are we wrong?